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?
May 26, 2009 1:48 AM
May 30, 2009 3:24 AM