Bulk Insert with collation change

290 pts.
Tags:
Bulk Inserts
Database collation
Database migration
SQL Server 2000
System tables
Hi, One of our client wants to change the collation of the database and the collation of the columns from SQL_Latin1_CP1_CS_AS to SQL_Latin1_CP1_CI_AS to match the SQL Server setting. So we are moving the data from one database to another database on the same server. We are re creating the database with the database and columns set to the new collation using the Generate SQL Script, then using bcp to export the data and bulk insert to import the data. Just wondering if we need to also export the system tables, and then bulk insert the system tables as well, currently we are only copying the user table and views data over? Thanks
ASKED: May 26, 2009  1:48 AM
UPDATED: May 30, 2009  3:24 AM

Answer Wiki

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

You can’t import the system tables. These hold the schemas of the objects that you are already scripting out.

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