#399 SQL Replace: Switch param/values data based on the Alias

open
nobody
None
5
2012-12-29
2010-08-15
Anonymous
No

Hello

In the SQL Replace plugin, it would be great to be able to link a set of param/values so the Alias I'm connected to at the time.

For instance, my development team works in both Production and Development environments, and to run the same SQL in both environments means we have to update the database names. In production a database named 'Clients' may be named 'DevAClients' in the DevA environment, or 'DevBClient' in the DevB environment.

I can setup a set of data so that when connected to the Production Alias, my SQLReplace data may look like this:
<<Clients Database>>,Clients
<<Accounts Database>>,Accounts
<<My Team Database>>,EADBUILD

I can then setup a set of data for each Development environment/alias that we use. So my SQLReplace data for this may look like so:
<<Clients Database>>,DevAClients
<<Accounts Database>>,DevAAccounts
<<My Team Database>>,UserDb

If I have the ability within SQL Replace to set that all up once and "link" it to an Alias, the number of times I need to go edit the SQLReplace settings will be significantly reduced.

Kind regards
Tim

Discussion

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks