Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Running DbUp against a SQL Azure Database server using EnsureDatabase fails with a Timeout error when creating the database #2

Open
MarkPow opened this issue Dec 9, 2015 · 3 comments
Labels
bug Something isn't working

Comments

@MarkPow
Copy link

MarkPow commented Dec 9, 2015

The code responsible for creating the database is in SqlServerExtensions (https://github.com/DbUp/DbUp/blob/master/src/DbUp/Support/SqlServer/SqlServerExtensions.cs). If I increase the CommandTimeout then EnsureDatabase works against a SQL Azure server:

        // Create the database...
        using (var command = new SqlCommand(sqlCommandText, connection)
        {
            CommandType = CommandType.Text
        })
        {
            command.CommandTimeout = 120;
            command.ExecuteNonQuery();
        }

Unfortunately I'm new to GitHub etiquette and protocol (and having now posted, not sure why my first two sentences are in bold!) so not sure how to go about getting this into the main branch.

@MarkPow MarkPow changed the title Running DbUp against a SQL Azure Database server using EnsureDatabase, fails with a Timeout error when creating the database Running DbUp against a SQL Azure Database server using EnsureDatabase fails with a Timeout error when creating the database Dec 9, 2015
@omnibs
Copy link

omnibs commented Feb 1, 2016

We should retest this after DbUp/DbUp#157

@omnibs omnibs added the bug Something isn't working label Feb 2, 2016
@ammaraltahan
Copy link

This remains an issue, I got the exact same problem, I downloaded the code and increased the timeout and it worked. How can we make this change?

@jonathanantoine
Copy link

I would love to see this fixed :)

@droyad droyad transferred this issue from DbUp/DbUp Jan 30, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
Status: Bugs
Development

No branches or pull requests

4 participants