Bulk Insert with collation change
Home > IT Answers > SQL Server > Bulk Insert with collation change
Db23
230 pts.
0
Q:
Bulk Insert with collation change
SQL Server 2000, Database migration, Database collation, Bulk Inserts, 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 GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46765 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
You can't import the system tables. These hold the schemas of the objects that you are already scripting out.
Last Answered: May 30 2009  3:24 AM GMT by Mrdenny   46765 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0