Questions tagged [migration]

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

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

mysql hardware refresh + version upgrade

currently I am running MySQL 5.0.80 on windows server 2003 (x64), 64gb memory, I have a master and 2 slaves. It's a large 400 gb Database. I am setting up all new hardware (SAN + dedicated MySQL ...
1
vote
1answer
140 views

Find efficient way of migration 2TB GBK table in SybaseIQ to UTF-8 files

My project need to migrate more than 2TB raw data from SybaseIQ to another Database. SybaseIQ using GBK, the target Database using UTF-8, the target database can only load from UTF-8 files. We use ...
0
votes
1answer
15 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 ...
1
vote
4answers
7k views

How to restore a pg_dumpall dump without CREATE INDEX?

I am attempting to migrate from Postgres 9.6 to 10.3 and during the restore each index is recreated one by one - this is a problem. So far I thought pg_dumpall is a good option. pg_dumpall -U ...
4
votes
2answers
5k views

Linked Server alternative in Sql Azure database

We are migrating database from Rackspace to Azure. Our databases were deployed on Virtual Machines in rackspace. In our queries we are using Linked server to other databases. Basically cross database ...
0
votes
1answer
569 views

Shared Location Options in MS SQL Server Data Migration Assistant

For studying purposes I want to upgrade AdventureWorks sample database from MS SQL Server 2017 Express edition to Developer. I am using DMA for that, and can't understand the meaning of Shared ...
2
votes
1answer
532 views

Cannot re-attach SQL Server Express database to the same server after detaching?

I migrated a database in a test environment from one server running SQL Server Express 2008 R2 to another running the full version of SQL Server 2012. I did that by detaching the database from the ...
1
vote
1answer
57 views

How do I abstract a WHERE clause condition?

I'm wondering how a condition in a commonly used WHERE clause can be abstracted away so that it can be safely changed. Say I have data like ColA | ColB | ColC ================== 1 | 2 | ABC ...
0
votes
0answers
14 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
47 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
1answer
570 views

Problems during migration from SQL Server to MySQL via MySQL Workbench

We've found most of the options we needed to include the necessary CHARSET. Here is what we've included in the MySQL my.cnf: [client] default-character-set = utf8mb4 [mysql] default-character-set ...
0
votes
1answer
80 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
2answers
267 views

Oracle Database Migration using Oracle SQL Developer

I've 2 Oracle database on different machines [I connect to them via oracle SQL Developer Now I am planning to have machine 3 which will consolidate both Oracle instances on one new node Question is ...
2
votes
1answer
599 views

Partial copy of huge database

I have started working in a project which has a big database, around 300GB. For security reasons I can not access database from my local web app. So I need to copy last 100,000 from each table. To ...
1
vote
1answer
40 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
2answers
27 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 ...
0
votes
2answers
73 views

Can AWS Data Migration Service be used to integrate non AWS SQL server with Redshift?

I have a SQL Server 2012 hosted on a standalone machine. I want to migrate it to my AWS Redshift (already existing data warehouse). My question is wether it is possible via AWS Data migration service ...
0
votes
1answer
26 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 ...
1
vote
1answer
416 views

mysql to mongodb migration

I have table, with around 125 million records in MySql. I want to move it to mongodb. What would be the best approach to migrate this huge table to mongodb? I was thinking to fetch one by one row ...
0
votes
1answer
27 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
49 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....
0
votes
2answers
111 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
1answer
1k views

how to replace dbms_reputil.from_remote in oracle 12.2.0.1 since All objects removed except REPLICATION_IS_ON, _OFF and _ON

how to replace dbms_reputil.from_remote in oracle 12.2.0.1 since All objects removed except REPLICATION_IS_ON, _OFF and _ON
0
votes
1answer
3k views

Error Calling Python module function DbMySQLFE.connect

Migrating a database from SqlServer to Mysql using "MySQL WorkBench 6.3 CE" using ODBC data source as default methode to use to connect to the RDBMS. -> Source Selection Test connection is Successful ...
0
votes
3answers
33 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-...
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 ...
2
votes
2answers
193 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.
3
votes
1answer
225 views

Upgrade and migrate SQL Server 2014 AlwaysOn AGs to SQL Server 2016, using the existing WSFC name

Here are the components: WSFC Name: SQLPROD1 Existing Nodes in this "cluster": SQL2014OnSite and SQL2014OffSite New Nodes to be added (?) to SQLPROD1: SQL2016OnSite and SQL2016OffSite All 4 servers ...
1
vote
0answers
12 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 ...
3
votes
1answer
380 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
287 views

mysql database migration of schemas with updated data and structures

I am a newbie with MySQL database dumps and am currently trying to work with data migration between a source schema and a target schema. Assuming the source schema is defined by (...
0
votes
1answer
221 views

Why could pgloader fail with 'undocumented reason' while migrating large MySQL database to PostgreSQL?

The database I would like to import is approximately 55GB in binary format, about 36 GB exported by mysqldump. But as we know even the postgres compatible mysqldump is not 100% compatible, so I'm ...
0
votes
1answer
21 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 ...
0
votes
2answers
473 views

Side By Side Upgrade and Migration from 2008 to 2016

Side By Side Upgrade and Migration from 2008 to 2016 Old Server Name Test1 New Server Name Test1 Default Instance Test 1 My question is when the new server be named as the old one 'Test1" and it ...
1
vote
1answer
36 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
1answer
303 views

SSRS 2008 to 2014 Migration Excel Export error

We are working on migrating our SSRS from SQL Server 2008 to SQL Server 2014. After brining the reports over I have a set of reports that will execute just fine but when I try to perform a standard ...
0
votes
1answer
134 views

Issues regarding phpMyAdmin - character set

I'm trying to migrate a Wordpress site from one server to another. Everything is going fine apart from the database migration. I have my database 'A', and using phpMyAdmin I am attempting to export ...
0
votes
1answer
432 views

Migrating Oracle Views to SQL Server

In the process of retiring an Oracle 11g host for an HRIS database, I've been asked to migrate as many assets as possible to a SQL Server 2016 instance for read-only archival. The volume of table ...
0
votes
1answer
221 views

MySQL DB Migration from on-premises to AWS through replication

I am having a production MySQL server with set of 20 databases in on-premises server. Now I require to migrate few databases from production server to AWS RDS without disturbing other databases in one-...
0
votes
2answers
1k views

Cloning the database to another server with raw data files

I'm trying to clone the database of server 1 to server 2 with raw data files. I'm using Linux 7 and Oracle 11g R2. I have the instance running with same SID in Server 2 but file structure is different....
0
votes
0answers
30 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
2answers
4k views

MySQL data transfer to different schema

We have two servers: one for the developer (me) and one for the tester. While working on the app, I sometimes make little changes in tables's schemas. (Like a new field, or a field type) I'm trying ...
3
votes
2answers
1k views

Migrate replication from SQL Server 2008 R2 to SQL Server 2016 - Old to new hardware

I will be working on a project shortly that would involve moving the replicated databases off of old to the new SQL Server instance. I haven't done this in the past so I don't have much knowledge ...
2
votes
1answer
428 views

Missing Oracle Schema in SSMA Object Explorer

We are currently working on a project to move all of our disparate DBs (MySQL, Oracle, older versions of MS SQL) to SQL Server 2014. So far, pretty much everything has gone smoothly, however, there is ...
0
votes
1answer
31 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
32 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
870 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 ...
1
vote
2answers
88 views

High Level SAN Migration Strategy. Is this a good idea?

In the company I work for we are planning decommissioning an old SAN serving our production servers Which are 2 Nodes running 2 SQL Server instances using Clustering (one is the backup for one ...
0
votes
1answer
176 views

Migration Wizard Offline SQL Server to Oracle, before Move Data, directory Data is empty

I'm migrating data that be in SQL Server to Oracle I'm doing it Offline, I generated .ocp, I ran the OMWB_OFFLINE_CAPTURE.bat, I passed the parameters and generated two directories, one called Master ...
4
votes
3answers
8k views

MySQL Workbench copies Schema, but not data, from SQL Server 2008

I need to copy/migrate a database from MSSQL (SQL Server 2008) into MySQL. I am using the MySQL Workbench kit, and work through the process of the Migration. Each respective DB user has full access, ...

1
2 3 4 5
16