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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Refresh 5 tables from production to development

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 database

Wouldn'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 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Go to Top of Page

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
Go to Top of Page

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 production

insert to table1
select * from linkedserver.dbname.dbo.table1

assuming that your schema dame is dbo.

-Shan
Go to Top of Page
   

- Advertisement -