FEATURE REQUEST: Add a USE DB_NAME statement

• 
  I've added this forum topic to the feature request for this feature.
  
  One concern that we have with implementing this feature is that some people take the synchronization script and use it on multiple databases (especially databases on various customer sites) which might have different names. This is the reason we haven't just added it already - we're trying to work out if enough customers work in this way that it's worth supporting (and we should add this feature as an option rather than just the way things are) or whether we should just add the USE statement and have them take it out manually if necessary (which might be awkward as they tend to be the people who use heavily automated deployment systems).

  Michelle T April 08, 2008 12:08

  - 0 +
• 
  I understand your logic completely
  
  I would prefer it to be an OPTION as well instead of by default
  
  Thanks for considering it

  jerryhung April 09, 2008 10:17

  - 0 +
• 
  When you use backups (which retain the target meta) rather than restoring to a local or aliased database for the comparison, then the USE statement option would certainly be appropriate.
  
  jimboh

  jimboh April 10, 2008 06:33

  - 0 +
• 
  I totally agree with the idea of adding the Use statement as an Option and not the default exactly for the reason mentioned. We have multiple servers and in many cases the database name is the same but in some cases the database name is different or there are differnet versions of the same database on one server and having a USE statement might cause problems.
  
  Thanks

  tbrovold April 10, 2008 14:05

  - 0 +
• 
  Many thanks for all your comments. We have now added an option to add a use statement at the beginning of a script generated by SQL Compare 7. This option will be off by default.
  Regards,
  Andras

  Andras B April 17, 2008 04:40

  - 0 +
• 

  Andras wrote:

  Many thanks for all your comments. We have now added an option to add a use statement at the beginning of a script generated by SQL Compare 7. This option will be off by default.
  Regards,
  Andras

  
  THANK YOU

  jerryhung April 17, 2008 09:23

  - 0 +

Add comment

Please sign in to leave a comment.