RATE THIS ANSWER
0
Click to Vote:
- 0
0
Last Answered:
Apr 29 2008 5:01 PM GMT
by Mrdenny
The first thing to do will be to get the SQL 6.5 databases into SQL 7 or higher. This is done by restoring the SQL 6.5 database to another server with SQL 6.5 on it, then installing SQL 2000 on the machine. SQL 2000 will include a SQL 6.5 upgrade system which will help you do the upgrade. I recommend doing this on a seperate machine in case something goes wrong.
After the databases are all in SQL 7 or above, you can take a full backup of them, and simply restore them to a SQL 2005 server.
SQL Server database consolidation, SQL Server upgrades
We have 52 SQL Server databases on different SQL Server versions (6.5,7.0,2000). We need to consolidate all the databases into a single SQL Server 2005 database. The structure is almost the same for all the databases, i.e.,tables/datatype. The actual data is different in all the databases. Could you please provide advice or links to documents that would help consolidate these different SQL Server database versions to SQL Server 2005? 
