hi I am trying to migrate one of our ms-sql DB's using simple db
migrate. Our Ms-sql is in azure and when we try to give db-mgrate
command it throws below error. I could connect to ms-sql db using
visualiser and other clients with same configs.
D:\WorkSpace>db-migrate --db-engine=mssql --db-user=test@XXXXXXX.XXXXXX.XXXXX
--db-password=XXXXXX --db-port=1433 --db-host=XXXXXXX.XXXXXX.XXXXX
--db-migrations-dir=mssql/ --db-name=test
[ERROR] error executing migration: (262, "CREATE TABLE permission
denied in database 'master'.DB-Lib error message 20018, severity
14:\nGeneral SQL Server error: Check messages from the SQL
Server\n")
[ERROR DETAILS] SQL command was: if not exists ( select 1 from
sysobjects where name = 'db_version' and type = 'u' ) create table
db_version ( id INT IDENTITY(1,1) NOT NULL PRIMARY KEY, version
varchar(20) NOT NULL default '0', label varchar(255), name
varchar(255), sql_up NTEXT, sql_down NTEXT)
