Questions tagged [migration]
the process of moving databases or data from one place to another
706
questions
1
vote
2answers
3k views
Migration from SSRS 2012 to SSRS 2017
Our company is moving from SSRS 2012 to SSRS 2017. I would like to know if anyone has done a similar migration. If yes, could you please guide me through the steps?
From what I read about the ...
2
votes
2answers
173 views
SSRS- database and Report Server - can they be different?
I have inherited a few database servers. I am currently planning for a Server upgrade, but this DB server has a ReportServer and ReportServerTempDB database in it.
When I open Reporting Service ...
0
votes
1answer
267 views
Problem migrating PostGIS
I need to migrate Postgres 9.3 + PostGIS 2.1 to Postgres 10.
I'm using CentOS 7.X
Using pg_upgrade it should be quite straightforward, but the problem is PostGIS.
Postgres 9.3 has PostGIS 2.1 ...
2
votes
1answer
539 views
Migrate on-premise SQL Server databases to Azure SQL Database
We're in the process of a server migration from an on-premise server (Win2008R2) to Azure PaaS.
To move the databases, we used the Microsoft Data Migration Assistant (DMA) tool, which worked great ...
0
votes
1answer
237 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
4k views
is it possible to use utl_file_dir = '*' scope = spfile in 12c
Oracle 12c has deprecated utl_file_dir = '*' scope = spfile,
but I need to use this functionality. Is there any option to do it?
Is it possible to give permission using Java classes?
0
votes
1answer
685 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
30 views
MySQL how to migrate to new server without data lost?
I'm using AWS RDS, with 1 master & 1 slave.
Just now I alter 1 of the table and hangup halfway, so I force stop the process. Now the database got some problem.
Let say I wanted to instantiate a ...
4
votes
1answer
1k views
Postgres 9.4 wal_level=logical increases disk space
I am trying to use the AWS Database Migration Service to migrate data from an RDS Postgres instance to an Aurora MySQL instance.
Database Migration Service requires the wal_level to be set as logical ...
1
vote
0answers
46 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
1answer
95 views
Migrating PostgreSQL DB from AWS to Alibaba Cloud
I'm migrating PostgreSQL RDS instance from AWS located in Frankfurt to the RDS instance in Alibaba Cloud also located in Frankfurt.
I use Data Transmission tool from Alibaba Cloud. It connects both DB ...
3
votes
2answers
428 views
Migrating 300GB database to Azure SQL Server
We are having a devil of a time trying to migrate our current on-premises SQL Server to an Azure SQL Database. It is large but not that large (about 300 GB). We've tried the "Publish to Azure" option ...
0
votes
1answer
358 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
0answers
284 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 ...
0
votes
1answer
383 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
7k views
Easiest Way to Migrate data from MySQL to MongoDB [closed]
My latest IT project has me working with MongoDB for the first time. While I have a bit (very little) experience with NoSQL, I have always mostly worked with MySQL using Workbench.
I need to migrate ...
0
votes
0answers
195 views
PostgreSQL: Improving performance of data insert
I would like to migrate all data from DB2 into PostgreSQL. How should I configure PostgreSQL for best performance during the initial migration (loading the data with INSERT statements)?
Should/could I ...
4
votes
2answers
973 views
Move data from a table to another without losing data
I have a log table which is currently holding millions of records. I want to enable partitioning on that table, so what I did for now is:
Created a partition function and a partition scheme.
Created ...
0
votes
1answer
53 views
DDL for PostgreSQL for DB2 tables (migration)
How would I create the DDL for PostgreSQL for the following DB2 tables?
It should be a one-to-one migration, so I would like to change only as little as possible at the schema (I have difficulties ...
1
vote
0answers
213 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....
3
votes
4answers
2k views
Data Migration With Different Schemas
I have a database DBv1 on a SQL Server, and I want to migrate the data in it to DBv2 (on the same box, save server). DBv2 has very similar schema. The only difference in schema is that DBv2 has one ...
0
votes
1answer
25 views
When migrating all the way down, should I just run VACUUM (FULL) as the last down migration?
I use node-pg-migrate and Amazon RDS Postgres on a development environment where I'm the process of building an app.
Sometimes I migrate all the way down so that the database is almost as it was when ...
1
vote
1answer
315 views
Will SQL Server continue to work after I change drive by changing drive letter?
I have SQL Server 2014 Enterprise Edition installed. Now I have some user databases created and being using. The data files and log files of them are placed on D: drive, which is SAS drive. Now I want ...
0
votes
1answer
321 views
Transfer Data between MySQL and MongoDB Databases [closed]
My latest IT project has me working with MongoDB for the first time. While I have a bit (very little) experience with NoSQL, I have always mostly worked with MySQL using Workbench.
I need to migrate ...
2
votes
1answer
112 views
SQL Server 2008R2 database migration to cloud: case-insensitive collation changed to case-sensitive
Recently felt the fall out (crappy legacy code base) of a database migration by a third party vendor where the collation was swapped from case-insensitive to case-sensitive. I am wondering if the ...
-3
votes
1answer
675 views
oracle to postgresql syntax convert
oracle :
CREATE OR REPLACE TRIGGER ORA_ADMIN.T_INCOMING_FILE
BEFORE INSERT ON ORA_ADMIN.INCOMING_FILE FOR EACH ROW
DECLARE
err_num NUMBER;
err_msg VARCHAR2(100);
BEGIN
SELECT incoming_file_seq....
2
votes
1answer
565 views
SQL Server Migration using a DB Mirror (Rolling upgrade)
I'm planning to do SQL Server migration of SQL Server 2012 to a new hardware and a new version of SQL Server (2016). I'm trying to find the best solution with minimal downtime. I found some ...
1
vote
0answers
135 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. ...
0
votes
1answer
95 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 ...
1
vote
1answer
121 views
Latitude & longitude universal format [duplicate]
I don't know yet what database I'll use in the future - MySql, Postgresql, Sqlite3 or anything else. At the moment I'm using a database N.
What's more or less universal approach for storing latitude &...
-1
votes
1answer
382 views
ERROR: column “minute” does not exist
I am migration mysql to Postgres
Runing this bellow query on both Mysql and Postgres
SELECT
cb_sessions.*,cb_users.username,
cb_users.userid,cb_users.email
FROM cb_sessions
LEFT JOIN (cb_users) ...
1
vote
2answers
379 views
Migrate SQL Server to Oracle 11G Offline (OMWB)
So, I'm having some difficult to migrate SQL Server to Oracle. This time there appears a new error message:
Migration actions have failed check the migration reports for details. :
Capture
Offline ...
0
votes
2answers
40 views
Keeping database in synch
This might seem like a stupid question.
Can i restore logs of one database to another existing database of same schema.?
I have a database d1 in Server A.I took backup of that and restored as ...
1
vote
1answer
380 views
DBCC CHECKDB fails after restore to SQL Server 2017
I have a DB on SQL Server 2014 and after I restore a backup on SQL Server 2017 I get integrity check errors when running CHECKDB. When I restore it on another machine with SQL Server 2014 it works ...
2
votes
1answer
3k views
ERROR: column “field” must appear in the GROUP BY clause or be used in an aggregate function
I've hit an SQL problem that I'm a bit mystified by. I have two different
questions regarding this problem:
Why?
How do I work around it?
The following query:
SELECT subs.date_added,subs....
0
votes
3answers
897 views
How to transfer data from denormalized table to normalized tables in Oracle?
Hi I currently have a database set up with a table like this:
Grades: student name|class name|overall|hw|test|quiz|project|val
where student name and class name are type varchar2 with the rest being ...
2
votes
1answer
385 views
Migrating Production SQL Servers (Availability Group) from one data center to another - questions
We have two SQL servers combined into Availability Group in data center 1 (dc1):
dc1 server 1: SQL Server 2012 SP3 on Windows Server 2016
dc1 server 2: SQL Server 2012 SP3 on Windows Server 2012 R2
...
1
vote
0answers
90 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
votes
1answer
49 views
DBMS To Load multiple types of dump files [closed]
I just want to know if there's a DBMS for Linux that I can use to restore dump files from various other DBMS's, for example MySQL, PostgresSQL, SQL Server, etc.
I am in the task of migrating data ...
0
votes
1answer
381 views
Issue with Ñ character in name (migrated data from MySQL to PostgreSQL)
I'm currently running a test migration of data from MySQL to PostgreSQL. I'm using psycopg2 to perform the task.
I was able to migrate the person's information but when I check the data for ...
0
votes
2answers
97 views
Migrate SQL Server - server name in stored procedures references old server
I will migrate an SQL server from 2000 to 2008 R2. It contains two instances. I have many stored procedures that are referencing the instance names like:
select ... from [old_server\instance1].db1....
0
votes
1answer
1k views
How to Migrate Oracle 11g R2 (Windows) database to Oracle 12c R2 (Linux) db
I have a requirement to migrate Oracle 11g R2 database (Windows platform) to Oracle 12c R2 database (Red Hat Linux platform).
Is there any methods using RMAN to do it?
Any help will be appreciated.
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 ...
-3
votes
1answer
28 views
Will one transaction with million of queries blocking? [closed]
I am having a data migrating task that need to run couple of million UPDATE queries in one single database transaction. Will this causes anything bad for other clients connecting/querying from the ...
1
vote
0answers
49 views
Migration to version 2016 from versions 2000, 2005, 2008, and 2012 [duplicate]
I just accepted a position that has multiple versions of SQL Server, from what I was told during my interview, it ranges from versions 2000 - 2012, the main goal is to centralized these databases to ...
1
vote
1answer
135 views
SQL Server 2014 Edition Downgrade
I have a SQL Server 2014 Standard Edition used by my devs to test their applications pointing to a common instance. Lately I've been informed that for this purpose I can use Developer Edition, that it ...
1
vote
0answers
696 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 ...
0
votes
1answer
2k 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 ...
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 ...
0
votes
1answer
233 views
Regular data transfer from SQL Server to MySQL
Our company uses an application with a SQL Server database where we store all of our Project Item data.
Our company's Portal Website uses a MySQL database that holds other Project information (...
