October 6, 2008 at 2:16 pm
I'm pretty sure that will mess up your relationships since they use the table ID, not the name.
The stored procedures use the name so they should be ok.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 6, 2008 at 2:30 pm
You would need to rebuild the relationships. They would remain pointing to the first table regardless of the name of the table.
I'd generate the drop and create scripts before doing the new import. Drop the constraints on the original table, rename both tables and then run the create scripts against the new table to re-establish the relationships.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 7, 2008 at 11:17 am
You could also look into importing the fresh data into a new table and updating table1 based on table2.
If that's not possible, then follow Jack's advice.
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply