SMO and SQL Refactor

Refactors and formats SQL code.

Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson

SMO and SQL Refactor

Postby goodman » Mon Oct 19, 2009 10:18 am

Hello, theres
Is it possible to using SMO http://msdn.microsoft.com/en-us/library/ms162169.aspx & SQL Refactor dll to layout all my stored procedure in my database ?

Any idea ?
goodman
 
Posts: 2
Joined: Mon Oct 19, 2009 10:09 am

Postby peter.peart » Tue Oct 20, 2009 12:45 pm

Hi there,

This isn't currently possible, however we do have a request in our systems to provide command line access to SQL Refactor to enable you to layout multiple SP's etc. before being checked into a source control system. The reference number for this is SR-722.

Would this potentially suit your needs should we decide to go ahead and implement this feature?

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Re:

Postby goodman » Tue Oct 20, 2009 5:53 pm

peter.peart wrote:Hi there,

This isn't currently possible, however we do have a request in our systems to provide command line access to SQL Refactor to enable you to layout multiple SP's etc. before being checked into a source control system. The reference number for this is SR-722.

Would this potentially suit your needs should we decide to go ahead and implement this feature?

Pete


Sir,
Command line to layout sql files can help. thanks !
I just wonder if it's possible reference refactor's library to layout
sql on my own via SMO and visual studio.

thanks !

Regards,
goodman
 
Posts: 2
Joined: Mon Oct 19, 2009 10:09 am

Postby peter.peart » Thu Oct 22, 2009 12:43 pm

Hi there,

I am afraid that this isn't possible, however I have added your comments to the request for the the command line access to be put into the tools.

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids


Return to SQL Refactor 1

Who is online

Users browsing this forum: No registered users and 1 guest