Questions tagged [migration]

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

152 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
1answer
179 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
158 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
909 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
208 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
539 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
489 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
0answers
490 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
995 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
57 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
241 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
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
82 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
61 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
421 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
1answer
110 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 ...
2
votes
0answers
650 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
1answer
43 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
25 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
184 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
44 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
26 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
40 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
200 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
125 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
82 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
42 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
0answers
628 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 ...
1
vote
0answers
34 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
430 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
210 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
50 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
469 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
300 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
48 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
33 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
212 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
860 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
811 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 ...
1
vote
0answers
50 views

Better mode in export datapump

I'm a complete newbie in oracle databases. I'm just curious on what mode is better when you want to migrate your database to another host by using data pumping. Lately, I'm having a problem on import ...
1
vote
0answers
22 views

Raspberry as data aggregator node, transfer to database if Raspberry is online

I have never used SQL and currently I do read and watch various turorials and the manual of PostgreSQL. I would appreciate if someone could give me a brief overview how an experienced user would set ...
1
vote
0answers
83 views

Mysql to MS SQL Migration and synchronization

Database migration from MySQL to MS SQL using SSMA tool is very nifty, however, I have one question around this. I have 2 MySQL Db's want to migrate to MS SQL, one sizes around 850 GB and another one ...
1
vote
1answer
52 views

Is there a UI tool for moving data from two different tables?

The schemas in the two databases are different. Eg. Database 1 / users - id - name - phone Database 2 / users - id - first_name - mobile Is there a tool that lets me visually create the statements ...
1
vote
0answers
142 views

.DBC (FoxPro DBF) > FoxPro ODBC Driver > MIDDLEWARE > SaaS

I've been searching for Visual FoxPro ODBC Driver and finally found it. I am using a middleware to connect a .DBC (foxpro) > MIDDLEWARE > SaaS. I see from postings on MSDN that Microsoft suggests ...