Replicating Data

[jeepxo]

Very new to SQL 2005.

I have a 2 databases on the same server. I want to copy 2 tables from one database to the other every night.

In 2000 I would have gone to Data Transformation Services, created a local package with the 2 tables I wanted and scheduled it to run every night around midnight.

I don't see how to do that in SQL 2005.
Any suggestions?



To build may have to be the slow laborious task of years. To destroy can simply be the thoughtless act of a single day.

 

[mrdenny]

You want to use SSIS to do this. An SSIS package can be build using the "SQL Server Business Intelligence Development Studio".

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)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com