Link to home
Start Free TrialLog in
Avatar of Westside2004
Westside2004Flag for United States of America

asked on

Copy Data Nightly?

Hi,

I am using SQL 2005

I have a database that contains just one table and I would like to copy the data to 3 other tables that are in different databases.   If a column gets added to the source database table AND the data has changed for example in that column, I want to ensure when the copy process starts, it either drops the table on the destination databases and then re-creates the table and pushes the data across.   How can I do this in a way that will keep my constraints and everything intact.

Say the source database has a table called "Employees".  The columns are:

employee_id
first_name
last_name

I would like to copy the schema and the data and push it to 3 other destination/target db each night at midnight.

Any help appreciated

Thanks,

-ws
Avatar of jorge_toriz
jorge_toriz
Flag of Mexico image

If you use the import/export wizard to generate a SSIS package, and then run this package with the sql server agent?
Avatar of Westside2004

ASKER

Hi,

How can I automate this though?

-ws
ASKER CERTIFIED SOLUTION
Avatar of jorge_toriz
jorge_toriz
Flag of Mexico image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks!