How to consolidate databases from different SQL Server versions to one SQL Server 2005 database
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
April 28, 2008 3:45 PM
UPDATED:
April 29, 2008 5:02 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.