Questions tagged [migration]

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

Filter by
Sorted by
Tagged with
1
vote
0answers
449 views

Bidirectional realtime synchronization between Oracle and SQL Server tables

I have to sync data between Oracle and SQL Server database tables. And I'm actually looking for some advice on which technologies to use or how to address this. At the moment I'm doing the Oracle → ...
4
votes
0answers
92 views

Moving a very large (40 TB) DB from a 2008 server to a 2016 server [duplicate]

The Situation: Our 2008 MSSQL server is old and rapidly running out of drive space. We have a new 2016 server ready, we just need to move a 40 TB database from the old server to the new one. The DB, ...
1
vote
2answers
45 views

Migrate data from multiple disparate databases into 1

I have a SQL Server instance with 5 different databases. For a few reasons, we would like to combine these into just 1 database, separating out each database into it's own schema. I've built the ...
0
votes
2answers
86 views

Move data from MySQL 5.0 to other server with MySQL 5.7

We are switching servers from a Windows Server 2003 (32-bit) with a MySQL 5.0.51b to a Windows Server 2016 (64-bit) on which I will install the latest MySQL version (5.7). The database contains just ...
1
vote
1answer
372 views

Copying large amounts of data to another target tables

I'm migrating large amounts of data +40m of rows to a new version of the tables, my question would be more like, what could be the best way to improve the performance in terms of logging and execution ...
2
votes
0answers
59 views

Writing data to new database - collation question [duplicate]

We will be changing the collation of our databases in a few months. I am setting up an environment, to test the new collation with my application. I have created a database with our new collation and ...
1
vote
0answers
220 views

Converting and/or enforcing an Ascii Character Set in Informix database from 819 or ISO Latin 1

Overview: In Informix is it possible to enforce ASCII for a database or instance. Details: I am trying to enforce ASCII in an instance of informix for a while. This is to help have a smooth ...
1
vote
2answers
52 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 ...
1
vote
1answer
73 views

How to migrate MySQL database to SQL Server on a separate machine?

I have a MySQL datadump file from the database to be moved. From the suggestions I've read so far, most migration tools only work with databases that are hosted on the same server. What steps can I ...
0
votes
2answers
64 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
2answers
2k views

Live migrate a database from one instance to another with zero/minimal downtime

There are 2 MySQL instances: MA and MB. They are completely separate from each other (no replication between them). Each instance contains multiple databases: MA serves db1, db2 MB serves db3, db4 I ...
1
vote
1answer
229 views

SQL Server Migrate Database - Set Compatibility Level

We are planning on migrating from SQL Server 2008R2 to SQL Server 2014 (or 2016). One 3rd party application is not supported after version 2008R2. Is it OK to migrate this application database to ...
1
vote
2answers
440 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 ...
0
votes
2answers
904 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....
1
vote
2answers
446 views

How to create shared folder between my on-premise Windows Server and Azure VM Server?

I'm trying to migrate my on-premise SQL Server to Azure VM using 'Microsoft Data Migration Assistant'. But it is asking for shared folder to be accessed by both source and target. How to achieve this?
1
vote
1answer
3k views

Postgres pg_restore error: invalid byte sequence for encoding “UTF8”: 0xe05c62

Lucky me, I get to play DBA today! I am migrating a Postgres 8.4 DB from one server to another (both RHEL6). I backed up the schema from the old server and restored it to the new server. Then I ...
2
votes
0answers
23 views

During a SQL migration/upgrade, is there an intuitive way to mirror the exact file paths of the old install without manually combing through?

I am performing a migration upgrading from 2008 to 2016 and the requirements are that the file paths need to stay exactly the same as they were, with same drive letters, paths, and folder names due to ...
0
votes
1answer
25 views

In-place up-gradation of SQL server on Azure with pre-image installed.

We have migrated our SQL server 2012 infrastructure from on-premise to Azure cloud recently where in all the production VM's are build with pre-images of SQL 2012 enterprise edition. So,here is the ...
1
vote
1answer
159 views

Migrating from MySQL RDS to Aurora RDS with CNAME record

I understand migrating to Aurora is simply a matter of creating read replica from MySQL source and then promoting when caught up and stopping writes on MySQL RDS previous master. I use Route 53 DNS ...
0
votes
1answer
81 views

SQL sevrer DB migration plan [closed]

We are planning on migrating our existing SQL 2012 servers from current windows servers to new windows servers. Only difference is we are migrating this current instance which is standalone to ...
1
vote
1answer
474 views

Moving a PostgreSQL database to a different AWS RDS instance

I have an AWS RDS instance with multiple PostgreSQL databases in there including an application database and a monitoring database. The problem is that the monitoring database is consuming lots of ...
2
votes
1answer
2k views

After mysql_upgrade to 5.7, optimizer not using index on large IN clause

I have a similar issue to some other people have described. In MySQL 5.6.23-72.1-log, a query with a large number of values in an IN clause uses an index, and takes 10 minutes to run; In 5.7.19-17 ...
1
vote
3answers
656 views

Migration of Always On Availability Group from old to new SAN within same data center

What are the steps required to move AAGs (version=SQL 2012 and OS=Windows 2012 R2 O) to new SAN within same data center? It is a virtualized environment. Instead of building new servers - can the ...
0
votes
2answers
397 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 ...
0
votes
1answer
2k views

Have to change schema in production

I have a mean-stack website www.myweb.io. I need to upgrade the code and the database. In the previous database, I have a schema: var UserSchema = new mongoose.Schema({ username: {type: String, ...
1
vote
2answers
502 views

How to use pgloader to transfer sqlite to postgres with table name in Uppercase

I can use pgloader to transfer my sqlite database to postgres as described in this quickstart page. But the result is all my tables' names are lowercases. e.g. TestName -> testname Is there any way ...
1
vote
0answers
60 views

Data transformation

so, I'm facing this issue in storing my file in my database. I have an excel file that I need to load in database. The file looks like this: The issue is that I need to store all this in columns: ...
0
votes
1answer
672 views

How to migrate SQL Server credentials from 2005 to 2008 R2

I want to migrate SQL Server credentials used for proxy accounts from SQL Server 2005 to 2008 R2. Is there a way to decrypt credential passwords or a script to copy credential with the same password ...
1
vote
0answers
100 views

Root Privileges Moving From MySQL to Mariadb

I am experimenting with migrating my database from an older version of MySQL to a Mariadb Docker container. I am simply dumping the entire database and restoring it within Mariadb. The only issue I'...
1
vote
0answers
486 views

Oracle Character Set/Database 11 to 12 Migration Options

Topic/Questions: Oracle Character Set/Database 11 to 12 Migration Options Task: Migrating production Oracle EE 11.2.0.4 single instance database with NLS_CHARACTERSET WE8ISO8859P1 to existing remote ...
1
vote
2answers
489 views

node-db-migrate, unable to execute multiple queries

I am using node-db-migrate in my project to handle the database migrations. It works fine when I am using only one statement but if multiple statements are used, sometimes it runs while it fails most ...
1
vote
1answer
736 views

Data scrambling for the development data

I have a lot of sensitive data in production like SSN, name, email, and phone number. I have function to scramble this data using a random value hashmap technique. But in the case of SSN (social ...
0
votes
1answer
83 views

How to migrate subset of data from production to develop by scrambling sensitive data?

I like to create a tool which scrambles the production sensitive data and added it into another dev DB. I've built a couple of scripts that make random social security numbers, shift birth dates, ...
0
votes
2answers
843 views

Moving Databases between Instances of different Versions of SQL Server

I found out SQL Server Developer Edition is now free. I would like to use my older databases from SQL Server Express 2016 to a new instance of SQL Server Developer 2017. I want all the data objects:...
2
votes
1answer
395 views

Cannot re-attach SqlExpress database to the same database server after detaching?

This seems a bit strange. I migrated a database in a test environment from one server (SqlExpress) to another (full SqlServer). I did that by detaching the database from the first server, copying over ...
4
votes
2answers
358 views

TEXT data migrate from Sybase to SQL Server

I'm working on migrating Sybase ASE 15.7 SP134 database to SQL Server 2008R2, using SSMA for Sybase 2014. I'm facing an issue where a table in SybaseDB has 2 columns with the data type TEXT. The SQL ...
5
votes
2answers
167 views

How to definitively clear away database before restoring from new version of backup file

We are a team of mathematicians (i.e., no DBA experience). We are migrating from an old server box (SQL Server 2012) to a new server box (SQL Server 2017). For each database on the old server, we ...
7
votes
4answers
2k views

How do I prevent changes to my database?

My steps: run the final pg_dumpall on a server prod-server-old Shut down prod-server-old for ever. copy the output to a different server (prod-server-new) Restore the db there. All traffic goes to ...
2
votes
2answers
628 views

Availability Group of SQL Servers 2012, 2012 and 2016 possible?

We have two SQL servers combined into Availability Group in primary data center (dc1): dc1 server 1: SQL Server 2012 SP3 on Windows 2016 dc1 server 2: SQL Server 2012 SP3 on Windows 2012 R2 We are ...
2
votes
1answer
102 views

Can I have cross database or cross server references through a relative path?

I have two databases, db1 and db2, running on two different servers, server1 and server2, and db2 has some stored procedures that will modify the table columns on db1. In these stored procs, we use ...
0
votes
1answer
121 views

SQL Server 2016 migration to Azure

Trying to migrate SQL Server to Azure, MS Data Migration tool indicates need to delete SSIS. Using advice from Stackflow and others, go into programs and features and SSIS is not listed as a component....
6
votes
2answers
212 views

Issues after schemas migration from mysql 4 to mysql 5.6

Recently I've migrated some schemas from mysql 4 instance into an instance of mysql 5.6 by mysqldump and import operations. After some syntax adjustments, I could import the dump file successfully. ...
1
vote
1answer
311 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 ...
2
votes
1answer
443 views

Mysqldump subset of database with relational data using a master table

I have found a lot of articles describing the concept of exporting and importing relational data, but I have not been able to find any article describing this more generally for a MySQL database, ...
1
vote
2answers
392 views

How to translate SQL Server stored procedure into Oracle stored procedure?

This is my SQL Server stored procedure which is below: CREATE PROCEDURE flight_details AS BEGIN SELECT Airline.Airline_No, Airline_Name, Airplane.Airplane_No, Airplane_Name, Flight.Flight_No, ...
2
votes
1answer
95 views

Do Constraints move from one database to another?

We have a development database, a test database, and production. The only way for data to enter one of these three systems is via an SSIS package, which means that for the last month of development, ...
3
votes
0answers
170 views

Corrupted tables in postgresql: invalid relnatts, attrelid and typrelid

When trying to upgrade my databases from Postgresql 9.5.4 to 9.6.3, two tables are corrupted. $ /usr/local/Cellar/postgresql/9.5.4_1/bin/pg_catcheck -h localhost -p 5434 db_concepts_2 notice: ...
3
votes
2answers
3k 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 ...
1
vote
0answers
1k views

Migration from postgres 9.4 to postgres 9.6

I did the migration from PostgreSQL 9.4 to version 9.6, but now the stream replication is not working, it stopped replicating. Script followed: installation of postgres 9.6 on the three servers (...
0
votes
1answer
543 views

Loading Oracle ctl export file into postgresql

I have a number of tables exported from an oracle database in the form of Ctl files with that data included within the file. Im looking for a way to import these into postgresql but the the ...