SQL Server Performance Forum – Threads Archive

From SQL 6.0 to SQL 2000

Hi I need to transfer all existing data about 3 GB from SQL 6.0 to SQL 2000.
How to do this?
Also i need to do transaction replication from 6.0 to 2000 on regular basis.
It will be help if you can give some relevant links on this. Thanks Harry

You have to upgrade from SQL 6.0 to 6.5 and then to SQL 2000 by referring to thishttp://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx &http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1057963,00.html links. For transactional replication I’m not sure whether it will support on SQL 6.0 version from SQL 2000. May check books online. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi Satya, Thanks for your reply.
The links you have given are upgrade from 6.5 to 2000.
Iam looking for one time transfer of data.
There is something called transfer manager in 6.0.
If possible can you highlight any precautions to be taken for this transfer. On Replication i got some info from this link.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replimpl_4joy.asp Can you give some links to step by step instructions for this replication. Thanks Harry

]]>