#67 new

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.

New-ticket 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/

People watching this ticket