Home > IT Answers > Database > Bulk Insert with collation change
Db23
290 pts.
 Bulk Insert with collation change
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

Software/Hardware used:
ASKED: May 26, 2009  1:48 AM
UPDATED: May 30, 2009  3:24 AM
RELATED QUESTIONS
Answer Wiki:
You can't import the system tables. These hold the schemas of the objects that you are already scripting out.
Last Wiki Answer Submitted:  May 30, 2009  3:24 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _