Average Time To Finish SQL Replication Job

• Hoan Le

  SSC Rookie

  Points: 46

  More actions

  January 22, 2010 at 4:09 pm

  #214876

  Hello there,

  I have a database with about 200 tables and 50.000 records.

  Since I can't use SQL Replication tool for my particular purposes, I had to develop a custom tool (on MS .NET 2.0 Framework) to do the job.

  My custom tool takes about 30mins to finish synchonizing the database. I think this number is considerable long.

  So, anyone used to do such things on similar database using SQL Server Replication please tell me the time should be taken for SQL Replication tool.

  Thanks a ton.

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  February 5, 2010 at 7:49 am

  #1114443

  Hi,

  That does seem very long indeed.

  Can you provide a bit more info on your problem.

  The databases being synch...where are they in relation to each other. Are these 200 tables big ?..50000 rows seems minimal.

  Ta

  Graeme