How do I copy SQL Azure database to my local development server?

Does anyone know how I can copy a SQL Azure database to my development machine? I’d like to stop paying to have a development database in the cloud, but it’s the best way to get production data. I copy my production database to a new development database but I’d like to have that same database … Read more

Reset Entity-Framework Migrations

I’ve mucked up my migrations, I used IgnoreChanges on the initial migration, but now I want to delete all my migrations and start with an initial migration with all of the logic. When I delete the migrations in the folder and try and Add-Migration it doesn’t generate a full file (it’s empty – because I … Read more

Rollback one specific migration in Laravel

I want to rollback only : Rolled back: 2015_05_15_195423_alter_table_web_directories I run php artisan migrate:rollback, 3 of my migration are rolling back. Rolled back: 2015_05_15_195423_alter_table_web_directories Rolled back: 2015_05_13_135240_create_web_directories_table Rolled back: 2015_05_13_134411_create_contacts_table I delete both of my web_directories and my contacts table unintentionally. I never want that to happen, and if I can rollback only that specific … Read more

EF Migrations: Rollback last applied migration?

This looks like a really common task, but I can’t find an easy way to do it. I want to undo the last applied migration. I would have expected a simple command, like PM> Update-Database -TargetMigration:”-1″ Instead, all I can come up with is: PM> Get-Migrations Retrieving migrations that have been applied to the target … Read more