Very Computer

Dear all,
I have 2 servers, one on SQL7 and one on SQL2000.
The SQL7 one is the old one while SQL2k is the new one.

Apart from importing all the databases individually one
by one using DTS manager is there another way of copying
all the databases from one server to the other in one
blow ???? I am only interested in Tables (and maybe
queries)

Any advice much appreciated
Taipan

Isn't the backup/restore working ?
Or DTS of the whole database ?

Quote:>-----Original Message-----
>Dear all,
>I have 2 servers, one on SQL7 and one on SQL2000.
>The SQL7 one is the old one while SQL2k is the new one.

>Apart from importing all the databases individually one
>by one using DTS manager is there another way of copying
>all the databases from one server to the other in one
>blow ???? I am only interested in Tables (and maybe
>queries)

>Any advice much appreciated
>Taipan

>.

But in DTS you can only specify one database what happens
if you have 500 ??????

taipan

Quote:>-----Original Message-----
>Isn't the backup/restore working ?
>Or DTS of the whole database ?
>>-----Original Message-----
>>Dear all,
>>I have 2 servers, one on SQL7 and one on SQL2000.
>>The SQL7 one is the old one while SQL2k is the new one.

>>Apart from importing all the databases individually one
>>by one using DTS manager is there another way of copying
>>all the databases from one server to the other in one
>>blow ???? I am only interested in Tables (and maybe
>>queries)

>>Any advice much appreciated
>>Taipan

>>.

>.

In SQL 2000 machine run SQL Enterprise Manager, Select your SQL 2000 server,
select databases and right click -> ALL Tasks -> copy database wizard... be
sure to copy and leave the orig in place if you need the database to remain
at the SQL 7 location... This is actually doing an sp_detach and sp_attach,
which you may do manually if the wizard doesn't suit your needs...

--
Wayne Snyder SQL Server MVP
IKON Education Services, C*te, NC
(Please Respond to newsgroups)

You could also write a sql script to generate back and restore scripts.  A
SQL Server 7 dump can be loaded into SQL 2000.

.Richard

Quote:> Dear all,
> I have 2 servers, one on SQL7 and one on SQL2000.
> The SQL7 one is the old one while SQL2k is the new one.

> Apart from importing all the databases individually one
> by one using DTS manager is there another way of copying
> all the databases from one server to the other in one
> blow ???? I am only interested in Tables (and maybe
> queries)

> Any advice much appreciated
> Taipan