Questions tagged [migration]

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

162 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
1answer
159 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 ...
3
votes
1answer
355 views

How to migrate Unicode UTF-8 CLOB data from Oracle to SQL Server 2017 UTF-?

I am currently assisting in a migration effort of this application from Oracle 12c to SQL Server 2017. Initially I just performed table inserts using openquery to Oracle. I discovered that the tables ...
3
votes
0answers
186 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
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 ...
3
votes
1answer
217 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 ...
3
votes
0answers
573 views

Move SQL Server cluster from one location to other

I am looking for ideas on how to move SQL Server 2012(standard) two node cluster installed on Windows server 2012 standard to other location which is far away from current location. The two locations ...
3
votes
0answers
522 views

Options to migrate large database from Sybase ASE to SQL Server with minimum downtime

The problem: Our server database contains 1TB of data. It runs on a Sybase ASE 15.7 server and shall be migrated to SQL Server 2014. The servers will be located in the same data center during ...
3
votes
1answer
128 views

Converting a graph database schema to a relational database schema

I currently am using a graph database and am considering moving off of it to a relational database management system like PostgreSQL. My concern is that I have lots of relationships between ...
3
votes
0answers
491 views

Stubborn autovacuum process slow things dows

We are facing a strange problem since yesterday. In a database of ours there is a partitioned table containing historical data. That is, every week's data goes to a different partition and stays ...
3
votes
0answers
1k views

How do I safely import MySQL data in a directory to a running MariaDB server?

We're integrating another office into ours. That includes some of their data. I have a new installed MariaDB 5.5 server. The data dir = /home/data/MariaDB. I've done a new/fresh install into that ...
2
votes
2answers
125 views

How to Exclude Foreign Keys during Publish action in sqlpackage

I am trying to publish a .dacpac extract to a target database, I want to exclude just the foreign key constraints in all the tables. After going through the ExcludeObjectTypes options I do not find a ...
2
votes
0answers
306 views

Should Postgres USER/ROLE management be done with Flyway?

I've recently inherited a company database. The current practice is to put everything schema-related in a Flyway migration and obviously we never change the schema outside of Flyway. This includes ...
2
votes
0answers
744 views

postgres migration sequence issue

I am trying to copy my database from one server to another (postgres10). I have tried using the interface of pgadmin4 to take a backup, create empty database on the new server and use the interface ...
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 ...
2
votes
1answer
89 views

How to do a SQL Server 2016 continuous upgrade

I watched this channel9 video, and it mentioned you could now do a continuous upgrade to MS SQL Server. This allows you have a side by side install and it will keep the databases in sync until you ...
2
votes
0answers
62 views

Migrating a Replicated Database from one SQLServer 2012 instance to another

We are working on a migration plan from old hardware to new hardware, these are SQL 2012 servers. A couple of the databases heavily use transaction replication so I'm trying to avoid recreating and re-...
2
votes
1answer
491 views

Query from Postgres to SQL Server

I have this query in PostgreSQL and I am not familiar with PostgreSQL. I need to convert it to SQL Server. SELECT (applicant_majors.*)::applicant_majors FROM applicant_majors WHERE applicant_majors....
2
votes
0answers
344 views

Migrating schema from Entity-Attribute-Value (EAV) model to proper tables

I have an Entity-Attribute-Value (EAV) database in Oracle 11. For many, many reasons, I would like to model this using actual tables. Changing all the client code at once is not possible. Existing ...
2
votes
0answers
652 views

SQL SERVER 2005 slow Performance on Windows Server 2008

Recently I have upgraded my server to new one. But because of compatibility issues with my old Windows Server 2003 R2 32 bit, I have also upgraded it to Windows Server 2008 R2 64 bit. (I have ...
2
votes
0answers
1k views

How do I convert unicode data from UTF-16LE to UTF-8 when migrating from SQL Server to MySQL?

Objective: Ensure existing Unicode (UTF-16LE) data is displayed the when moved to MySQL (UTF-8). Background: I'm migrating 1TB from SQL Server to MySQL. The current Collation in SS is "...
2
votes
0answers
2k views

Migrating from Oracle to MySQL using WorkBench Migration Tool

I am currently migrating from Oracle to MySQL and I am going to use the migration tool in workbench to help me with the procedure. I have entered my source connection details as follows: Database ...
2
votes
0answers
1k views

How much disk space needed for 100GB of DBs?

Hard to explain in the title, but I'm planning a migration from SQL Server 2000 databases to SQL Server 2008 R2. The databases are under 100GB total space, but this is only with the Simple recovery ...
1
vote
0answers
172 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
0answers
30 views

What All Is Factored Into A MySQL Checksum? (Why Could They Be Different?)

I'm currently going through the excruciating task of moving MySQL databases from one shared web hosting environment to another. This has been a multi-month battle (and I'm learning a lot). After ...
1
vote
1answer
44 views

SQL Server - Migration script testing - Refresh table definition manually without dropping it

How can a table definition be manually refreshed without also manually crafting a bunch of ALTER TABLE statements, or dropping and recreating the table? This is normally handled by the publish ...
1
vote
0answers
26 views

Centralizing Databases

I have a very challenging scenario at hand and would like to hear suggestions on the solution I am considering implementing. I have several databases that have similar (non-identical) structures and ...
1
vote
0answers
26 views

What are the most effective schema migration strategies?

I recently came across a migration system that relies on incremental numbers, so the scripts are executed in ascending order. A folder containing a few scripts might look like: Script1.sql ... ...
1
vote
0answers
256 views

Received an unsupported type from Postgres. (14) (SQLGetData)

I have database in PostgreSQL. It is simplest possible database with schema presented here: http://www.postgresqltutorial.com/postgresql-create-table/ I want to migrate it to MySQL. I trying to ...
1
vote
1answer
54 views

How to Convert List of values datatype in oracle to equivalent or valid datatype in sql server?

I want to recreate the table below in SQL server I have tried using SSIS but it does not know how to handle the lOV Data type how can I recreate this table in SQL server and migrate the data to it. ...
1
vote
0answers
45 views

Code First Migrations with an existing database - How do I make sure migration won't affect the existing data?

I am referring https://docs.microsoft.com/en-us/ef/ef6/modeling/code-first/migrations/existing-database I am using Entity frame work Code First Migrations for an existing database. I get the below ...
1
vote
0answers
57 views

How to migrate InnoDB tables with 10s of partitions from the data directory onto another drive on the same server

I am trying to move some of the older partitions from larger tables located at the main data directory to another drive/mount point on the same server. I want all the partitions/tables to be ...
1
vote
0answers
222 views

SQL Server with peer-to-peer replication migration from on-prem to AWS EC2 instances

I need to move three on-prem servers with peer-to-peer replication to AWS. SQL Server version is 2012. The AWS SQL Server will be on EC2 instances as the SQL Server RDS doesn't support replication yet....
1
vote
0answers
138 views

Migrate Firebird to Oracle

I have about more than 250 Firebird local databases and several server databases. The way they are connected is such: A block of almost 50 local databases, 1 on each PC, connect to 1 server database. ...
1
vote
0answers
91 views

KPI's don't transfer on RS.exe SSRS Server Migration

I'm attempting to do a server migration with SSRS 2016 to Power BI (March 2018 release). I have been successful at getting my Data Sources, Data Sets, Folders, Reports, settings and subscriptions to ...
1
vote
1answer
43 views

Not Null Fields and Unmatched Number of Columns

I am in charge of a task of migrating data from MySQL to PostgreSQL. I have already migrated the MySQL database to PostgreSQL with the help of pgloader. My problem is I need to insert the data from ...
1
vote
3answers
4k 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 ...
1
vote
0answers
38 views

Inter-environment data migration

At my company we have a need to migrate a portion of our provisional data between versions of our database, housed on different servers (upserts for the most part). For release management purposes, ...
1
vote
0answers
478 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 → ...
1
vote
0answers
234 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
62 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
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: ...
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
533 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
1answer
343 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 ...
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 (...
1
vote
0answers
49 views

Migration of SQL Server Database

We have a situation here our application is working on SQL server on a cluster environment. Now we wish to migrate the database to a standalone environment, we have approx 2850 databases 1.6 TB in ...
1
vote
0answers
35 views

Options for transferring/transforming from one database to another?

We have a hosted instance of intersystems-cache. There is an aggregate log that is near 600 million rows and is rather abstract and complicated. I am planning to parse this log and store more ...
1
vote
0answers
228 views

MongoDB: removeShard when dbsToMove is an empty array

Background: Two empty shards with no explicit sharding scheme - shard0000 and shard0001. mongorestore a single database, all of which defaults to shard0000 Add a shard key to one collection and let ...
1
vote
0answers
987 views

fast way to migrate existing mongo cluster data to new one

Currently, I have a existing mongo3.0 cluster(using WiredTiger storage engine and directoryPerDB is true) as below settings: 3 x shards(rs01, rs02, rs03) 2 x mongos 3 x mongo cfg All the databases/...
1
vote
0answers
812 views

How to avoid downtime during postgresql upgrade

Im having a production PostgreSQL server 9.2, it has a few databases around 150GB. I want to upgrade this to 9.6, so I decided to upgrade this on QA server. I have installed PostgreSQL 9.6. Then ...