setting that my ID fields had to be identity fields and no primary key
was set, and nor were the default settings.
Is that why you have to script it first? Even when you run the
generate scripts, it doesnt script the identity settings and the
primary key setting, or the default settings.
What am I doing wrong here? It's very tiresome to have to go through
every table in the database and set all these things manually. Not
to mention error prone, since it relies on my remembering which fields
need which settings, on the 27 database I maintain backups for.
(Perhaps I should move this discussion over to the SQL list after this)
Thanks
Cheers
Mike Kear
Windsor, NSW, Australia
AFP Webworks
http://afpwebworks.com
.com,.net,.org domains from AUD$20/Year
----- Original Message -----
From: Sandy Clark <[EMAIL PROTECTED]>
Date: Fri, 24 Sep 2004 07:36:22 -0400
Subject: RE: Backing Up off of server (WAS RE: Doug White - clickdoug.com)
To: CF-Talk <[EMAIL PROTECTED]>
Right Click on your database, under all tasks choose Export data
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
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
