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 |
|
worthrd
Starting Member
2 Posts |
 Posted - 2010-09-02 : 02:39:40
|
| Hi folks,I have a question about importing functionality. I have two db with same schema, one of them is production db other one is empty. I want to export data to empty db from production db.. But there are a lot of relational tables. If i want to export for example Customer with addresses and orders by a condition what should i do ? And this action must be reusable for future, i want to export more data. Any suggestion ? Thanks. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-09-02 : 03:38:01
|
Is it possible for you just to take a backup from production and restore it to the other db?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
worthrd
Starting Member
2 Posts |
Posted - 2010-09-05 : 07:50:49
|
quote:
Originally posted by webfred
Is it possible for you just to take a backup from production and restore it to the other db?
No, you're never too old to Yak'n'Roll if you're too young to die.
Not whole db. Just some tables data with theirs relationals' data. Integraty must be done |
|
|
|
|
|
|
Import relational data one db to another