Feature Suggestion

One of the most important features of SQL Compare is the ability to synchronize a database with a set of scripts (which we keep in source control).

It would be very helpful if SQL Data Compare had an analagous feature for managing data for lookup tables. We currently keep these data scripts in source control, but it's a manual process to synchronize the data in the scripts and the data in the database.

Thank You.
Mike Wengler

Comments

  • Hi Mike,

    Thanks for your post.

    We are hoping to implement this feature in the next version of SQL Data Compare so that users can synchronize a database with a set of scripts.

    Can I ask you a few questions to help us research this further?

    1. What do your data scripts look like? Do they contain DML statements or are they CSV or XML files, or something else entirely?

    2. Would it be useful if SQL Data Compare could create a set of scripts from an existing database or is it just the synchronization process that you're after?

    Alice.
  • Thanks for your prompt reply.

    Our data scripts only contain Insert statements. There is 1 data script for each table that requires "seed" data.

    Yes, it would be wonderful if SQL Data Compare could create a set of data scripts from an existing database, similar to what SQL Compare does.

    Thanks again,

    Mike
    Mike Wengler
  • Hi,

    Out of interest, how many rows does your largest static/lookup table have? And how many columns does it have?

    Thanks!

    David Atkinson
    Product Manager
    Red Gate Software
    David Atkinson
    Product Manager
    Redgate Software
  • On average, these table have 50 rows or less. The maximum number of columns in any table is 12.

    Mike
    Mike Wengler
  • On average, these table have 50 rows or less. The maximum number of columns in any table is 12.

    Mike

    Thanks. We'll notify you when the next version of SQL Data Compare is out.

    Can I ask how many of these tables do you have per database, on average?

    David
    David Atkinson
    Product Manager
    Redgate Software
  • On this particular project, the database contains 33 tables, and 12 of them have "seed" data. These are merely static lookup tables.

    Mike
    Mike Wengler
Sign In or Register to comment.