[A] I posted here, because I realised that CF-Talk wasn't really the place
to be asking about how to use SQLServer2000
[B] I did what Sandy said (or I thought I did) and still the default values
and the identity field settings weren't transferred. I still have to go
through and do all that table by table. Did I miss something? When you
do it, do the tables copy from one to the other and are fully usable and
identical to the source, without any other table design work on your part?
Cheers
Mike Kear
Windsor, NSW, Australia
AFP Webworks
http://afpwebworks.com
.com,.net,.org domains from AUD$20/Year
_____
From: Kay Smoljak [mailto:[EMAIL PROTECTED]
Sent: Saturday, 25 September 2004 7:49 PM
To: SQL
Subject: Re: SQLServer - how to copy the database including keys
Mike,
On Sat, 25 Sep 2004 11:55:47 +1000, Michael Kear <[EMAIL PROTECTED]>
wrote:
> I'm using SQLServer2000, and whenever I copy the production databases to
my
> local server to use as testing databases, the DTS doesn't copy the
default
> settings
You need to select "copy objects and data" rather than "copy tables" -
I think Sandy already posted that. The other thing I've found is that
I usually need to have the same username - with the same password and
the same permissions - on the destination database as the source
database.
HTH,
K.
--
Kay Smoljak
http://kay.smoljak.com/
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
