Feature Suggestion

MEGADETH20650MEGADETH20650 Posts: 8
edited March 23, 2009 1:21PM in SQL Data Compare Previous Versions
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
· Share on Twitter

Comments

  • Alice EAlice E Posts: 108
    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.
    · Share on Twitter
  • MEGADETH20650MEGADETH20650 Posts: 8
    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
    · Share on Twitter
  • David AtkinsonDavid Atkinson Posts: 1,458 Rose Gold 2
    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
    · Share on Twitter
  • MEGADETH20650MEGADETH20650 Posts: 8
    On average, these table have 50 rows or less. The maximum number of columns in any table is 12.

    Mike
    Mike Wengler
    · Share on Twitter
  • David AtkinsonDavid Atkinson Posts: 1,458 Rose Gold 2
    MEGADETH20650 wrote:
    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
    · Share on Twitter
  • MEGADETH20650MEGADETH20650 Posts: 8
    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
    · Share on Twitter
Sign In or Register to comment.