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.
| Author |
Topic |
|
Shrews14
Starting Member
37 Posts |
 Posted - 2007-03-21 : 06:27:57
|
| I'm trying to take data and push it into a new database.This data was taken from a database where there were many contraints, FK etc. quite a complicated structure and now sent to us with just the data in the tables with none of these constraints, FK!!This data now needs pushing into the original database structure, so all the data will live within the constraints, but using an insert SPROC throws some FK errors, what is the best way to push this data into it's structure!somebody suggested DTS but this doesn't take into account the constraints, also we need to run this at anytime for a number different datasets. Can anybody help ?(if you can decipher my explantion)Many thanks for reading, please indicate if you need more info.Shrew |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2007-03-21 : 09:06:19
|
| Well...I am opposed to these light variations...for example, Hienken light, I mean, give me a breakIn any case, you need to set up stging tables, then run audits against them to see what fails RI, then report this back to the bozos who sent the data and tell them it will fail on load unless the fix itBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
 |
|
|
|
|
|
|
|
Coping data into a new DB with heavy constrants