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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!