Questions tagged [migration]

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

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

Migrate Oracle 12c to 18c in AWS RDS

Currently we have an Amazon RDS Oracle 12c instance and we need to upgrade it to Oracle 18c in a new RDS instance. What is the correct approach to do this? Can we set up an 18c instance staright ...
1
vote
1answer
119 views

Move Oracle Database to New Server with Dataguard in place

I have a live Oracle Database with Dataguard in placed. I want to migrate live database to new server as tech refresh, but only Primary database. How I can achieve this? I have ideas on how I want to ...
0
votes
1answer
277 views

MariaDB Replication - Replicate only specific tables and views

Note: A backend developer here with little to no experience in setting up database servers and replication. What needs to be done Setup DB replication of an existing database with the following ...
0
votes
0answers
28 views

How to “catchup” data after a backup

I need to transfer a database to another server with hopefully 0 downtime. I have Percona Mysql 8 on the destination and Mariadb on the source. I have successfully used Percona XtraBackup to create ...
0
votes
0answers
87 views

Migrating from MariaDB to Mysql - Duplicate Constraint Name

I am attempting to migrate from MariaDB to MySQL by doing a mysqldump from MariaDB and then restoring it to MySQL (mysql:latest docker container). I am getting the following error when importing into ...
0
votes
0answers
28 views

How to load generated Microsoft SQL Server database capture scripts into Oracle SQL Developer 19.4?

I'm following Oracle documentation to migrate an Microsoft SQL Server database to an Oracle schema. I have generated offline database capture scripts properly and I need to load those into Oracle SQL ...
0
votes
1answer
119 views

SQL Server 2000\2005 compatibility with Active Directory 2016

We are currently using Active Directory 2008R2 and will be upgrading to AD 2016. I'm trying to determine if there is any known compatibility issues when running older versions of SQL Server (2000 and ...
0
votes
0answers
4 views

iOS SO app not in App Store anymore

I went to peruse StackOverflow today. My last iOS update dumped all my apps to the cloud without me choosing to. Now when I went to download SO I receive a message that SO is no longer in the App ...
0
votes
1answer
80 views

Migration path to unify column names in backward compatible way

We have several naming schema for columns (like id/key or created/creation_date/create_date) and want to unify it. Also we want to do it in backward compatible way. We want to be able to run old code ...
0
votes
1answer
113 views

Obfuscate data during migration with MySQL Workbench

Is it possible to obfuscate sensible data during migration using MySQL Workbench? We are going to work on site so we need to make a copy for develpment but the (MySQL) database contains sensible user ...
1
vote
4answers
2k views

MariaDB - MySQL - ALL-DB Import - Table 'user' already exists

I am attempting to migrate from local MariaDB to Docker version which should in essence be as simple as migrating to a new SQL Server. I have setup the Docker container fine via but can't seem to ...
0
votes
1answer
255 views

Migrate SELECT query from oracle to postgresql

I want to migrate an oracle query to postgresql : here is the oracle version : SELECT replace(replace(replace( cf.NO_FACTURE||';'|| cf.MODULE||';'|| replace(replace(replace(cf.REF_FACTURE_SYBEL,'&...
0
votes
0answers
38 views

Migrate MongoDB 2.4.14 to MongoDB 3.6 [duplicate]

I have a database with MongoDB 2.4.14 and I want to migrate the database to MongoDB 3.6. Note: the file is original from the db path. Not from mongodump. This process is messy as it requires doing ...
1
vote
1answer
138 views

how can I get only the SQL server logins, when we use Export-dbalogin

when we run the export-dbalogin, it will will generate a script(.sql) file, which we will run the in the destination server, then the logins will be migrated, but this command will give both windows ...
0
votes
1answer
162 views

Configuration file missing after successful SSRS migration

Getting the backup of all SSRS databases including compressing and encrypting can be straight forward. However, when planning a complete solution for SQL Server Reporting services backup, following ...
0
votes
1answer
20 views

creating new table partition with values already existing in the default partition

I have the following table: CREATE TABLE orders ( info_date date, country_code VARCHAR, order_total int, CONSTRAINT orders_pk PRIMARY KEY (info_date, country_code) ) PARTITION BY LIST (...
0
votes
2answers
268 views

How to export large table data into different files in oracle?

I have a table which contains 1 million lines and need to export into different files which containing 100k lines each. sample_01.sql ,sample_02.sql and so on How can we take export like this in ...
0
votes
0answers
217 views

Import Sybase SQL Anywhere 8 DB into SQL Server without access to Sybase

This is my first post here and its a doosy. I am facing what seems to be a unique situation at the moment. I am in the process of moving my client to a new environment which includes decommissioning ...
0
votes
0answers
29 views

How Can I Move Column Definitions From One Table to Another (psql PostgreSQL)?

I have added many new columns to a table in my database in my local environment with ADD COLUMN statements, over 30. My application is split into multiple environments (UAT, STAG, PROD) and we are ...
0
votes
1answer
108 views

Data Migration from SQL Server to PostgreSQL

I need to migrate database from SQL Server to PostgreSQL. Both databases are on different servers. I have about 20 tables and millions of rows. What are the ways to accomplish this? I there any open ...
0
votes
1answer
21 views

Data Consistency Between Two MySQL Databases Running Different Versions

I need to migrate an old web application using old PHP and MySQL versions. I am intending to start by migrating the code that interacts with the database to a new server with the latest versions and ...
0
votes
2answers
207 views

Migrate database from one server to another without downtime

I want to migrate a MySQL database to another MySQL database (different server and only terminal access). I believe I can do a dump on it, but then I won't have the latest data. How do I make sure ...
1
vote
0answers
30 views

Mariadb running but mysql.sock is on different directory

I was trying to move my database to a larger partition according to this guide. My partition exists on /mdb/mysql-data, but when I edit the my.cnf file, it loads the old configuration on my.cnf.d/...
0
votes
0answers
66 views

Can Temporal Tables be implemented in SQL 2008 in a way that can be migrated to SQL 2016?

We have a system that is currently used by customers that have versions of SQL from 2008 R2 all the way to 2019. We want to start introducing, in a limited way, Temporal Tables, even for customers ...
0
votes
1answer
30 views

Migration DB postgresql in windows to Red Hat(linux)

I would like to know how I could migrate a postgresql database which is currently in a Windows operating system to Red Hat? I'm a beginner and I don't know where to start. Thanks .
0
votes
0answers
251 views

Best way to archive old data from SQL Azure?

I have an app that stores event data. We use SQL Azure. Right now it's very expensive. Over $800/month to host. Once the event is over, I want to move the data to a DB that has a lower cost. Thus this ...
1
vote
1answer
214 views

How to migrate Oracle Database to MariaDB? [closed]

Currently we have a server on Oracle version 18. We are planning to migrate to MariaDB. Is there any free service provided by MariaDB or oracle that helps migrate a database from Oracle to MariaDB?
0
votes
2answers
107 views

What's the best way to migrate a database to a server of a lower SQL version?

I have Database A on SQL Server 1 that is SQL Server version 2016. I need to migrate it to Server 2 that is SQL Server version 2012. Database A is pretty small, only about 5 GB total. I don't think ...
0
votes
1answer
93 views

How to daily copy selected data from MySQL and PostgreSQL servers to another PostgreSQL server

I have two source servers, a MySQL 5.7 and a PostgreSQL 9.6, respectively. I would like to daily update some tables from each source to another target PostgreSQL 11 server (via a cron-job). On the ...
0
votes
1answer
249 views

PostgreSQL vs Oracle double

More of rant, than a question, but maybe someone would explain -- why PostgreSQL migration wiki states that FLOAT (Oracle) is REAL (Postgres) and DOUBLE is DOUBLE PRECISION when in PostgreSQL ...
1
vote
1answer
91 views

postgresql logical replication — subscriber size discrepancy

I have a postgres 11 database in Amazon RDS with a little over 2 TB data in it whose tables have incrementing integer ids that are nearing exhaustion. I've been vetting using logical replication to ...
0
votes
1answer
62 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 ...
2
votes
1answer
94 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 ...
0
votes
1answer
17 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\...
36
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
32 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 ...
1
vote
0answers
1k 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
3answers
156 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
259 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
148 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 ...
-1
votes
1answer
164 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
148 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 ...
-1
votes
1answer
121 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
439 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
1answer
35 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
196 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 ...
4
votes
1answer
167 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
258 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
320 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
138 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 ...

1
2
3 4 5
16