copy a DB from sqlServer to another sqlServer

[Maoz]

I am using sqlServer 7 and i have to copy the DB
to another sqlServer the problem is that they are'nt at same version (on the setup there is typical and couple of more option for setup).
I keep getting an error that something is'nt good with the sort of the sqlServer.
any idea?
thank's
Maoz

 

[Andel]

They may not work properly if the sort order on both servers are not the same. Execute "sp_helpsort" on both servers and see their differences.

Andel
andelbarroga@hotmail.com

http://andyb.8m.com

 

[Bernadette]

Hi There Maoz,

If you discover that the 2 servers have a different sort order, you will have to either reinstall sql server on one of them and choose the correct sort order, or rebuild the master database to change the sort order

TO REBUILD THE MASTER DATABASE
(taken from BOL)

1. Shutdown SQL Server; then start it in "single user"
sqlsrvr -m

2. Run Rebuildm.exe in the \Mssql7\Binn directory.
3. Click Browse.
4. Select the \Data folder on the Microsoft® SQL Server™
compact disc or in the shared network directory from
which SQL Server was installed; then click OK.
5. Click Settings. Verify or change the character set, sort
order, and Unicode collation used for the master
database and all other databases.

The default character set, sort order, and Unicode
collation are shown initially, which may not be the
values selected during SQL Server Setup. You can select
the same combination used earlier or select a new
combination; then click OK.

6. Click Rebuild.
The Rebuild Master utility reinstalls the master
database wity the new sort order and settings.






Hope This Helps
Bernadette

 

[skfoster]

If copy old version to new, the easier way is using sql native backup and resore.

 

[Cagliostro]

I think this is a char set conflict. John Fill

 

[Psychpt]

DTS create a package this works best especially with large databases and schedule it to run when noone is using it.

You can do just about everything with DTS

HTH