Migrating data from a SQL Server 2005 database to SQL Server 2000
SQL Server 2000, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server Database Migration, SQL Server migration
I am looking for advice on what technology to use to migrate data from a SQL Server 2005 database to SQL Server 2000. We are currently phasing out our old help desk ticketing system in SQL Server 2005 to a new ticketing system in SQL Server 2000. The tables in the databases are not identical because the software is from two different vendors. However, the majority of the tables have similar fields. So far, I really only have about 3 tables pertaining to the ticketing system to deal with in the migration. I was thinking about simply using the SQL Server 2005 export wizard to get the 3 tables and data over to SQL Server 2000. Is this a reasonable solution?
Software/Hardware used:
Software/Hardware used:
ASKED:
January 26, 2009 7:52 PM
UPDATED:
January 27, 2009 1:10 AM
Answer Wiki:
Using the import/export wizard will probably be the easiest way to move the data.
The question then becomes why are you moving to a ticketing system which is having you use SQL 2000 (a pretty much unsupported database platform) as its database?
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
