Search code examples
sqlvisual-studioslowcheetah

How to get SlowCheetah to transform SQL files

The Microsoft Slowcheetah website states

This package allows you to automatically transform your app.config (or any file) when you press F5 in Visual Studio.

I have a SQL Server VS solution which requires configuration dependent users and logins. Slowcheetah would be a good solution if I can figure out what the transform file should look like.

For example I would like the statement

CREATE LOGIN [DEVDOMAIN\ReadonlyUser] FROM WINDOWS DEFAULT_DATABASE = MyDb_Dev;

Transformed to

CREATE LOGIN [TESTDOMAIN\ReadonlyUser] FROM WINDOWS DEFAULT_DATABASE = MyDb_Uat;

Is this achievable?

Solution

  • SlowCheetah currently only supports using XML Document Transforms on XML files or JSON Document Transforms on JSON files.

    If you can get your user data into one of those format you'll be set, otherwise...