The best way should be using new MigrateDatabaseToLatestVersion initializer. Database.SetInitializer<YourContext>( new MigrateDatabaseToLatestVersion<YourContext, YourMigrationsConfig>()); Database.Initialize(false);
Check your DB_HOST on your .env file DB_HOST=http://localhost/ –> DB_HOST=localhost Result: I can migrate peacefully now. php artisan migrate Migration table created successfully. Migrated: 2014_10_12_000000_create_users_table
Don’t. If you’re looking for seed data, you should use db/seeds.rb and rake db:seed instead. More info in this Railscast. Side note: Always make sure that the code in db/seeds.rb is idempotent. i.e. It should always be safe to re-run your seeds. But, if you must insert or modify data inside a migration (there are … Read more
You need to add a blank “merge” migration that will reset the snapshot of the latest migration in the .resx file. Do this using the IgnoreChanges switch: Add-Migration <migration name> -IgnoreChanges See here for an explanation
I believe I had the same issue as you did. I didn’t save the whole error message, but my error message was ‘Could not load file or assembly ‘Microsoft.Build.Framework, Version=15.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ or one of its dependencies. The system cannot find the file specified.‘ I am using Visual Studio 2017 and was trying to do … Read more
If you are using the Rails 4.x you can now generate migrations with references, like this: rails generate migration AddUserRefToProducts user:references like you can see on rails guides
There’s another similar question, but I’ll repeat my reply here too, to make sure as many people see this info: First up, a disclaimer: although I work for Embarcadero. I can’t speak for my employer. What I’m about to write is based on my own opinion of how a hypothetical 64-bit Delphi should work, but … Read more
Roll back all the migrations (or start with a fresh database); Change the dates that form the first part of the migration filenames so they’re in the order you want (eg. for 2014_06_24_134109_update_database.php, the date & time is 2014-06-24, 13:41:09); Run the migrations again. With respect to your comment about foreign keys… I’m not sure … Read more
There’s a much easier answer. Add this to your migration: def connection ActiveRecord::Base.establish_connection(“quiz_#{Rails.env}”).connection end That’s for Rails 3.1. For Rails 2.X or 3.0 it’s a class function instead (eg def self.connection)
I stumbled upon this and although I didn’t care about my data much, I still didn’t want to delete the whole DB. So I opened the migration file and changed the AlterField() command to a RemoveField() and an AddField() command that worked well. I lost my data on the specific field, but nothing else. I.e. … Read more