sql server - Copy Database Data from Many DBs to One. Data Replication (sort of) -

This includes data replication, type:

There are many sites with SQL Express on each site 'Audit' database, which is 1 table in general form (to simplify life :)

Now I need to get this table from every site, and copy the content (say, Date time value> 1/1/200 00:00, but it will obviously change) and SQL all For example,

Many SQL Express DB with ID , definition name, definition type, date time, breakthrough, Navarakkhar 1, Navarakar 2 etc. etc.

and

the name of the site, the ID , the name of the definition, the definition type, the date time, the success, the new one, the redemption, etc. etc.

Where the items are the primary key in the bold

Is there a Microsoft (or non-MS I think) app / tools / manager already copying all the data, or do you have us Write yourself?

Many thanks.

You can use SSIS (which comes with SQL Server) to populate, It can be set with variables to change the connection string in different databases. I have a list that saves through the entire list and uses three differnt files to do the same procedure from three differnt vendors. You can do something similar to the loop through different site databases. Enter the full list of the database that you want to copy the audit data from the table and loop by changing the connection string each time.

However, on earth why do you want a mega audit table on each site? If every table in the database changes the audit table, after the change, the audit test eventually becomes a big problem for the performance. Each insert, update and delete is to hit this table and then you are proposing to add an export on it. It seems that I have a guaranteed framework for locking and deadlock and all kinds of dirtyness, do a favor in my own right and limit each audit table in the auditing table.