Data Transfer to a Test Instance of SQL Server

[darude]

Hello All,
I have a set of production tables linked to user applications using SQL Server 2005. I set up an instance of the server called Test and would like to transfer data from the production server to the test server on daily. I think I would use Job to do this, but not sure how to create a job for this task.

Thank you in advance. Any help would be much appreciated.

 

[mrdenny]

The best bet is to backup the database and then restore it to the test instance. If you don't want to move the entire database then use DTS or SSIS to move just the data that you want.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[darude]

Thank you!!

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog