locked
Best way to Provision Large Tables RRS feed

  • Question

  • HI 

    What is the best methology for provisioning large tables (rows) - i.e. 1.4 million rows of data.

     

    I've already setup my syncgroups for the smaller tables allw orking great but once I hit the large tables i'm sure to get timeout errors so just want to know how to best handle it from the point of view of the provisioning and then syncing (i take it I can use batching with syncing though)

     

    I'm using version 2.1 at the moment.

     

     

    Thanks

     

    Thursday, September 15, 2011 9:36 AM

All replies

  • just increase the command timeout and enable batching.  if you're synching with azure, set the ApplicationTransactionSize property

    see:  http://blogs.msdn.com/b/sync/archive/2010/09/24/how-to-sync-large-sql-server-databases-to-sql-azure.aspx

    Thursday, September 15, 2011 10:16 AM
  • Yeah I figured I could do Batching when I'm actually syncing.

     

    but i was just referring to the provisioning (which bulk inserts into the sync tables )

    Can this be batched?

    or do I just increase the timeout for this operation

     

    i.e.

     Console.WriteLine("Starting Provisoning :" + DateTime.Now);
     
                    PaymentsProvision.CommandTimeout = increase the timeout here < 
                    PaymentsProvision.Apply();

    Thursday, September 15, 2011 10:45 AM
  • just increase the commandtimeout
    Thursday, September 15, 2011 11:56 AM