Support custom schema and table name for version tracking

[rdagumampan]

Support custom schema and table name for version tracking. This is specially helpful for databases maintaining multiple schemas and requires some compliance to naming patterns and segmentation of tables. For example, instead of keeping the tracking table into [dbo].[__YuniqlDbVersions] it should be possible to keep this in [utils].[SchemaHistory]

[rdagumampan]

Done. Feature is set to be part of release v1.0.

Usage

Prepare test database

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=P@ssw0rd!" -p 1400:1433 -d mcr.microsoft.com/mssql/server:2017-latest

Prepare samples sql server database

git clone https://github.com/rdagumampan/yuniql.git c:\temp\yuniql-cli
cd c:\temp\yuniql-cli\samples\basic-sqlserver-sample

Run with custom schema

SETX YUNIQL_CONNECTION_STRING "Server=localhost,1400;Database=yuniqldb1;User Id=SA;Password=P@ssw0rd!"
yuniql run -a  --schema "my_schema"

yuniql info --schema "my_schema"

Run with custom version history table

SETX YUNIQL_CONNECTION_STRING "Server=localhost,1400;Database=yuniqldb2;User Id=SA;Password=P@ssw0rd!"
yuniql run -a --table "my_version_history"

yuniql info --table "my_version_history"

Run with custom schema and version history table

SETX YUNIQL_CONNECTION_STRING "Server=localhost,1400;Database=yuniqldb3;User Id=SA;Password=P@ssw0rd!"
yuniql run -a --schema "my_schema" --table "my_version_history"

yuniql info --schema "my_schema"  --table "my_version_history"

HTH