Questions tagged [migration]
the process of moving databases or data from one place to another
763
questions
3
votes
0answers
34 views
What's the quickest way of porting thousands of PostrgreSQL queries to HSQLDB?
Lately we have been tasked with porting some existing DB infrastructure from PostgreSQL to HSQLDB. Yes, I know what you're thinking (why on Earth would anybody do such a thing?). But unfortunately for ...
1
vote
2answers
67 views
Converting SQL Server queries to PostgreSQL
I am trying to convert the following SQL Server T-SQL block to a PostgreSQL compatible one using, preferably CTE or a function. The issue with converting is I am not able to figure out how I return ...
0
votes
1answer
35 views
How do I import the _id index from a MongoDB collection as a hash index for a PostgreSQL table (from a CSV export from MongoDB)?
I want to be able to keep track of the _id index values that get the MongoDB collection uses when I export the MongoDB collection (via CSV) and import the data into a PostgreSQL DB table (basically ...
0
votes
1answer
20 views
MySQL: carriage-return in query breaks my import
I use simple echo "select * from tab" | mysql --batch --quick --skip-column-names .... > /tmp/file from mysql to get data.
Then, import to postgres using \copy tab FROM /tmp/file ...
0
votes
0answers
15 views
Wrong column data types when using dtswizard
I need to copy a database from a MS SQL Server 2017 to a MS SQL Server 2012.
I am not sure what's the best way to go, but I'm currently trying to use dtswizard to do the job.
Everything seems to be ...
0
votes
3answers
54 views
disable log during migration?
We have an older SQL Server Database that is about 1TB.
We now have a new database that has a slightly different schema. We are going to migrate the 1TB of data to the new db using the export tool in ...
0
votes
2answers
34 views
How do I migrate Postgres database using an intermediate file
I have a PostgreSQL v9.5.23 database on an Ubuntu 16.04 server that I want to migrate to a new Postgres 12.4 installation on an Ubuntu 20.4 server.
The network pipe recommended by the Postgres docs ...
1
vote
1answer
57 views
Assign Failover Cluster and High Availability Always On from Old to New Domain
What are best practices steps when the Windows Server 2016 machine hosting SQL Server and failover cluster (2 node and shared folder witness) is joined to another domain?
What steps definitely/might ...
0
votes
1answer
27 views
How to export Sql Server DB schema as an ALTER statements?
I have a 2 months old DB & I want to fetch new Schema for that DB without deleting the data in it using ALTER statements. Is it possible?
Currently I am taking a backup of table data of Old DB in ...
0
votes
1answer
65 views
When I set Datestyle to 'SQL, YMD' all queries still return as 'SQL, MDY'
I am working on a database migration from Oracle 12c to Postgresql 12.
We must keep the same date format as the program interacting with this database is written in COBOL and should not be changed.
...
0
votes
1answer
57 views
migrating to a bigger server - how to copy over differences
We have a very large database, one table (logs) contains the majority of the data (around 13 billion rows) total database size is approx 6.5TB and I have 900gb of space remaining before server is full....
1
vote
0answers
19 views
Choose Right Azure SQL [closed]
I'm new to Azure and now trying to migrate the On-premises SQL databases on azure.
I have chosen VM SQL for migration because I just want to lift and shift architecture and need to restore backup file ...
0
votes
3answers
36 views
Is there performance loss in out of sequence inserted rows (MySQL InnoDB)
I am trying to migrate from a MySQL AWS RDS instance with a huge SSD and too much excess space down to a small one, and data migration is the only method. There are four tables in the range of 330GB-...
2
votes
2answers
237 views
Copy data to another database
I would like to know how to copy all the data from a database X1 into a database X2 on SQL Server please.
1
vote
0answers
14 views
Transaction log file - Migration SSMA
I'm attempting to migrate a relatively large Oracle DB to MSSQL using SSMA however due to disk space constraints, I had to stop the full migration last night when it was 50% of the way through.
Upon ...
0
votes
1answer
22 views
PostgreSQL know table hierarchy
Is there a way to know the parent - child relations (in terms of foreign keys) of all the tables in postgresql database? We are planning a full database migration using AWS DMS, we need specify in ...
1
vote
1answer
39 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
42 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
78 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
34 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
189 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
15 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
69 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
109 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 ...
0
votes
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
18 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
52 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
40 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
32 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
23 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
32 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
64 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
144 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
27 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
69 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
25 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
105 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
46 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
78 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
3answers
1k 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
254 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
37 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
107 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
109 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
129 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
153 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 ...
