{"action":"created","issue":{"url":"https://api.github.com/repos/lecaillon/Evolve/issues/76","repository_url":"https://api.github.com/repos/lecaillon/Evolve","labels_url":"https://api.github.com/repos/lecaillon/Evolve/issues/76/labels{/name}","comments_url":"https://api.github.com/repos/lecaillon/Evolve/issues/76/comments","events_url":"https://api.github.com/repos/lecaillon/Evolve/issues/76/events","html_url":"https://github.com/lecaillon/Evolve/issues/76","id":355623856,"node_id":"MDU6SXNzdWUzNTU2MjM4NTY=","number":76,"title":"Unable to update database","user":{"login":"ld0614","id":20439950,"node_id":"MDQ6VXNlcjIwNDM5OTUw","avatar_url":"https://avatars3.githubusercontent.com/u/20439950?v=4","gravatar_id":"","url":"https://api.github.com/users/ld0614","html_url":"https://github.com/ld0614","followers_url":"https://api.github.com/users/ld0614/followers","following_url":"https://api.github.com/users/ld0614/following{/other_user}","gists_url":"https://api.github.com/users/ld0614/gists{/gist_id}","starred_url":"https://api.github.com/users/ld0614/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ld0614/subscriptions","organizations_url":"https://api.github.com/users/ld0614/orgs","repos_url":"https://api.github.com/users/ld0614/repos","events_url":"https://api.github.com/users/ld0614/events{/privacy}","received_events_url":"https://api.github.com/users/ld0614/received_events","type":"User","site_admin":false},"labels":[{"id":492635919,"node_id":"MDU6TGFiZWw0OTI2MzU5MTk=","url":"https://api.github.com/repos/lecaillon/Evolve/labels/question","name":"question","color":"cc317c","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-08-30T14:56:04Z","updated_at":"2018-08-30T15:13:44Z","closed_at":null,"author_association":"NONE","body":"Configuration:\r\nC# .Net 4.6.2\r\nAzure SQL Server V12\r\nAzure App Service\r\n\r\nMigration Launcher:\r\n            try\r\n            {\r\n                string connectionString = Settings.GetSettings().DatabaseConnectionString;\r\n                SqlConnection cnx = new SqlConnection(connectionString);\r\n                Evolve.Evolve evolve = new Evolve.Evolve(cnx, msg => Trace.TraceInformation(msg))\r\n                {\r\n                    Driver = \"SqlClient\", //Connect to SQL Server\r\n                    Locations = new List<string> { \"db/migrations\" },\r\n                    IsEraseDisabled = true, //Do not allow Erasing of schema\r\n                    EnableClusterMode = true //Ensure that no other instances also attempt to migrate the database as the same time\r\n                };\r\n\r\n                evolve.Migrate();\r\n            }\r\n            catch (Exception ex)\r\n            {\r\n                Trace.TraceError(\"Database migration failed.\", ex);\r\n                throw;\r\n            }\r\n        }\r\n\r\nSQL files have been written and are uploaded to the web server:\r\n\r\n![image](https://user-images.githubusercontent.com/20439950/44859804-b81aa700-ac6c-11e8-997e-7dcc9ebf342e.png)\r\n\r\nDuring start the following logs are provided\r\n```\r\nApplication: 2018-08-30T14:46:57  PID[5928] Information Executing Migrate...\r\nApplication: 2018-08-30T14:46:57  PID[5928] Information Evolve initialized.\r\nApplication: 2018-08-30T14:46:57  PID[5928] Information No metadata found.\r\nApplication: 2018-08-30T14:46:57  PID[5928] Information Database is up to date. No migration needed.\r\n```\r\n\r\nAnd a single blank changelog table has been created:\r\n![image](https://user-images.githubusercontent.com/20439950/44859922-03cd5080-ac6d-11e8-9b50-8d55721a91d3.png)\r\n\r\nAs far as I can tell I've followed all the requirements for using Evolve but I'm unsure of how to troubleshoot this issue further, any assistance would be greatly appreciated. "},"comment":{"url":"https://api.github.com/repos/lecaillon/Evolve/issues/comments/417356045","html_url":"https://github.com/lecaillon/Evolve/issues/76#issuecomment-417356045","issue_url":"https://api.github.com/repos/lecaillon/Evolve/issues/76","id":417356045,"node_id":"MDEyOklzc3VlQ29tbWVudDQxNzM1NjA0NQ==","user":{"login":"lecaillon","id":19413950,"node_id":"MDQ6VXNlcjE5NDEzOTUw","avatar_url":"https://avatars0.githubusercontent.com/u/19413950?v=4","gravatar_id":"","url":"https://api.github.com/users/lecaillon","html_url":"https://github.com/lecaillon","followers_url":"https://api.github.com/users/lecaillon/followers","following_url":"https://api.github.com/users/lecaillon/following{/other_user}","gists_url":"https://api.github.com/users/lecaillon/gists{/gist_id}","starred_url":"https://api.github.com/users/lecaillon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lecaillon/subscriptions","organizations_url":"https://api.github.com/users/lecaillon/orgs","repos_url":"https://api.github.com/users/lecaillon/repos","events_url":"https://api.github.com/users/lecaillon/events{/privacy}","received_events_url":"https://api.github.com/users/lecaillon/received_events","type":"User","site_admin":false},"created_at":"2018-08-30T15:13:44Z","updated_at":"2018-08-30T15:13:44Z","author_association":"OWNER","body":"Hi @ld0614 \r\n\r\nSince the `changelog` table has been created, it means that Evolve is able to connect to your database.\r\nYour migration scripts seem to be well named.\r\nSo I think it does not find any of your sql migration files.\r\nHave you set the property `Copy to output directory` to `Copy always` on each of your sql file ?"}}
{"actor":{"display_login":"lecaillon"}}