MS SQL Azure authentication in simple db migrate
Reported by dumne | January 18th, 2019 @ 04:19 AM | in BACKLOG
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)
No comments found
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป
simple-db-migrate is a database migration tool inpired on Rails migrations. For more info check the project website: http://guilhermechapiewski.github.com/simple-db-migrate/
dumne
Guilherme Chapiewski