Westside2004
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
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
If you use the import/export wizard to generate a SSIS package, and then run this package with the sql server agent?
ASKER
Hi,
How can I automate this though?
-ws
How can I automate this though?
-ws
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!