constraints failed to export - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Replication (2008)

constraints failed to export

Author

Topic

Zim327
Yak Posting Veteran

62 Posts

Posted - 2011-09-07 : 12:56:04

Hi, apologies if this is the wrong forum but
My dba exported a SQL 2008 database I created and to make a long story short: I realized that the constraints were missing.
I remember the same thing happening to me when I tried exporting a db on sql 2000 and 2005 express

I checked off everything in DTS but the constraints get left behind.

What's the procedure for exporting everything?

Thanks,

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-09-07 : 21:33:17

backup and restore.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2011-09-09 : 15:06:12

if backup and restore is not an option:
1. script out the database and all associated objects including
constraints and indexes separately
2. create the target database with the script above except for the constraints and indexes
3. use your dts or ssis package to import the data or whatever your method to import data
4. create the constraints and indexes

you can also search for a third party tool for data and schema synchronization

--------------------
keeping it simple...

Zim327
Yak Posting Veteran

62 Posts

Posted - 2011-09-20 : 17:17:34

Thank you both!
I'll let my dba know...

Best regards,
Zim
(Eternal Yak God Emperor from the Future)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources