June 27, 2003 at 7:44 am
Hi
I'd like to migrate a DB from a collation name (server 1) to another (server2).
Is it possible ? should I use export data ?
Should I check "collation use" ?
June 30, 2003 at 8:00 am
This was removed by the editor as SPAM
June 30, 2003 at 10:18 am
I am assuming that you want to change collations in your migration. If so, then yes it is possible if you are running SQL Server 2000. Not sure off the top of my head but I believe you would use the alter database command to change the database collation. That however would only change the database collation (future objects will be created with new collation) and you would still have to change the object / data collation which is done with an alter table command. All columns can be changed except the Text columns from what I remember.
The other option would be to use the export data method as you mentioned. Create scripts (removing old collation statements from script) for the database, objects, etc and run them on the new server. Pump the data across and all should be well. This is probably the cleanest solution but will require the most work.
If you are running SQL Server 7.0 the latter option is your only choice.
Hope this helps and have fun. It has been a long time since I had to deal with collation tweaks but the pain remains.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 1, 2003 at 1:25 am
Yes it helps me. My server is SQL server 2000.
But I cannot change collation when the column is indexed and other fun alert of SQL server.
How do you do the changing of the old collation name of all tables ?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply