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]
