Stack Overflow
Stack Overflow

Questions tagged [sqlmigrations]

Solution for Entity Framework Code First that will incrementally evolve the database schema as the model changes over time. See [tag:ef-migrations] tag for more recent versions

12 questions
5
votes
1 answer

SQL Server: From 2008 To 2014 :-The data types datetime and time are incompatible in the add operator. Any other solution?

I am migrating from SQL Server 2008 To 2014 and I get an error The data types datetime and time are incompatible in the add operator. I figured out the solution convert time to DateTime, but I have changes in many stored procedures and views. Is…
Mhadonis
  • 330
  • 3
  • 11
3
votes
1 answer

C# FluentMigrator.Runner console app set transaction per session

I am using FlunetMigrator.Runner.3.2.1 and see that this version no longer defaults to rolling back all migrations is one of them fails. It says they are per migration file! which doesn't add value. Is there a way to set the transaction per session…
Andrew
  • 2,571
  • 2
  • 31
  • 56
2
votes
1 answer

Unable to create migration plan because of XXXX: unknown migration in database

I'm using the migration package github.com/rubenv/sql-migrate. I had my migration files (a bunch of .sql files) in migrationFilesBaseDir. The function DoMigrations contains my migration logic like so: func DoMigrations(dsn, migrationFilesBaseDir…
Ercross
  • 519
  • 6
  • 17
2
votes
1 answer

Can I undo 'Mark as Deployed' option in ReadyRoll?

I marked 2 scripts as deployed and checked in my changes to TFS. Can I undo this in the ReadyRoll project?
dsingh23
  • 185
  • 3
  • 14
1
vote
1 answer

Error while doing assessment using Data migration assistant (DMA) tool

Getting error while doing assessment using DMA tool for choosing assessment type as Integration Services. Error message : The assessment of database 'Package store' on server 'STP637388' failed. The error message: 'Failed to assess SSIS packages or…
Nilesh Patel
  • 15
  • 5
1
vote
0 answers

Migrating SQL Server Replication

I have a production server with transaction replication in place. I am only migrating the publisher server to a Windows Server 2012 for TLS 1.2 compliance. The SQL Server version is staying the same: 2008 R2. The distribution server and the…
Shawn
  • 11
  • 1
1
vote
0 answers

Migrate sql schema to many databases using Flyway

I'm trying to write a simple Java sample application which uses Flyway to migrate many databases on one IP. When I run this application it completes without error but nothing seems to happen, the schema_version table is not created. public static…
Владимир Гичев
  • 317
  • 2
  • 17
0
votes
1 answer

verification of SQL Managed Instance migration

is there a way to verify that a SQL Server to an Azure SQL Managed Instance migration was successful? More detailed question would be, how can I check that there is no data corruption? Is there is not, it is because CHECKSUM in Backups is…
Carles G
  • 15
  • 4
0
votes
1 answer

MySQL 8: Create Collections via DDL

I’d like to be able to create MySQL Document Store Collections via simple SQL DDL statements rather than using the X-Protocol clients. Is there any way to do so? Edit: I’ll try and clarify the question. Collections are tables using JSON datatypes…
raine
  • 817
  • 1
  • 15
  • 26
0
votes
2 answers

Update database from models using entity framework in multi tenant .net core

I am using .net core entity framework. I have multi tenant dbs. so I have kept one root tenant db as base. and I want to replicate those schema changes to all other dbs using entity framework. I am generating my models using following…
Anonymous Creator
  • 2,968
  • 7
  • 31
  • 77
0
votes
1 answer

Creating yii migration from demo blog sql

I have a SQL code from yii demo blog: CREATE TABLE tbl_post ( id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, title VARCHAR(128) NOT NULL, content TEXT NOT NULL, tags TEXT, status INTEGER NOT NULL, create_time INTEGER, …
SkyStar
  • 169
  • 1
  • 3
  • 14
-1
votes
1 answer

Database migration tool for webapp2

I'm new to webapp2 and GAE. I'm wondering, do I must declare all database tables necessarily for my models? I do not mind writing SQL by hand. But I do not want reinvent the wheel. Is there any db migration tool for Webapp2? EDIT I have a…
I159
  • 29,741
  • 31
  • 97
  • 132