Questions tagged [migration]
the process of moving databases or data from one place to another
744
questions
0
votes
0answers
17 views
migrating ssis packages from 2012 to 2017 server
have a number of SSIS packages in a number of folders on MSDB SSIS on SQL Server 2012. We are migrating to a new server host with SQL Server 2017.
How can I copy/migrate these SSIS packages to the ...
0
votes
0answers
13 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
18 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
24 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
22 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
22 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 ...
-1
votes
0answers
7 views
How to import data from AWS data lake to PostgreSQL DB? [closed]
We got already existing product which pushed data to AWS data lake and currently we are manually using that that data for some external processing. Now we are creating a product with PostgreSQL DB. We ...
0
votes
0answers
20 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
73 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
22 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
30 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
1answer
42 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
88 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
31 views
Migrate MongoDB 2.4.14 to MongoDB 3.6
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
25 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
17 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
18 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
42 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
42 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
23 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
54 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
29 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
16 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
33 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
59 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
13 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
43 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
43 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
51 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
71 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
75 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
53 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
81 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
35 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
33 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
56 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\...
35
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
29 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
530 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
93 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
103 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
50 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
73 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
80 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
26 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
85 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 ...
