Copy SQL 7.0 db to SQL 2k

Hi all;
Is there a procedure to copy a database from 7.0 to 2K or can in fact a 7.0
db be copied into 2K?
Do I have to perform a backup/restore situation for this db or are there
possibly some CLI commands for a db copy?
Thanks in advance.
Steve
There is no "Copy" command per say but you can either do a Restore or a
sp_attach_db. Both operations will take a 7.0 db and upgrade it to a 2000
db and leave the data and objects etc intact.
Andrew J. Kelly SQL MVP
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F4B16A4D-126A-4BDA-A16D-8BB57CD7A301@.microsoft.com...
> Hi all;
> Is there a procedure to copy a database from 7.0 to 2K or can in fact a
> 7.0
> db be copied into 2K?
> Do I have to perform a backup/restore situation for this db or are there
> possibly some CLI commands for a db copy?
> Thanks in advance.
> Steve
|||Hi Steve,
One of the easiest method is using backup/restore.
Thanks
Yogish
|||Keep in mind the collation type...
--
Sasan Saidi
MSc in CS, MCSE4, IBM Certified MQ 5.3 Administrator
Senior DBA
"Yogish" wrote:

> Hi Steve,
> One of the easiest method is using backup/restore.
> --
> Thanks
> Yogish