The currently accepted answer on this isn’t really accurate as it doesn’t add a database foreign key. It’s just adding integer columns. In Rails 4.2.x, the current approach is: http://guides.rubyonrails.org/active_record_migrations.html#foreign-keys Create a migration: rails generate migration migration_name For existing columns, in the migration add the foreign keys like this: class MigrationName < ActiveRecord::Migration def change … Read more
The .BAK files from SQL server are in Microsoft Tape Format (MTF) ref: http://www.fpns.net/willy/msbackup.htm The bak file will probably contain the LDF and MDF files that SQL server uses to store the database. You will need to use SQL server to extract these. SQL Server Express is free and will do the job. So, install … Read more
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
It sounds like you’re using a database that already has a users table, but no migration table. Therefore, when you run the migration, it’s attempting to create the users table again. There are two things you can try: 1) Try setting up a new (empty) database in MySQL and update the settings in your .env … Read more
I don’t know why nobody has mentioned the simplest and easiest way using robust MS SQL Server Management Studio. Simply you just need to use the built-in SSIS Import/export feature. You can follow these steps: Firstly, you need to install the PostgreSQL ODBC Driver for Windows. It’s very important to install the correct version in … Read more
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
Okay, I was apparently overcomplicating this. Here’s what I did. Created a new project in TFService Connected to that project in Visual Studio Cloned that project in Visual Studio git pull c:\source\oldGitProject That was it, it pulled all of the changes from the old location, and I could push that up to TFService easily.
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
Assuming fairly recent version of Rails you can always run: rake db:migrate:up VERSION=20090408054532 Where version is the timestamp in the filename of the migration. Edit: At some point over the last 8 years (I’m not sure what version) Rails added checks that prevent this from running if it has already been run. This is indicated … Read more
This was fixed by changing my Eclipse IDE version from indigo to luna. Luna comes with support for Java 8 so all issues have now been resolved.