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:
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