drop it for now and come back to it later. I think you should call it a day
now too, even though it's not as late all the way over there on the left
hand side of the island. <G>
Thanks for caring enough to respond, and I think that if I do it again,
taking special care to follow your instructions carefully I'll see there was
something I either didn't understand properly, or a check box I missed or
something like that. I'll have another go, taking it slower tomorrow.
Thanks again.
Cheers
Mike Kear
_____
From: Kay Smoljak [mailto:[EMAIL PROTECTED]
Sent: Saturday, 25 September 2004 10:26 PM
To: SQL
Subject: Re: SQLServer - how to copy the database including keys
Hi Mike,
Yes, I use defaults like GETDATE() and primary keys, and yes, they do
get transferred between databases when I do "copy objects and data". I
think the key is to have the users identical in both databases. When
you transfer using "copy objects and data" does it complete
successfully? If you uncheck "use default options" and go into the
object selection, I think there's an option for keys and defaults...
but I don't have EM here and I can't remember what it's called. Are
you using SQL Server 2000?
K.
On Sat, 25 Sep 2004 21:56:17 +1000, Michael Kear <[EMAIL PROTECTED]>
wrote:
> Thanks Kay,
>
> [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?
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
