Questions tagged [migration]

1

votes
2

answer
1.1k

Views

Laravel 5.5 Class 'Doctrine\DBAL\Driver\PDOPgSql\Driver' not found

I am working in laravel 5.5 with postgras 9.6, I manage to run all migration and rollback, but when I want to run migration for rename a column in Table i get the Class 'Doctrine\DBAL\Driver\PDOPgSql\Driver' not found error, hire is migration file: class CreateRenameApplicantIdInBillToApplicationId...
Joshua Kisanga
1

votes
2

answer
225

Views

How to use Typescript as compiler in node-migrate

To start, here's my migration script: const bluebird = require('bluebird'); const mongoose = require('mongoose'); mongoose.Promise = bluebird; mongoose.connect('mongodb://localhost:27017/app', { useMongoClient: true }); const schema = { uid: { type: String, }, parentID: { type: String...
Christopher Santos
0

votes
1

answer
13

Views

How to create a script that can migrate database to another normalized database

I have an existing system with hundred thousands of data. I need to migrate it to another database but different structure. How can i create a script that will migrate database to a different structure. I tried csv but i need to make some columns to foreign key because the new database is much norma...
1

votes
1

answer
59

Views

Is Event Sourcing helpful to Machine Learning

I am new to Event Sourcing, Event Store, Message Store and Machine Learning. And we are planning to implement message store and the reason they mentioned about implementing message store (instead traditional db, crud) is because the message store eventually helps in deep learning or machine learning...
Sreekanth Reddy
1

votes
1

answer
911

Views

Why we use laravel seed, if there is migration and eloquent that plays the role for database concept?

I confused about laravel seed concept. Let me clear, in laravel there is the eloquent and migrations that we use for CRUD operation for any database that then we use in our controllers. In seed also uses for the storing information in the database table. So why is it important instead of we have tho...
Jitendra Patwa
1

votes
2

answer
1.4k

Views

Django Project: namespace 'admin' isn't unique

on trying to run C:\Python34/python manage.py makemigrations, I get the following error: Error WARNINGS: ?: (urls.w005) URL namespace 'admin' isn't unique. You may not be able to reverse all URLS in this namespace What precisely do I need to change and where do I need to look? teachers/url.py from d...
MissComputing
1

votes
1

answer
800

Views

phinx migration 'up' vs. 'change' function

I have used phinx migration and used it's 'up' and 'change' functions but i did'nt notice any difference between them. Below is my migration file.
Abdullah Shoaib
1

votes
2

answer
1.1k

Views

laravel migration Specified key was too long; max key length is 767 bytes [duplicate]

This question already has an answer here: #1071 - Specified key was too long; max key length is 767 bytes 32 answers I'm trying for migrate a laravel migration but i had an error : Migrating: 2014_10_12_100000_create_password_resets_table Illuminate\Database\QueryException : SQLSTATE[42000]: Synta...
Artin Zareie
1

votes
1

answer
40

Views

What does 'As String * 25' mean when declaring a variable? [duplicate]

This question already has an answer here: Asterisks in variable declarations in VB6 1 answer I am trying to understand what this code means: Dim Duplicatecheck(0 To 10000) As String * 25 I see that it is a string array, but what does '* 25' do? I have looked high and low about vb6 arrays, but the...
paulgc
1

votes
0

answer
87

Views

How to migrate only category data in data-migration-tool from Magento1.8 to Magento2.2?

I want to migrate only category data from magento1 database to magento2 database. Is there any code for category in config.xml file of data-migration-tool?
Dhaduk Mitesh
1

votes
1

answer
41

Views

how to customize laravel user Migration to new

public function up() { Schema::create('users', function (Blueprint $table) { $table->increments('id'); $table->string('name'); $table->string('last_name')->nullable(); $table->string('phone_number')->nullable(); $table->text('Biography')->nullable(); $table->string('address')->nullable(); $table->st...
Najib jamshidi
1

votes
0

answer
74

Views

Is it safe to delete old CoreData xcdatamodel versions?

In my project I have too many CoreData model versions (two-digit number). It's a years-long project and stuff has been changed quite a bit through time. If I'm 100% sure all my users are using the latest model for quite some time now, is there a way I can get rid of old models and 'start fresh' with...
mixtly87
1

votes
1

answer
268

Views

Add A New Field To Existing Model - django.db.utils.ProgrammingError: column {field} does not exist

models.py I have a Scorecard model that has a ManyToManyField to another model named Account: class Scorecard(models.Model): .... name = models.CharField(max_length=100) accounts = models.ManyToManyField(Account) ... def __str__(self): return self.name My Account class currently has four fields (acc...
Jarad
1

votes
0

answer
159

Views

javax.management.ReflectionException: The MBean class could not be loaded by the default loader repository

We are migrating JBOSS from 4.0.3SP1 to Wildfly 10.1.0. Our applications are bundled in separate sars which contain standard as well as Dynamic beans. We are getting 'javax.management.ReflectionException: The MBean class could not be loaded by the default loader repository' exception caused by 'ja...
Manjusha
1

votes
1

answer
17

Views

Why “PG::UndefinedColumn:” from a column who come from a gem?

I've got a gem named Foo. In this gem I've got 2 branches : master and develop. In my project I need to use the develop branch (which contain new migrations). So in my gemfile I add : gem 'foo', git: 'https://github.com/orsay/foo.git', branch: 'develop' Then run bundle install then re launch my serv...
Orsay cp
1

votes
0

answer
59

Views

Can't connect to Oracle server from my machine using Microsoft's SSMA for Oracle tool

I'm trying to connect to Oracle 9i database from my machine (Windows 7 x64) using Microsoft's tool SSMA for Oracle v7.6.0 but getting the following error : System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. A quick search on the Internet shows that this error messa...
mounaim
1

votes
1

answer
177

Views

How to dynamically define morph unassigned type in Laravel migrations

I'm wondering about one particular subject: I defined a relation via morph, then started to develop migration file, and all table primary keys have BIGINT type. I doubt about supporting BIGINT in morphmigrate, because I saw this line in Illuminate\Database\Schema\Blueprint : $this->unsignedInteger('...
Moe Far
1

votes
0

answer
276

Views

Upgrading from Glassfish 2.1.1 to Glassfish 4.1

Can someone please enlighten me. I'm trying to upgrade my Glassfish 2.1.1 to Glassfish 4.1. I've decided to do a side by side install as indicated here: https://docs.oracle.com/cd/E26576_01/doc.312/e24942/upgrading-legacy-installation.htm#GSUPG00039 Question are: (1) What is 'as-install'? There's n...
Cyberpau
1

votes
0

answer
48

Views

Migrating Bot Framework to Azure Bot Service: Subscription not in list

When trying to migrate my bot on https://dev.botframework.com/bots to Azure Bot Service the selection list of the target subscription only includes one of my several Azure subscriptions for this user. The subscription shown is the wrong one - and all others - including the correct one - are missing....
AndreasR
1

votes
0

answer
394

Views

Drupal 8 custom migration with source csv

How can I import fields into Drupal 8 user profile from a csv file that has identical values in the key row? I'm using Migrate Tools, Migrate Plus and Migrate Source CSV. My CSV file looks like that: 'Stg';'Color';'Fruit' 'user1';'red';'apple' 'user1';'blue';'pear' 'user2';'green';'banana' 'user2';...
Markus Zerres
1

votes
1

answer
33

Views

Moving projects from Jira Cloud based server to local server

We read a lot about issues when moving from one Jira server instance to another. Is it really that difficult and any risks regarding it? What i want to do: Move some projects from Jira cloud based server instance to locally host server. Our projects are not big, and there are not any plugins used. T...
Vdlight
1

votes
1

answer
90

Views

ASP.Net MVC migration: access field you're deleting

During a code-first migration, is there any way to access a field that is guaranteed to still exist in the database but may not exist in your model anymore? Context: I am trying to switch from a one-to-many-relation (a one-way reference) to a many-to-many-relation (a mapping table). Of course I woul...
Zeust the Unoobian
1

votes
1

answer
152

Views

Can you perform linear migrations on a Synced Realm in Realm JS?

I have had no problems with doing Realm JS linear migrations on a local Realm when following this example in the docs: https://realm.io/docs/javascript/latest/#linear-migrations However when I have attempted to do Realm JS linear migrations on a local Realm that is synced with the Realm Object Sever...
509dave16
1

votes
1

answer
267

Views

ExceptionFilterAttribute in Azure Functions

I'm trying to migrate a WebAPI application to Azure Functions. I have searched on the net and haven't found anything equivalent to ExceptionFilterAttribute supported in Azure Functions. Does this mean that to migrate this feature, we should wrap the code of every function in try catch blocks and the...
stormtrooper
1

votes
0

answer
116

Views

Use alembic.ini for configuring db connection charset

I am performing migrations using alembic. Configuration is of course stored in the alembic.ini file. I would like to have the encoding used when running the migrations as a configurable parameter. Is there a field that can be used within alembic.ini to do so? e.g. [various_config] migrations_encodin...
pkaramol
1

votes
0

answer
75

Views

How to run doctrine migrations from the php code?

I am trying to integrate database migrations into my project. My project is a plugin for a php framework which is powered by the plugins (each plugin have its own migration scripts). Usually (or always ...) these migration scripts are represented as .sql scripts. Framework applies these scripts dur...
Meiblorn
1

votes
0

answer
35

Views

Rollback only affected rows

I am filling the published_at information in the migration like so: Blog::all()->each(function($blog) { if($blog->published_at == null) { $blog->update(['published_at' => $blog->created_at]); } }); The question is: how should my down() function look like? I cannot just Blog::all()->each(function($bl...
Epsilon47
1

votes
1

answer
84

Views

Rails rollback DB and revert select commits

We have a feature (that contained some DB migrations and 50+ changed files) that was merged into master a few commits ago. The powers that be now want that whole feature removed. There have been no new migrations since this feature was added though there have been some new commits that we want to ke...
Meltemi
1

votes
0

answer
39

Views

AWS architecture Account migration strategy

I will soon be asked to migrated an AWS architecture, including instances' content and DB records from one AWS account to another and I would like to hear from you all how would you define a possible strategy to tackle it: Say we have 2 AWS accounts (A1, A2). A1 was used as Proof of Concept to decid...
user3665949
1

votes
2

answer
80

Views

Django: set foreignkey to model of which `abstract` True…?

I've designed some model structures in django: class Symbol(BaseModel): field1 = models.CharField(max_length=50) class Meta: abstract = True class DetailSymbol1(Symbol): field2 = models.CharField(max_length=50) class DailyData(BaseModel): symbol = models.ForeignKey(DetailSymbol1) field3 = models...
user3595632
1

votes
2

answer
450

Views

php artisan migrate. Multiple primary key defined

My Problem I'm building my first api using laravel and am getting a multiple primary key defined error while trying to run php artisan migrate I don't understand how I have defined multiple primary keys. Every time I run a migrate I get these errors php artisan migrate error. My Troubleshooting I t...
jermayne williams
1

votes
2

answer
150

Views

org.springframework.web.servlet.DispatcherServlet error in migration from Spring 3.0 to Spring 3.1

I'm migrating a web application from Spring 3.0 to Spring 3.1. These are the depencies I changed in the pom, for every dependency I changed 3.0.3.RELEASE to 3.1.4.RELEASE: org.springframework spring-struts 3.1.4.RELEASE jar compile org.springframework spring-context-support 3.1.4.RELEASE jar compile...
Luke
1

votes
0

answer
1.7k

Views

How do I resolve encryption error connecting to SQL Server from Oracle SQL Developer

My objective is to use the migration tool in SQL Developer to migrate 2 SQL Server databases to Oracle. I am attempting to connect to a SQL Server database at a remote location using Oracle SQL Developer 4.0. I have installed jtds.1.3.0.jar per instructions, and get the SQL Server and Sybase tabs...
Marlin
1

votes
0

answer
399

Views

Sequelize-cli how to create seed files from an existing database?

Issue: In order to start in a clean environment for developing stuff for a web app I would appreciate to be able to retrieve some data from an existing DB (let say the 10 first lines of every tables) in order to create a sequelize seed file per table. It will then be possible to seed an empty DB wit...
s.k
1

votes
0

answer
597

Views

Sequelize-cli how to generate a migration file from an existing model?

Issue: In order to start in a clean environment for developing stuff for a web app I would appreciate to be able to duplicate (clone) an existing DB structure into both a sequelize model + migation files and then seed this with dumb data. I have found the tool named sequelize-auto which seems to wor...
s.k
1

votes
2

answer
234

Views

Is there Linux kernel version limitation for virtual machines to run on GCE?

I migrated CentOS6.0 run on VirtualBox to GCE by using CloudEndure, but migrated VM could not be launched by following error: SeaBIOS (version 1.8.2-20171012_061934-google) Total RAM Size = 0x00000003c0000000 = 15360 MiB CPUs found: 4 Max CPUs supported: 4 found virtio-scsi at 0:3 virtio-scsi vendor...
Shuhei Okuda
1

votes
0

answer
474

Views

How to migrate gitlab from 7.8 version to 10.4?

I have GitLab 7.8.4. And now I need to migrate on new 10.4 version on another server. I'll tried to copy /git-data/repositories into new server but this is not enough. Can some one describe the steps for this migration? Is that posible for new version? UPD I can't restore with sudo gitlab-rake gitl...
user2003024
1

votes
1

answer
107

Views

Migrating to Gradle 4.5.1 (android buildtool 3.0.1) throwing ClassNotFoundException

I am migrating project to newest Gradle version. The build is successful, but when start application I got ClassNotFoundException. Main method code: public static void main(String[] args) { Bridge app = new Bridge(); GatewayServer server = new GatewayServer(app); System.out.println('Python Bridge Ru...
M.P.
1

votes
1

answer
15

Views

deleted local migration file before pushing to heroku

I've somehow managed to delete a local migration file before I pushed to heroku. I have migrated the change locally so all works fine on my machine, but when checking the table on heroku I can see that a specific column is missing. I've tried adding the migration directly on heroku by running: hero...
Simon Cooper
1

votes
0

answer
57

Views

Java - Migrate Database using JPA

I'm brand new to Java Development (comercially) and I just wanted to know if there's an equivalent to EntityFramework in Java. Something that can update my database quickly. For some of you that have already worked with .NET, you know that I can add a model, embed it into my dbcontext class and then...
RottenCheese

View additional questions