Friday, December 07, 2012 2:55 PM
I have two SQL servers that I need to have identical. Sync should occur maybe a couple times per day, automatically. The one server which holds the main SQL DB is on a domain and the other Server is the reportserver and is not on the domain. However the two can talk as they are on the same network.
My question is, I have imported the tables and data from the main into the ReportServer, how can I now make the data sync from the Main DB to the Report server DB?
Just to clarify I only need the data to sync one way, from the main to the report DB.
- Edited by rustynails28 Friday, December 07, 2012 2:59 PM
Friday, December 07, 2012 4:44 PMModerator
You can use bi-directional transactional replication for this, or merge replication.
However, the tables must be published already for them to replicate. If you need to add a table, you will need to publish it. From what you describe it sounds like you do imports on the fly and this might go into ad hoc staging tables.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Sunday, December 16, 2012 4:52 PM