Red Gate forums :: View topic - SQLCMD variables
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product support center
SQL Refactor 1
SQL Refactor 1 forum

SQLCMD variables

 Search in SQL Refactor 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
drsql



Joined: 16 Aug 2006
Posts: 39
PostPosted: Tue Jan 16, 2007 11:57 pm    Post subject: SQLCMD variables Reply with quote
A nice enhancement would be to support the SQLCMD variables that allow you to build scripts like:

Code:
:setvar database dbName

select *
from   $(databaseName).dbo.tablename


I build many of my scripts like this in order to support (too many) different databases.

Thanks
Back to top
View user's profile Send private message Send e-mail
Daniel Handley



Joined: 07 Feb 2005
Posts: 199
Location: Red Gate Software
PostPosted: Mon Jan 22, 2007 6:17 pm    Post subject: Reply with quote
Hi

I have added this to the wish list for inclusion in the discussions when we begin to work on the next version.
Thanks for the feedback.
Regards
Dan
_________________
Daniel Handley
Red Gate Software Ltd
Back to top
View user's profile Send private message Send e-mail
anildas



Joined: 25 Feb 2008
Posts: 7
Location: San Diego, California, USA
PostPosted: Mon Feb 25, 2008 10:27 pm    Post subject: Wanted: SQLCMD support in SQL Refactor Reply with quote
The last update to this issue was posted on January 22, 2007. Any news?
Back to top
View user's profile Send private message Send e-mail
tanya



Joined: 30 Apr 2007
Posts: 253
PostPosted: Tue Feb 26, 2008 1:24 pm    Post subject: Reply with quote
Hello,

This feature has not been targeted to any specific release as yet because we have not got enough requests for the feature.
However, if more user requests flow in you will see it fixed in the near future.

Thanks,
Tanya
Back to top
View user's profile Send private message
weswinkler



Joined: 11 Nov 2008
Posts: 32
PostPosted: Tue Sep 29, 2009 1:19 am    Post subject: Support for SQLCMD mode needed. Reply with quote
Consider this an urgent request for this feature!

I have begun working on projects generated with the Microsoft Visual Studio Team Edition Database Developer Version (aka DataDude). Many of the scripts must be run in SQLCMD mode in order to utilize project variables, stored in *.sqlcmdvars files.

When such a query is loaded into the SQL Management Studio and the query session is set to SQLCMD mode, it parses correctly and executes correctly. However, SQL Refactor cannot perform ANY functions, claiming there are errors. The script summarization feature, which I find particularly useful, is completely unavailable in SQLCMD mode.

See my post in the related forum for SQL Prompt. http://www.red-gate.com/MessageBoard/viewtopic.php?t=9671
Back to top
View user's profile Send private message
fatherjack



Joined: 13 Mar 2007
Posts: 224
Location: Cornwall
PostPosted: Wed Oct 07, 2009 9:31 am    Post subject: Reply with quote
I would also support this feature being included ASAP
_________________
-----------------------------------------
Senior DBA
Careers South West Ltd
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group