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 |
|
ssunny
Posting Yak Master
133 Posts |
 Posted - 2008-05-23 : 10:03:25
|
| Hi All,Apart from DTS import/export what are the other ways to bring back production data to dev environment?I know there are some tools in the market. I've used sqldelta. Didn't like much.Any ideas???Thanks,Sunny. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-23 : 10:13:28
|
Backup/restore?BCP?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
ssunny
Posting Yak Master
133 Posts |
Posted - 2008-05-23 : 10:30:01
|
| Thanks for the reply.I have around 1000 tables in the database and I want to bring back data of some 200 tables.Can you please shed some light on how should I use bcp??I am not good at bcp syntax.sunny. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-23 : 11:31:43
|
| Just backup Database and copy bak files to Dev server and restore it. Delete whichever tables you don't need. |
|
|
|
ssunny
Posting Yak Master
133 Posts |
Posted - 2008-05-23 : 11:43:38
|
| One qustion though.If I take a full backup of prod and restore it on dev, I'll loose some lookup tables which exists only in dev, which I don't want.Please advise. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-23 : 13:06:51
|
| Then restore with different name like DBNAME_DEV |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-05-23 : 13:09:51
|
| If you want them all in one DB, you're going to need to go back to DTS (easiest) or write a custom script to insert..select for the ones you want refreshed.Terry |
|
|
|
ssunny
Posting Yak Master
133 Posts |
Posted - 2008-05-23 : 14:32:26
|
| Thank you guys for your replies. |
|
|
|
|
|
|
data refresh from production