It’s funny though, MongoDB was born to respond to the schema problems in RDBMS. You don’t have to migrate anything, all you have to do is set the default value in the schema definition if the field is required. new Schema({ name: { type: string } }) to: new Schema({ name: { type: string }, … Read more
Agreed, your model is probably wrong. The formal primary key should always be a surrogate key. Never anything else. [Strong words. Been database designer since the 1980’s. Important lessoned learned is this: everything is changeable, even when the users swear on their mothers’ graves that the value cannot be changed is is truly a natural … Read more
This is what I did to make Automatic Lightweight Migration (Source: http://brainwashinc.wordpress.com/2010/01/18/iphone-coredata-automatic-light-migration/) 1. Set the Persistent Store options for automatic migration in the app delegate. Change your persistentStoreCoordinator creation to this (replace YOURDB): – (NSPersistentStoreCoordinator *)persistentStoreCoordinator { if (persistentStoreCoordinator != nil) { return persistentStoreCoordinator; } NSURL *storeUrl = [NSURL fileURLWithPath: [[self applicationDocumentsDirectory] stringByAppendingPathComponent: @”YOURDB.sqlite”]]; // … Read more
In SSMS in the Object Explorer, right click on the database, right-click and pick “Tasks” and then “Generate Scripts”. This will allow you to generate scripts for a single or all tables, and one of the options is “Script Data”. If you set that to TRUE, the wizard will generate a script with INSERT INTO … Read more
Update: See @GwynBleidD’s comment below for the problems this solution can cause, and see @Rockallite’s answer below for an approach that’s more durable to future model changes. Assuming you have a fixture file in <yourapp>/fixtures/initial_data.json Create your empty migration: In Django 1.7: python manage.py makemigrations –empty <yourapp> In Django 1.8+, you can provide a name: … Read more
Following the Jenkins wiki, you’ll have to: Install a fresh Jenkins instance on the new server Be sure the old and the new Jenkins instances are stopped Archive all the content of the JENKINS_HOME of the old Jenkins instance Extract the archive into the new JENKINS_HOME directory Launch the new Jenkins instance Do not forget … Read more
You can use both YEAR(timestamp) and WEEK(timestamp), and use both of the these expressions in the SELECT and the GROUP BY clause. Not overly elegant, but functional… And of course you can combine these two date parts in a single expression as well, i.e. something like SELECT CONCAT(YEAR(timestamp), “https://stackoverflow.com/”, WEEK(timestamp)), etc… FROM … WHERE .. … Read more
You will need to post the table definitions for the source and destination tables for us to figure out where the issue is but the bottom line is that one of your columns in the source table is bigger than your destination columns. It could be that you are changing formats in a way you … Read more