SQL Server Performance

Best way to sync a single/multiple table from two databases

Discussion in 'ALL SQL SERVER QUESTIONS' started by Bhawesh, Jan 10, 2013.

  1. Bhawesh New Member

    I 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 ?
  2. FrankKalis Moderator

    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.
  3. Bhawesh New Member

    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 ?
  4. FrankKalis Moderator

    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.

Share This Page