Best way to sync a single/multiple table from two databases | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Best way to sync a single/multiple table from two databasesI have a MIS table. there are 144 columns and space used by this single table is 1.4 GB. To avoid cross databases joins , I need to sync the same table in a different databases. I am using SQL server 2005. Please suggest what will be the best way for this sync task ?
What exactly do you mean by "sync the same table"?
You have to have that table and the data in two different database? If so, what are the requirements towards currency of the data in both copies? Real-time, almost real-time, or can there be a gap? Depending on the answer you may want to look into replication, mirroring, log-shipping, or nightly ETL jobs to keep the tables in sync.
Thanks Frank for feedback. I have that table and the data in two different database. It will be sufficient for me if I sync that once in a day/night. Now , what should i look for ?
Looking at the size of the table, it can’t be that many rows at all. I’m inclined to suggest go for an ETL job with SSIS.