Feature Suggestion

• 
  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.

  Alice E March 18, 2009 11:22

  - 0 +
• 
  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

  MEGADETH20650 March 18, 2009 11:27

  - 0 +
• 
  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 March 23, 2009 13:04

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

  MEGADETH20650 March 23, 2009 13:13

  - 0 +
• 

  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 March 23, 2009 13:17

  - 0 +
• 
  On this particular project, the database contains 33 tables, and 12 of them have "seed" data. These are merely static lookup tables.
  
  Mike

  MEGADETH20650 March 23, 2009 13:21

  - 0 +

Add comment

Please sign in to leave a comment.