How do you make EM suck the remote database down, replace the tables
etc, but set up the identity indexes and primary keys?

I find when I use DTS to bring a table into my local database, the
identity attribute isnt set on the ID field, and the ID field isnt set
as primary key,  so when I'm doing testing inserts fail.

Is there an option somewhere I'm missing?

Cheers
Mike Kear
Windsor, NSW, Australia
AFP Webworks
http://afpwebworks.com
.com,.net,.org domains from AUD$20/Year

----- Original Message -----
From: Bryan Stevenson <[EMAIL PROTECTED]>
Date: Thu, 23 Sep 2004 10:21:02 -0700
Subject: Re: Backing Up off of server (WAS RE: Doug White - clickdoug.com)
To: CF-Talk <[EMAIL PROTECTED]>

Ahhh...you didn't pick the right option....don't just pick the "copy
all tables" option (or whatever it's called...it's the default
selection)...there's another option on the same screen that says
something along the lines of "Copy objects and data...".

After picking that you can pick which objects to pick (think the
default is everything)

HTH

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to