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?
April 28, 2008 3:45 PM
April 29, 2008 5:02 PM