Migrating data from a SQL Server 2005 database to SQL Server 2000

Tags:
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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?

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following