Re: Moving a database from Sort order 44 to Sort order 52
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/07/04
- Next message: Umut Nazlica: "Re: Strange problem?"
- Previous message: Hari Prasad: "Re: Need to copy a database in the same server without using backup re"
- In reply to: Nick: "Moving a database from Sort order 44 to Sort order 52"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 7 Jul 2004 10:57:39 +0530
Hi,
Upgrade wizard can not be used if the sort order id is different. The easy
way is :-
1. From SQL 6.5 Enterprise manager -- Object Menu -- Generate SQL Script.
2. Generate the script for all objects
3. COpy the Script to destination SQL 7 server
4. Create a new database in SQL 7 and execute the script. Ensure no error
occured
5. Use the DTS utility or BCP OUT/ IN to load the data into SQL 7
If you have huge volume of data it is recommended to go for BCP OUT, copy
the files to local SQl 7 server
and BCP IN.
-- Thanks Hari MCDBA "Nick" <Test@test.com> wrote in message news:elDz5$5YEHA.3664@TK2MSFTNGP12.phx.gbl... > Can anyone point me in the right direction on the best way to take a SQL 6.5 > sort order 44 database and move it and the data to a SQL 7.0 sort order 52 > database ? The 6.5 to 7.0 part I got down (SQL Upgrade wizard). But this > sort order change has me dizzy.... > >
- Next message: Umut Nazlica: "Re: Strange problem?"
- Previous message: Hari Prasad: "Re: Need to copy a database in the same server without using backup re"
- In reply to: Nick: "Moving a database from Sort order 44 to Sort order 52"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
