What is the best way of brining a SQL Server 6.5 database to a Consolidated SQL Server 2000 environment? I tried using the SQL Server 2K upgrade wizard and it failed to import some data, which made me uncomfortable in using this tool?
Is this a safe approach:
Create a database on SQL 2K and script out all the objects like tables, Indexes, views and run it against SQL 2K.
Then run the DTS to populate all the tables and you are done?
I had not heard of the upgrade tools not being able to bring over data. Do you remember the error details? The plan you have outlined will most likely work, except for a few gotchas on the stored procedures (check for "a = null" rather than "a is null"). For the most part, what you have outlined is exactly what the upgrade tools are doing.