Skip to main content

Migration speed

Comments

4 comments

  • Brian Anderson

    I have a table with 1,416,719 records. Going from MSSQL to MySQL. Seems to be taking a full day... perhaps 8+ hours to convert just one such table. Not sure how to make it speed up. Perhaps it is because the servers are both remote? Perhaps it would be faster if the DBConvert was installed on the same server as the MSSQL DB?

    0
  • Ellen Vasil

    Hi Brian,

    We held our tests on the local servers. As we wrote before, conversion speed of remote databases mainly depends on the servers’ occupancy and bandwidth.
    Also, for the testing we used not complex databases' structures, the structures without Images and Binary data.

    To increase conversion/synchronization speed and for the proper process you must have NOT a composite unique or primary index.

    Did you try to use 'Quantization' option?
    Quantization for MS SQL serves to avoid memory issues. The more complicated and larger query generated the more time required to process that query by the server.
    Please find more info about this option here:
    https://support.dbconvert.com/hc/en-us/articles/201185582-How-to-configure-DBConvert-DBSync-software-for-processing-large-tables-efficiently-
    https://support.dbconvert.com/hc/en-us/articles/201207032-Bulk-Insert-and-Quantization-options-

    0
  • Brian Anderson

    In the documentation I read that you must have a primary key or it will not convert or sync properly. You seem to be suggestion there should be no primary key? I did check bulk insert as well as quantization, and it seems to be moving faster. I am not sure that I understand what the quantization slider controls. I have it currently set to 100.

    Thank you for your help.

    0
  • Ellen Vasil

    Hi Brian,
    Primary key or Unique index must be, but it should be not a composite.

    If 'Quantization' is checked the synchronization speed will be increased for large databases. This is achieved by splitting the whole record set into portions.

    We advise you to set the slider value to 100 or lower than 100 until the error disappears.

    0

Please sign in to leave a comment.