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
You should be able to find some useful information in the accepted answer in this Serverfault page: https://serverfault.com/questions/65407/best-tool-to-migrate-a-postgresql-database-to-ms-sql-2005. If you can get the schema converted without the data, you may be able to shorten the steps for the data by using this command: pg_dump –data-only –column-inserts your_db_name > data_load_script.sql This load will be quite slow, … Read more
set the Database.SetInitializer to null. public class DatabaseContext: DbContext { //the base accepts the name of the connection string provided in the web.config as a parameter public DatabaseContext() : base(“DatabaseContext”) { //disable initializer Database.SetInitializer<DatabaseContext>(null); }
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 would just do the following on both the environments (as long as the code is the same) Delete your migrations folder DELETE FROM django_migrations WHERE app = <your app name> . You could alternatively just truncate this table. python manage.py makemigrations python manage.py migrate –fake After this all your changes should get detected across … Read more
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
For 20 years, the JDK shipped with a JRE which was just a subset of its functionality installed in a different directory on your system. In fact, it shipped with TWO identical JREs, one installed inside the JDK installation directory and one outside it. This has always puzzled me as it’s a complete waste of … Read more
Where: class Teacher < ActiveRecord::Base has_and_belongs_to_many :students end and class Student < ActiveRecord::Base has_and_belongs_to_many :teachers end for rails 4: rails generate migration CreateJoinTableStudentTeacher student teacher for rails 3: rails generate migration students_teachers student_id:integer teacher_id:integer for rails < 3 script/generate migration students_teachers student_id:integer teacher_id:integer (note the table name lists both join tables in alphabetical order) and … Read more
Provide the :name option to add_index, e.g.: add_index :studies, [“user_id”, “university_id”, “subject_name_id”, “subject_type_id”], unique: true, name: ‘my_index’ If using the :index option on references in a create_table block, it takes the same options hash as add_index as its value: t.references :long_name, index: { name: :my_index }