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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!