How to Create Scripts

• 
  Yes, SQL Compare 6 can save an existing database to individual scripts that are saved to a specified folder.
  
  I would encourage you to download the beta and try it out for yourself.
  
  Currently all files are saved to a single folder. We are looking for user feedback on where these object files should be saved by default. What folder hierarchy do users want?
  
  Also, what file-naming convention would be best? Currently it is [owner].[objectname].sql
  
  Thanks,
  
  David Atkinson
  Red Gate Software

  David Atkinson May 16, 2007 07:57

  - 0 +
• 
  I think there should be user customization with regard to locations and extensions for the different object types. If possible, you should allow users to select different locations and extensions per object type.

  Dre The DBA May 17, 2007 11:23

  - 0 +
• 
  Can I ask why it is important to have different extensions for each object type? I would have thought that having .sql is the best as it is associated with your SQL editor by default.
  
  David Atkinson
  Red Gate Software

  David Atkinson May 17, 2007 11:33

  - 0 +
• 

  David Atkinson wrote:

  Can I ask why it is important to have different extensions for each object type? I would have thought that having .sql is the best as it is associated with your SQL editor by default.
  
  David Atkinson
  Red Gate Software

  
  We used to do that, letting the extension define the object type so that a .prc is a procedure, .tbl is a table, etc. Just an attempt to let the file help you with documentation. I like how MS did it in DBPro much better. Everything is .sql, but it's .fkey.sql or whatever. That way you get the documentation within the name, but you get the nice clean extension for use with all the SQL tools.

  Grant Fritchey May 21, 2007 07:40

  - 0 +
• 
  I would suggest offering at least 2 different hierarchies, if not a customizable one. The traditional VS database project style and the newer VS DBPro style (which is far more complex). The traditional database project style would be ideal in my world, as most of the tools I use are already configured to work with it.
  
  On the flip side, SQL Compare would need to be able to cycle through all the sub-directories for comparison purposes, which it does not do at the moment.

  DavidBuckingham May 24, 2007 12:03

  - 0 +
• 
  The release version of Compare 6 will definitely support reading a directory structure recursively for script files, rather than just reading a flat single directory as the Beta version does.

  Michelle T May 25, 2007 05:56

  - 0 +

Add comment

Please sign in to leave a comment.