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 databases

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 ?
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.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |