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 |
sqlserverdba
Yak Posting Veteran
53 Posts |
Posted - 2010-01-05 : 09:44:39
|
Hi,I want to refresh 5 tables with data from production to development.Which method is good for such kind of refresh?Thanks |
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-01-05 : 09:59:02
|
if the schema hasn't changed then you can bcp the information out and back in to the development databaseWouldn't it be easier to backup and restore then run whatever upgrade scripts you'd have to get the database schema into your development code level?Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-05 : 11:38:39
|
for one time refresh use the data import wizard.if it needs to be done repeatedly, write an SSIS package -- or use the wizard and save the package it creates. then schedule it as a sql agent job |
 |
|
shan
Yak Posting Veteran
84 Posts |
Posted - 2010-01-05 : 12:06:45
|
or Create a linkedserver in production to development server and run the script similar to this in productioninsert to table1select * from linkedserver.dbname.dbo.table1assuming that your schema dame is dbo.-Shan |
 |
|
|
|
|