Questions tagged [migration]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
13 views

I would like to migrate SQL SERVER 2014 to SQL SERVER 2019 on Linux using AG

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 ...
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
89 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
37 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
133 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
48 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
24 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
113 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
129 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
79 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
137 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
99 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
43 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
59 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
65 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
59 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
82 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
117 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 ...