Questions tagged [migration]
the process of moving databases or data from one place to another
706
questions
0
votes
1answer
16 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\...
34
votes
5answers
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 ...
0
votes
1answer
26 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 ...
0
votes
1answer
86 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, ...
1
vote
2answers
66 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 ...
0
votes
2answers
36 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 ...
2
votes
1answer
32 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 ...
0
votes
0answers
10 views
Applying batch of row changes (delete) MySQL Replication Stuck
I am using Master Slave replication for master and slave .
Master Configuration
64 GB RAM 2 TB SSD
Slave Configuration :
16 GB RAM 2 TB SSD
My database size is 750 GB.
When i configured ...
-1
votes
1answer
45 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 ...
0
votes
1answer
20 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 ...
0
votes
1answer
70 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 ...
3
votes
1answer
130 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 ...
0
votes
0answers
99 views
Removing foreign keys to reduce downtime
In an attempt to reduce downtime on our production servers we are considering using one of the following tools to do schema migrations without any downtime:
Percona Toolkit — pt-online-schema-change
...
0
votes
1answer
28 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 ...
1
vote
0answers
27 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 ...
0
votes
0answers
29 views
Need to move ssis package from SQL server 2008 to 2012
We have to move ssis package from SQL server 2008 to 2012 on another server. Package on source is stored in msdb.
What is the best way to move the packages to 2012?
3
votes
1answer
56 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 ...
1
vote
4answers
142 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 ...
0
votes
1answer
61 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 ...
0
votes
2answers
40 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 ...
0
votes
3answers
63 views
Error messages while migrating from Oracle to MSSQL [closed]
I got these error messages when migrating from Oracle to MSSQL (Unfortunately, the error messages are in German languages)
Verletzung der PRIMARY KEY-Einschränkung "DTR_PK". Ein doppelter Schlüssel ...
3
votes
2answers
249 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 ...
0
votes
1answer
47 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 ...
0
votes
0answers
23 views
SSMA - Sysdb - Tables Missing
Based on my test, when I use SSMA for Oracle.8.4.ExtPack.exe to install, after the installation, I can see the table ssma_oracle.bcp_migration_packages and other tables are not in the sysdb database,
...
1
vote
1answer
44 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 ...
0
votes
1answer
35 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 ...
0
votes
0answers
35 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.
2
votes
2answers
111 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 ...
0
votes
0answers
126 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 ...
0
votes
0answers
20 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 ...
2
votes
1answer
78 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 ...
3
votes
2answers
135 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 ...
1
vote
2answers
97 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 ...
0
votes
1answer
41 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 ...
1
vote
2answers
93 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 ...
1
vote
2answers
56 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. ...
0
votes
1answer
34 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.
0
votes
0answers
63 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 ...
0
votes
0answers
64 views
Not able to migrate DTS package from SQL Server 2008 to 2012. Getting errored out
Requirement: We need to migrate SSIS/DTS package from SQL Server 2008 to another machine having SQL Server 2012 on it.
Steps performed so far:
1. First I exported the package from Source server to ...
0
votes
1answer
54 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, ...
-4
votes
1answer
145 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 ...
0
votes
0answers
58 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. ...
0
votes
1answer
80 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 ...
0
votes
2answers
50 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 ...
1
vote
0answers
26 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 ...
0
votes
1answer
30 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 ...
2
votes
1answer
33 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=$...
1
vote
1answer
31 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 ...
0
votes
1answer
116 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 ...
0
votes
1answer
260 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 ...
