I have two instances of SQL Server 2005 running on two different servers on the same network. One of the instances’ sort order is the default sort of SQL Server. The second one is running Latin 1 General Binary sort. I would like to move two of the databases from the first instance to the second one. Can I use the Copy Database Wizard or detach/attach to move it then change the sort order of the moved databases?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Move DB to a server with different sort order
- Thread starter BlueTube
- Start date
ptheriault
IS-IT--Management
Yes you can move the database any way you want to then change the sort order.
- Paul
- If at first you don't succeed, find out if the loser gets anything.
- Paul
- If at first you don't succeed, find out if the loser gets anything.
- Thread starter
- #3
ptheriault
IS-IT--Management
To change it at the database level you would use the alter database command.
I'm not sure if that is your collation or not but that is the command.
- Paul
- If at first you don't succeed, find out if the loser gets anything.
Code:
ALTER DATABASE db_name COLLATE SQL_Latin1_General_CP437_BINI'm not sure if that is your collation or not but that is the command.
- Paul
- If at first you don't succeed, find out if the loser gets anything.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question