Help on migrating from SQL7 to SQL2K

Hi,
We just installed a new server with SQL2k (OS win2k) on it. We have an old
SQL7.0 server (OS NT4). It has a few databases, jobs, packages and etc. I
like to transfer and convert all the data from SQL 7.0 to the new SQL 2k
server. Can someone tell me what is the best way to do so?
Thanks,
SarahSG,
Might want to read:
http://www.microsoft.com/technet/pr...oy/sqlugrd.mspx
and
http://support.microsoft.com/defaul...kb;en-us;261334
HTH
Jerry
"SG" <sguo@.coopervision.ca> wrote in message
news:eh7GZE3yFHA.3812@.TK2MSFTNGP09.phx.gbl...
> Hi,
> We just installed a new server with SQL2k (OS win2k) on it. We have an old
> SQL7.0 server (OS NT4). It has a few databases, jobs, packages and etc. I
> like to transfer and convert all the data from SQL 7.0 to the new SQL 2k
> server. Can someone tell me what is the best way to do so?
> Thanks,
> Sarah
>
>|||Hi Jerry,
I found that there is a "Copy database wizard" on sql2k, would that be the
best solution in my case?
Thanks,
Sarah
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OFsm4K3yFHA.2064@.TK2MSFTNGP09.phx.gbl...
> SG,
> Might want to read:
> http://www.microsoft.com/technet/pr...oy/sqlugrd.mspx
> and
> http://support.microsoft.com/defaul...kb;en-us;261334
> HTH
> Jerry
> "SG" <sguo@.coopervision.ca> wrote in message
> news:eh7GZE3yFHA.3812@.TK2MSFTNGP09.phx.gbl...
>|||Do you want to replace the existing SQL Server 7 with SQL Server 2000? If
so then the copy database wizard is probably not the best solution. This
wizard is useful at bringing a database over from an existing 7 install to a
new install of 2000 - easier to test database by database this way while
maintaining the originating install.
HTH
Jerry
"SG" <sguo@.coopervision.ca> wrote in message
news:e4GlMs3yFHA.1168@.TK2MSFTNGP15.phx.gbl...
> Hi Jerry,
> I found that there is a "Copy database wizard" on sql2k, would that be the
> best solution in my case?
> Thanks,
> Sarah
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OFsm4K3yFHA.2064@.TK2MSFTNGP09.phx.gbl...
>