Questions tagged [migration]

the process of moving databases or data from one place to another

Filter by
Sorted by
Tagged with
0 votes
1 answer
99 views

Migrate MySQL to another partition in same server

I have a instance of MySQL in a local server. To improve the performance, I put a SSD just for MySQL. Now I need migrate the MySQL instance, with my databse (a data has 25GB) for the SSD. What the ...
user avatar
2 votes
1 answer
190 views

How to migrate SQL Server 2014 to SQL Server 2019 on Linux using AG [closed]

I would like to migrate SQL Server 2014 on Windows to SQL Server 2019 on Linux using while running AG. Is there an option to Add the SQL Server 2019 to the same AG and once the time comes gracefully ...
user avatar
0 votes
1 answer
19 views

Fail to copy all PostgreSQL databases between servers although there is no error message

I want to copy all databases from PostgreSQL 9.3 on Server-1 (Windows 7) to an empty PostgreSQL 12.0 on Server-2 (Windows Server 2012 R2). The steps are as follows: On Server-1: C:\Program Files\...
user avatar
  • 111
36 votes
5 answers
6k views

Can I write portable SQL statements?

I am wondering if it is possible to write SQL statements that are 100% interoperable with most or all databases including: MariaDB/MySQL/Percona Postgres Microsoft SQL Oracle SQLite (Eg, can I just ...
user avatar
0 votes
1 answer
37 views

Migrate servers involved in replication

We are planning to migrate two servers with MSSQL 2012 servers with configured transactional replication. New servers will have new names, ip addresses and MSSQL 2014. Subscriber is used for reporting ...
user avatar
1 vote
0 answers
2k views

What are the risks if you rename a server that hosts a named instance of SQL Server (2005) and skip updating the system metadata?

My apologies as this is the last SQL 2005 instance we have and it's pretty urgent or I wouldn't go through all this trouble asking. Questions What is the risk to leave things as they currently are, ...
user avatar
1 vote
3 answers
266 views

From MySQL to MariaDB : bad performances issue with MyISAM tables

I'm currently migrating a Debian 6 MySQL server (5.1.73) to a fresh new Debian 10 MariaDB server (10.3.18). Please note that I'm not a database expert. All tables are under MyISAM engine storage, for ...
user avatar
  • 11
0 votes
2 answers
370 views

Migrate MySQL to MSSQL with views

I have one MySQL database and I want to migrate it with data to MSSQL. I have tried a few tools including MS SQL server Import and Export wizard, DataLoader, ESF Database migration toolkit, mysqldump ...
user avatar
2 votes
1 answer
334 views

Is it possible to migrate data from a shard MongoDB to a non-shard MongoDB with dump

Question: I have a shard mongo cluster and I want to migrate data from this cluster to a one node mongo instance. So I want to know is it possible to use dump/restore? I use pymongo and Django ...
user avatar
  • 123
-1 votes
1 answer
211 views

Copying a Filemaker Database running with an ODBC Connection

Work has a custom Filemaker Pro application, and it has an ODBC connection for the company website to access. I want to migrate the FMP database into a MySql/MariaDB database to tinker on Schema ...
user avatar
  • 11
0 votes
1 answer
308 views

Change Azure Standard to Premium

I have one application using SQL Server Standard and would like the change to Premium, but I need to understand about the DTU. The application reaches 100% in DTU every day. Would talk know if I need ...
user avatar
-1 votes
1 answer
169 views

ORACLE DMU (database migration assistant for unicode) Tool

Reading the documentation for Oracle DMU tool, when I try the step create a step for DMU Repository tablespace the document says to use the result of the query for initial size. However; I could not ...
user avatar
3 votes
1 answer
661 views

How to install Distributed Replay (dreplay.exe) for SQL Server 2017

In SQL Server 2014, dreplay.exe was available under "Management Tools – Basic" feature. However, in SQL Server 2017 that feature no longer exists (Enterprise edition) and it doesn't come with SSMS ...
user avatar
  • 131
0 votes
1 answer
47 views

Migrate legacy application to new db/schema

I apologize if I made any mistake/missing info, fist post here! I am in the process of rewriting a website from scratch to a newer tech stack with a completely redesigned architecture. The website in ...
user avatar
  • 101
1 vote
0 answers
301 views

What All Is Factored Into A MySQL Checksum? (Why Could They Be Different?)

I'm currently going through the excruciating task of moving MySQL databases from one shared web hosting environment to another. This has been a multi-month battle (and I'm learning a lot). After ...
user avatar
  • 113
4 votes
1 answer
520 views

Migrate large (200GB) mysql databases to new hosts with as little downtime as possible

My question is about migrating large amounts of MySQL data with as little downtime as possible. I have 3 MySQL databases that need to be moved from one RDS instance inside a VPC into a brand new AWS ...
user avatar
1 vote
4 answers
445 views

How to prevent a full database backup

We are in the middle of migration, a full backup has been taken and copied to the destination. On Friday, we plan to do a differential backup, but someone has by mistake taken another full backup (did ...
user avatar
  • 11
0 votes
1 answer
623 views

Moving Partitioning Files To Another Disk Drive In SQL Server

There is a production table which was partitioned by someone in our company. Some partitioning files was wrongly located to different disk drive. I have to move those files to the disk where they ...
user avatar
  • 25
0 votes
2 answers
415 views

Can a SELECT statement block an ALTER TABLE?

I see in Postgres docs: Two transactions cannot hold locks of conflicting modes on the same table at the same time During maintenance (schema migration) we saw cases when we can't ALTER TABLE ...
user avatar
  • 429
3 votes
2 answers
286 views

Migrate foreign key type from char to binary - ways to deal with the fallout?

I am in the process of slimming down a database that has been using char/varchar fields where binary/varbinary would be a better choice (given the data represented is byte arrays). One of the fields ...
user avatar
  • 334
0 votes
1 answer
142 views

What are possible ways to migrate SQL Server DB to PostgreSQL DB? [closed]

Currently I am assigned to complete the task of migrating several small to large databases (from 10GB to 200GB) from SQL Server to PostgreSQL RDBMS. I would like to ask the community to share ...
user avatar
  • 2,193
1 vote
1 answer
45 views

SQL Server - Migration script testing - Refresh table definition manually without dropping it

How can a table definition be manually refreshed without also manually crafting a bunch of ALTER TABLE statements, or dropping and recreating the table? This is normally handled by the publish ...
user avatar
0 votes
1 answer
117 views

how to upgrade postgresql 9.0.4 to latest with minimum downtime

I have master-slave-slave setup for postgresql 9.0.4 in our production setup. We need to upgrade it to latest (11.X), so my question is what would be the procedure to do so with as little downtime as ...
user avatar
0 votes
0 answers
354 views

Migrate Mariadb 10.3 to Mysql 8

What is failsafe way to migrate ? Both database are on CentOS 7 different servers and latest versions of database.
user avatar
  • 1
3 votes
3 answers
1k views

How to Exclude Foreign Keys during Publish action in sqlpackage

I am trying to publish a .dacpac extract to a target database, I want to exclude just the foreign key constraints in all the tables. After going through the ExcludeObjectTypes options I do not find a ...
user avatar
0 votes
0 answers
546 views

SSMA cannot read meta data (missing runtime components)

What I want to do should be rather easy: Use SSMA to transfer internal Access tables and queries to SQL-Server. On my Notebook I'm running SQL-Server 2017 and Office 365 (32 bit) As I have 32 bit ...
user avatar
  • 553
0 votes
0 answers
24 views

What is the best way to migrate old data into a running mariadb database?

We have a need to migrate a large number of 100GB databases onto a new infrastructure. I would like to minimise downtime as much as possible, so am toying with the idea of migrating the clients to ...
user avatar
2 votes
1 answer
2k views

Adding indexes to production MySQL database without downtime?

I am looking to improve the performance of queries on a large MySQL database that is running in production by adding proper indexes. We have tried to add the indexes on the live database, but of ...
user avatar
5 votes
3 answers
3k views

SQL Managed Instance - Cross Subscription Restores/Migration

Short Version: I am trying to restore a backup from one SQL Managed Instance to another SQL Managed Instance. These are in different subscriptions. Using Example 3 from here I can at least get it ...
user avatar
2 votes
2 answers
357 views

Migration to SQL Database using Transaction Replication - down time?

I am looking to migrate two on-prem SQL Servers into Azure Hyperscale. Both 28 cores, 1.5 TB of RAM with 10TB data disks. I can NOT afford any downtime during the migration and have heard transaction ...
user avatar
  • 21
0 votes
1 answer
248 views

Issue migrating oracle package to postgres using ora2pg

I was migrating an oracle(12c) package to postgres(Enterprise db 10.5) using ora2pg. The migration run successfully for most of the functions. However, one function referenced multiple times in the ...
user avatar
  • 3
1 vote
2 answers
334 views

Replicate a database with a subset of data offered by custom queries [closed]

As seen in this question I can use the following sql command: CREATE DATABASE newdb WITH TEMPLATE olddb; In order to replicate a database into my machine. But in my case my new database only to ...
user avatar
1 vote
2 answers
116 views

MS SQL Server Error 18456 after database move [duplicate]

I have a windows service connecting to a SQL database. Recently, I was told to change the DB name in the connection string, all else was the same. When I attempted to connect, it threw Error 18456. ...
user avatar
0 votes
1 answer
119 views

Does Data Migration Advisor migrate system databases?

I would like to know if Data Migration Assistant copies system databases (master, model, msdb) into the new server.
user avatar
  • 1,163
0 votes
0 answers
230 views

Migrating from windows-1252 to UTF-8 character set

I'm thinking of migrating my database (oracle) from windows-1252 to UTF-8 by doing the following: export all data (backup) truncate all tables run alter database character set import data back Is ...
user avatar
0 votes
1 answer
102 views

Replicate SQL Server 2008 across domains

I have been tasked with migrating a database, size being up to 15Gb, from a SQL Server 2008 database in a 3rd party cloud VM, to SQL Azure. On go-live day, when we switch from the old host, the Azure, ...
user avatar
  • 323
-4 votes
1 answer
146 views

Is SQL Server 2016 already in a good shape to be used? [closed]

So it's time to upgrade out servers. I'm new in this company and we have SQL Servers from 2008 to 2014. I really don't see a problem upgrading all of them to 2014 because it's really wel documented ...
user avatar
  • 7,100
0 votes
0 answers
208 views

How do I migrate mysql .frm and .ibd files to sqlite?

Mysql seems to not work anymore on my machine. I have spend way too much time trying to fix it but without success. But I found out that sqlite does all the stuff I need so why not just change to it. ...
user avatar
  • 1
0 votes
1 answer
117 views

"Cannot open user default database. Login failed" after altering MDF and LDF locations and bringing DB offline

I was attempting to move my database to a separate hard drive on the server, so I ran the following commands in the following order (I was following this question : How to change location of SQL ...
user avatar
  • 103
0 votes
2 answers
625 views

Migrate large postgresql database (windows -> linux) [closed]

I have a "large" PostgreSQL (9.6 with timescale plugin) database (about 1Tb). And would like to migrate it to a Linux machine. The naive approach would be pg_dump and pg_restore. (Not sure how long ...
user avatar
1 vote
0 answers
32 views

Centralizing Databases

I have a very challenging scenario at hand and would like to hear suggestions on the solution I am considering implementing. I have several databases that have similar (non-identical) structures and ...
user avatar
0 votes
1 answer
111 views

How to speed up Oracle to PostgreSQL data transfer

I have an Oracle schema that I am transferring to PostgreSQL with ogr2ogr. This particular table has 5 columns with number(22) each. There are some 300M rows. In under 10 minutes I can transfer this ...
user avatar
  • 213
2 votes
1 answer
135 views

pg_restore "CREATE CAST" not executed if using public or pg_catalog schemas

While moving database to another instance I'm using pg_dump and pg_restore with intermediate file. Dump file was created like this: pg_dump --host $SRC_DB_HOST --port 5432 "dbname=$SRC_DB user=$...
user avatar
  • 123
1 vote
1 answer
44 views

Inspecting the status of a long-running COPY statement

I need to migrate a table from one PostgreSQL database to another. There was a chance I would need to fix some data, so I exported to a CSV. Then I imported the CSV in the second database with a COPY ...
user avatar
  • 515
0 votes
1 answer
285 views

Mongo replication sync to newer version

I got one mongo v2.4.10 server with 1.7TB data, I am trying to migrate and upgrade the mongo to mongo v.3.0.15 server I've setup a new mongo v.3.0.15 and configured replication for v3.0.15 to be ...
user avatar
0 votes
1 answer
3k views

Postgres column type unknown

I am trying to port a database where there is a table with a column of type unknown. pg_restore raised the error pg_restore: [archiver (db)] could not execute query: ERROR: column "color" has ...
user avatar
  • 75
1 vote
1 answer
55 views

Legacy data migration to Always on Availability group database

In our application there is a data conversion process that brings all the legacy data to the production database. Since our database is on availability group and the migration might bring 100GB + ...
user avatar
  • 1,007
1 vote
1 answer
329 views

Help using SQL Server Database Experimentation Assistant for performance testing

I am following the guide for capturing a trace in SQL Server Database Experimentation Assistant here: https://docs.microsoft.com/en-us/sql/dea/database-experimentation-assistant-capture-trace?view=sql-...
user avatar
  • 147
0 votes
1 answer
325 views

WHILE Loop for data migration/merge with multiple fields for matching

Ok so I have two identical databases in two parts of the world. I need to merge everything into the one I will call North (the other being South). North data trumps South data. I started thinking ...
user avatar
1 vote
1 answer
3k views

Can I upgrade SSIS 2008 packages directly to SSIS 2017 SSISDB?

I'm planning a mifgration of a SQL Server 2008 instance running the DB engine and SSIS. The SSIS is deployed to the file system. Am I able to copy those SSIS packages to a directory on my new ...
user avatar
  • 362

1 2 3
4
5
17