In the Wizard
Choose your source -->Next
Choose your destination-->Next
Choose Select Objects to Copy-->Next
Uncheck Copy All Objects
Uncheck Use Default Objects
Choose (Select Objects Button)
Select those items you want to copy
Click ok
Choose (Options Button)
Set up the appropriate items.
Run or schedule the DTS.
Another thing that I usually do is script the database including the
relationships (from Right Click, all tasks, choose (generate SQL).
I then create two scripts from that, one for the tables and the others to
apply the relationships. I have found (and I am not a SQL guru so I am
probably doing it wrong) that sometimes when I create a new database and
import data that some data doesn't move over because of foreign key
constraints. So if I copy the data over without the indexes, then run the
sql script containing the indexes, constraints etc, that it works better.
Sandy Clark
http://www.shayna.com <http://www.shayna.com/>
CF Pretty Accessible at http://www.shayna.com/blog
Now offering 4 days Hands on CSS training October 11-14th. Rockville, MD.
For more information go to:
http://www.teratech.com/training/oc_classes.cfm#css
_____
From: Mike Kear [mailto:[EMAIL PROTECTED]
Sent: Friday, September 24, 2004 5:25 AM
To: CF-Talk
Subject: Re: Backing Up off of server (WAS RE: Doug White - clickdoug.com)
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]
