Questions tagged [migration]
the process of moving databases or data from one place to another
754
questions
1
vote
0answers
10 views
MYSQL Huge Data migration (5TB) from old server to new server
We have an old MYSQL server contains huge data ~5TB and wanted to migrate to the new server in order to minimize the costs and get rid of very old hardware.
My one and only idea in my mind is using ...
0
votes
0answers
16 views
how to migrate a mongodb over a couple of versions safely & efficient?
what is the best method to migrate a database (or at least 1 of 6 collections) from mongodb 2.4 to 4.4 with "reasonable effort"?
i know there is mongodump/mongorestore, which is considered ...
-1
votes
0answers
16 views
Database Migration Assistant VS Upgrade Advisor
I know this might be more of product based but i need few inputs as have never used upgrade advisor ever before when doing migration:
I see that MS has replaced upgrade Advisor with DMA so i am trying ...
0
votes
0answers
18 views
Migrate a DB2 table with BLOB to MySQL
I am trying to migrate a DB2 database (v 11.1) to MySQL (v 5.7). I have tried using DBConvert (https://dbconvert.com/db2/mysql/) which works quite well for "normal" tables but fails at a ...
0
votes
1answer
21 views
Perl Script to call Oracles stored procedure with input parameter and OUTPUT parameter ,CURSOR
I am finding difficulty in fetching the records from stored procedure(oracle) by invoking it through perl script. SP takes 1 input and ouput parameter is cursor
--------Here is the perl script_-----...
0
votes
1answer
29 views
Migrate database to Azure
I have a 600GB database that I must transfer from an on-premises machine to an on Azure VM machine (IaaS)
I would like to use the dbatools copy-database tool for this
for this I will have to know what ...
0
votes
2answers
63 views
SQL Server 2016 -> 2019 AlwaysOn Rolling Upgrade Migration
I have a migration concept with an AlwaysOn configuration from SQL Server 2016 (on windows server 2016) to SQL Server 2019 (on Windows Server 2019) which are in different sub-networks.
So with ...
0
votes
0answers
13 views
Is it possible to convert Postgresql server to master-master cluster on the fly?
There is an Postgresql server that should never be stopped.
I want to upgrade it.
Is it possible to:
configure new empty server,
convert existing server to the first node of master-master cluster (...
1
vote
2answers
59 views
Provisioning SQL Server 2019
I'm provisioning a SQL Server 2019 build and have been allocated a virtual server running Windows Server 2016. It has 4 virtual processors and I have 410Gb of drive space to work with.
My build has to ...
1
vote
0answers
48 views
Migration from Postgres to MySQL using MySQL Workbench (Error in Reverse Engineering catalog. A task has failed while execution)
When I am trying to migrate database from Postgres to Mysql, I am facing an error in the Reverse engineering source step in which the log shows
Starting...
Connect to source DBMS...
- Connecting...
...
-2
votes
1answer
56 views
Shrink of a big databases ? SQL Server [duplicate]
In this moment I have a very big database (almost 4 TB) and wanna shrink data files for a future migration
Unused space : almost 3000 GB
I have in mind shrink data files day per day with low amount of ...
1
vote
1answer
14 views
Using IF … PREPARE … EXECUTE … DEALLOC to create a temporary block?
What are the comparative benefits of these two statements,
SET @stmt = (SELECT IF(
(
SELECT COUNT(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = DATABASE() AND
...
0
votes
0answers
16 views
LIQUIBASE Locking our DB with duplicate IDs post migration - handling changesets
I apologize in advance if this is the wrong thread category but we recently migrated a DB and our liquibase configuration is seemingly not recognizing that there is a new path so Liquibase seems to be ...
0
votes
1answer
22 views
Upgrade Advisor Or DMA (Database Migration Assistant)
We are migrating from SSRS 2012 to SSRS 2017.
MS documentation suggests - "Even though you are migrating rather than upgrading the installation, consider running Upgrade Advisor on your existing ...
1
vote
1answer
32 views
Google Managed PGSQL DB migration to DigitalOcean Managed PGSQL DB
We are migrating from Google-Cloud PGSQL managed database to a managed PGSQL server on Digital ocean.
The dilemma we are facing is that both Google and Digital ocean are managed so we have no access ...
0
votes
0answers
26 views
Migrating sequences from postgres to EDB database
Scenario :
We are migrating data from a postgres DB to new EDB database .
We have migrated the sequence and all table data also .
Both DB is installed on a remote unix server and on diffrent machines....
-1
votes
1answer
19 views
Migrate data from an older version of mongodb
How can I backup and restore a large mongodb database (500GB) from a server running an older version (v2.6) than the target one (v3.6)?. The downtime is critical.
We've tried by making a straight copy ...
0
votes
2answers
31 views
Do non-PostgreSQL database softwares use roughly the same “structure” for communicating with them?
Basically, I have developed a PostgreSQL-based application which "in theory" could have its database software swapped out, but probably would cause a million headaches if I actually ...
0
votes
1answer
28 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
26 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
41 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
26 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
43 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
24 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
96 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
27 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
40 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 ...
0
votes
2answers
379 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
217 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
36 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
51 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
41 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
19 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
51 views
How to export large table data into different files in oracle?
I'm having a table which contains 10 Lakh lines and need to export into different file which contails 1 Lakh lines each .
sample_01.sql ,sample_02.sql and so on
How can we take export like this in ...
0
votes
0answers
91 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
25 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
77 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
0answers
51 views
Moving SyBase to AWS Database as a Service
We have several existing Sybase ASE and IQ v16 installation on-premise that are not accessible via the internet. These databases have stored procedures.
What's the best way to migrate these databases ...
0
votes
1answer
17 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
63 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 ...
0
votes
0answers
104 views
Microsoft Data Migration Assistant Failing
I am using the Microsoft DMA to migrate data from a Microsoft SQL Server 2012 instance into a Microsoft SQL Server 2017 instance.
I get all the way to the final step of selecting logins, start the ...
0
votes
0answers
21 views
Splitting a large table using CTE with a constraint
I have a large table called "order". That table has a field record_type. I want to split the table up into different orders by record type. All of the tables for the different types of orders have the ...
1
vote
0answers
22 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
46 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
17 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
58 views
Database migration assistant for Unicode by Oracle is not responding after using schedule column option
I have posted this issue on Oracle Community but I would like to post it on here so that I will have more opinions on this issue.
Issue:
I am facing an issue with DMU 19.1 which is the DMU ...
0
votes
0answers
103 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
95 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
82 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 ...
