Tuesday, September 28, 2010

Can't initialize OCI Toad on Vista

Right-click on the Toad icon and choose "Run as Administrator".

Monday, September 27, 2010

SQL 2008 to SQL 2005 Conversion

1. Create a new 2005 Database
2. Use SQL Compare to copy the Schema. If you copied the constraints, you need to deleted them creating a script using the following:

SELECT 'ALTER TABLE ' + TABLE_SCHEMA + '.[' + TABLE_NAME +
'] DROP CONSTRAINT [' + CONSTRAINT_NAME + ']'
FROM information_schema.table_constraints
WHERE CONSTRAINT_TYPE = 'FOREIGN KEY'

NOTE: You have to run the output of the SQL above to actually delete the constraints.

3. Use SQL Management Studio “Import Data” to copy large tables (memory error if SQL Data Compare is used).
4. Use SQL Data Compare to copy smaller tables
5. Use SQL Data Compare to generate a script if it does not work within SQL Data Compare and open / run the script in SQL Management Studio.
6. Re-run SQL Compare to add back the constraints

Check This Out!

More Links to Good Information