What are the challenges you face when working across database platforms? Take the survey
Options

Combine Seed Data + Migration Scripts

DanrDanr Posts: 5 New member
edited November 18, 2020 8:45AM in SQL Change Automation
Hi,
I have a table with > 100.000 rows. Is it possible to use seed data to get the initial state and then continue using the table with migration scripts? I tried to achieve this, but when I add the table to static data tables it will then generate a full migration script and doesn't now anything about the seed data file.

Some background information:
Our team wants to use local DB for developing process. While developing we are changing static data in local DB. I would like to use Change Automation to generate migration scripts for those changes locally and then push to repo. Some of our static tables are very large > 50.000 rows and one table with > 100.000 rows. In developing process the changes will affect only 500-1000 rows of these large tables. the other rows remain the same
Tagged:

Answers

  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    Hi,
    The static data population by default will pull in all the rows of data on the table you wish to link static data upon.  Which with the row counts of 50,000 and 100,000 will be a performance hit.  The static feature was originally added to provide lookup data that rarely changes for example zip or postal codes or country lists. 

    I recommend that you take a look at the Offline method offered in this help document, where you prepare a script that describes the data changes before deploying the changes to the database.  Removing the requirement to add the table to static data.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.