A migration question

[rasindia]

Hi all,
We have SQL 6.5 database and looking for a perfect migration to SQL 2000. We are going to have a new server for SQL 2000. Can anybody advice me the best steps for the migration from old SQL 6.5/Server to new SQL 2000/server?

Thanks

 

[Yaniv72]

Hi,
On the Sql Server 2000 there is a tool called:
'Microsoft Sql Server - switch -> Sql server upgrade wizard'
Use it.
Yanuv

 

[rasindia]

Thanks Yanuv!

I can use the migration tool. But, my issue is explained in the question. We are using a new server with SQL2000 on it. How can I migrate the Ver. 6.5 database of the old server to the new one? Can you advice me with some good steps for that?

1]I need the new server to have my databse from the old one.
2]Old database is on a server with SQL 6.5
3]New server is SQL 2000.
4]I need steps to move from old server to new server and migration from 6.5 to 2000.

Thanks

 

[Yaniv72]

Hi,
Please read the section 'Upgrading Databases from SQL Server 6.5 (Upgrade Wizard)' in the Books Online of SQL 2000.
You will find all the information there.
I made the upgrade,few years ago, from 6.5 to 7.0 and it's not a big deal.
As far as i can see you know what to do (steps 1 -> 4)

Good luck
Yaniv

 

[tlbroadbent]

I recommend reading the upgrade information provided by Microsoft.

How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000

http://www.microsoft.com/technet/prodtechnol/sql/deploy/upgrdmigrate/sqlugrd.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.