How can we help you today? How can we help you today?

SQLCMD macros :setvar and $()

I use SQLCMD macros. A simple example would be:
:setvar server foo
:setvar database bar

:connect $(server)
USE $(database)

SQL Prompt chokes on these. Do you have any plans to support SQLCMD macros in SQL Prompt 4?
anildas
0

Comments

3 comments

Sort by
  • tanya
    Hi Anil,

    I am sorry but unfortunately we will not be able to include the support for SQLCMD variables for SQL Prompt v4. However, this has been logged as an enhancement request and we will probably include the support for SQLCMD in our future versions.
    I hope that helps and my apologies for any disappointment caused.

    Regards,
    Tanya
    Project Manager
    Red Gate Software Ltd
    tanya
    0
  • anildas
    Unfortunately, this makes SQL Prompt totally unusable for me.

    You wirte that "we will probably include the support for SQLCMD in our future versions". Where is it on your roadmap? Within 2009? Later?
    anildas
    0
  • tanya
    Hi Anil,

    I understand your concern. It is in the review bucket and we will review it after v4.0 release wherein it will be decided whether the functionality will be implemented for 2009 or later. I will update the post once we arrive at a decision.
    I am sorry if I am not being too helpful but it is hard to give any precise timelines at this stage.

    Thanks,
    Tanya
    Project Manager
    Red Gate Software Ltd
    tanya
    0

Add comment

Please sign in to leave a comment.