You can't enforce a relationship between databases with foreign key constraints, but you may be able to do it with triggers or, possibly, replication.

Greg

You can script out tables in Enterprise Manager or Query Analyzer.  You can also export table schema without data to another database using the DTS Import/Export wizard.  Just choose 'Copy...

I document with comments in the package.  I include a description of what the package does, the job that executes the package if it's scheduled, and a description of any...

I can't recommend a training vendor but you should try to find the course, Microsoft SQL Server High Availability 2005.  I took the course last year, taught by Michael Hotek,...

I believe you can use detach/attach or backup/restore.  Microsoft has an article: http://support.microsoft.com/kb/281574/en-us 

Greg

Hi Darren,

Data Driven Query is useful because it can insert, update, and delete from the destination table based on each row of the source data.  The drawback is it processes...

Hi Steve,

What error do you get when the task fails?  If you haven't enabled package logging, do so by selecting "Package Properties", the "Logging" tab, then checking "Log package execution...

Betty,

I don't know anything about Datanamic.  I run queries in Query Analyzer to find foreign key dependencies and script the ALTER TABLE statements to drop and create them.  Here they...

It sounds like you're using Enterprise Manager to do the restore.  In the 'Restore database' popup, make sure you choose the correct backup device/file in the dropdown called 'First backup to...

Hi Lonnie,

What's the date of the full database backup immediately preceding 01/08/2006?  You have to start your restores with a full backup then restore differential backups and log backups.

Greg

Papillon,

Enable logging for the DTS package if you haven't already.  When the job fails, look at the package log to see the DTS error and the failed step by right-clicking...

I'd been a developer in a government shop for eleven years when a position opened in our Data Management Group for a DBA/DA.  I got the position and trained as...

...or drop all the foreign key constraints before dropping the tables.  If you drop the constraints first, you won't have to worry about what order the tables are dropped.

Greg

Here's a thread that has a suggestion for how to set this up.  There are also lots of backup scripts in the Scripts section of this site that you could...

This thread has some suggestions: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=6&messageid=1666

Greg