Insert into scripts

• 

  spirit1 wrote:

  Is there a possibilty that you could include
  insert into script generation in the SQL refactor?
  That would be really usefull.
  With option to choose between and insert into for each row
  or only one insert into with
  "select ... union" all for each rows
  
  There's an example app on CodeProject that integrates in the SSMS on
  tableName right click in object explorer:
  http://www.codeproject.com/useritems/enisey.asp
  
  It would be really cool to have all that in one place.
  
  Mladen

  
  Hi Mladen,
  this functionality is available via our SQL Data Compare or via SQL Packager. Due to time restrictions we cannot include this feature in the first version of the product, but I save this request for the time when we decide on future features for the refactor tool.
  
  Many thanks for your feedback,
  Andras

  Andras B October 11, 2006 07:59

  - 0 +
• 
  Mladen,
  
  another thing that came to my mind is SQL Prompt. The insert into a single row you will be able to dy by:
  
  type: INSERT INTO (now autocompletion for the table name) ( and now all the columns from the table can be enumerated by SQL Prompt 3.0, so you would just select that option and there you have a nearly finished insert statement, you jsut need to add the data.
  
  Addras

  Andras B October 11, 2006 08:12

  - 0 +
• 
  Hey that's not at all a bad idea.
  i'll try that.
  Thanx.
  
  I was wondering something about SQL Prompt though.
  Will 3.0 be also integrated into SSMS?
  It would be simply awsome to have a menu that says "Red gate goodies"
  and in there you'd have prompt, refactor and other options.
  It doesn't have to be a single tool and 2 or more isn't that har to integrate into the menu.
  
  I guess you could still sell prompt like it's now for QA and VS
  but i haven't been using QA for ages and VS for sql developmnet is just
  unnatural
  
  Mladen

  MladenPrajdic October 11, 2006 08:20

  - 0 +
• 

  spirit1 wrote:

  Hey that's not at all a bad idea.
  i'll try that.
  Thanx.
  
  I was wondering something about SQL Prompt though.
  Will 3.0 be also integrated into SSMS?
  It would be simply awsome to have a menu that says "Red gate goodies"
  and in there you'd have prompt, refactor and other options.
  It doesn't have to be a single tool and 2 or more isn't that har to integrate into the menu.
  
  I guess you could still sell prompt like it's now for QA and VS
  but i haven't been using QA for ages and VS for sql developmnet is just
  unnatural
  
  Mladen

  
  Hi Mladen,
  
  Prompt 3.0 will be integrated into Management Studio the same way as SQL Refactor. It will also continue to support Query Analyzer. It will have its own top level menu item
  
  Regards,
  Andras

  Andras B October 11, 2006 08:51

  - 0 +
• 
  Awsome!!
  
  So how do you create those add-on's?
  You've got an agreement with MS for SSMS add-on integration documentation?
  
  Because i was looking at classes and interfaces of SSMS dll's in spare time
  and there's no documentation on google for it. at least i haven't found it yet.
  And i have a few ideas for some add-on's i'd like to have )
  it would be interesting practice to make them myself.
  
  Mladen

  MladenPrajdic October 11, 2006 09:06

  - 0 +
• 

  spirit1 wrote:

  Awsome!!
  
  So how do you create those add-on's?
  You've got an agreement with MS for SSMS add-on integration documentation?
  
  Because i was looking at classes and interfaces of SSMS dll's in spare time
  and there's no documentation on google for it. at least i haven't found it yet.
  And i have a few ideas for some add-on's i'd like to have )
  it would be interesting practice to make them myself.
  
  Mladen

  
  No documentation, this is not officially supported. It is only us
  
  Because of the above we cannot support everything, and have many problems with installers.
  
  Regards,
  Andras

  Andras B October 11, 2006 09:41

  - 0 +
• 
  that i can believe.
  What did it take? 4 months and 5 people?
  Research into this alone is huge...
  
  No wonder you're pricing it at 295.
  
  what that expression? Hats off to you?
  
  Mladen

  MladenPrajdic October 11, 2006 09:55

  - 0 +
• 
  

  Andras B October 11, 2006 15:56

  - 0 +

Add comment

Please sign in to leave a comment.