I want to copy a couple of databases from an SQLServer7 installation
running on an NT4 server to SQLServer2K Developer Edition running on a
WinXP Pro workstation. I'm trying to do this with the "Copy Database
Wizard" but I can't figure out how to tell it where the source
databases are.

Both computers are on the same physical LAN but the new one is a
workstation in a workgroup named "ENGINEERING" whereas the old one is
an NT4 server named "NTServer1" (with a domain named "KVK"). The
dropdown on the 1st page of the wizard does not show NTServer1. When I
key it in (as \\NTServer1), it cannot find it.

Can someone tell me how to specify this so that the wizard can find
the source databases? I assume the problem has something to do with
the workgroup vs. the domain?

Thanks.

Two things to try

1. In cliconfg register the servers by IP address. Name resolution
will be done using that.
2. Forget DTS. If you are moving a whole database or 2 in entirety
then use BACKUP and RESTORE. Cleaner and easier.


Allan

"Martin" <martinvalley (AT) comcast (DOT) net> wrote

Thanks Allan -

I have no idea what "cliconfg" is. A Google search for it indicates
it's some kind of dll that involved some way with a bunch of viruses.

I've tried the BACKUP and RESTORE approach. But I can't get anywhere
with that either. The SQL Server books online have a lot of stuff
telling me that it CAN be done but very little on HOW to do it. Most
everything ends up leading me back to the Copy Dataabse Wizard. I was
able to do a Restore but it errored out telling me I had to use "with
move". For the life of me I cannot see how to specify any such thing
and, again, all the MS documentation says it CAN be done but not a
clue as to HOW to do it.

Can you possibly suggest somewhere that I might find some clear
instructions as to how to copy or backup-and-restore my databases from
one computer to another?

Thanks again.


On Thu, 10 Mar 2005 18:51:45 +0000, "Allan Mitchell"
<allan (AT) no-spam (DOT) sqldts.com> wrote:

OK

Cliconfg comes with MDAC

Start | Run | Cliconfg

The reason why RESTORE says "Move" is because you have a situation
similar to this

Database 1 on server 1. Data Files are in f:\MyFiles\

When you try to restore the DB on Server 2 SQL Server looks to put the
files back in the same location. If you have no F:\MyFiles\ then it
will blow so you would need to do


RESTORE DATABASE MyDB FROM DISK = 'Path to the .Bak file'
WITH MOVE 'Logical data File Name' TO 'New physical Path and file name',
MOVE 'Logical log File Name' TO 'New physical Path and file name'




"Martin" <martinvalley (AT) comcast (DOT) net> wrote