Questions tagged [migration]
the process of moving databases or data from one place to another
0
votes
1answer
16 views
Migrate complete postgres database cluster to another machine using pg_dump
I am referring to
How to get a working and complete PostgreSQL DB backup and test
In this example/solution, which part of the restore process does actually the "CREATE DATABASE sandbox"? I have been ...
0
votes
1answer
27 views
Migrating triggers, functions and procedures from Oracle to PostgreSQL
We run a Java based application which uses Oracle as its backend. While they are rather simple and don't overly use Oracle specific functions, we have lots of triggers, function and procedures written ...
0
votes
1answer
18 views
Heartbeat frequency in AWS DMS (Database Migration Service)?
Within "PostgreSQL Source WAL Heartbeat https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReleaseNotes.html#CHAP_ReleaseNotes.DMS230", what does heartbeat frequency represents? The AWS docs doesn'...
0
votes
0answers
43 views
Indexing binary data in PostgreSQL?
I am converting an Oracle 11G DB to PostgreSQL v11 DB.
I am super new to the whole database thing and I have encountered a query using index type of ctxsys.context to create an index.
I have no idea ...
1
vote
1answer
28 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
44 views
A transport-level error has occurred when receiving results from the server [duplicate]
Our application is made from asp.net webforms using framework 4.5. And since migrating to Amazon AWS from an inhouse server. We've been flooded by this error through out our system.
On the software ...
-2
votes
0answers
20 views
Odoo “openerp” migration from 10.0 to 11.0 [closed]
dears
i'm using migration for odoo 10.0 to 11.0 USING OPENUPGRADE from OCA
while validating in last step it gives error
copying database CMS to CMS_migrated...
Traceback (most recent call last):
...
0
votes
0answers
23 views
PostgreSQL decrease performance after migration
After postgresql database server v9.3 migration to v9.6 I noticed a decreace in the performance of the entire system. The config parameters are the same as in v9.3 taking in to account the next ...
0
votes
1answer
27 views
deploy data from sql 2016 backup to azure database
I've got backup data from a SQL 2016 server that i want to move/restore onto an azure database. I'm not seeing an in-house option to do this anywhere, so it looked like the best option was to restore ...
0
votes
0answers
12 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
38 views
Full Migration 2008R2 -> 2016
We currently have Windows Server 2008 with MS/SQL 2008R2: the default instance and two named instances.
We are spinning up a Windows 2016 Server onto which we will install MS/SQL Server 2016 Standard ...
1
vote
0answers
18 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 ...
8
votes
4answers
1k views
Best practices to maximize portability in SQL Server 2016
When it comes to developing the prototype of a solution, often the technologies has not been decided yet and might not be the same that will be used in the finished product.
In this scenarios I tend ...
1
vote
1answer
46 views
Select FK constraints with ON UPDATE NO ACTION
We use Postgres 9.5.
Is it possible to modify this script to show the ON UPDATE action for each foreign key reference at this table? Or get this values somehow?
SELECT
tc.table_schema,
...
0
votes
3answers
49 views
Database Migration [closed]
We are migrating our one of testing servers.
My questions are:
What is a best way to migrate database from one server to another?
If I do data migration through export/import utility (Full database ...
0
votes
1answer
42 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 ...
1
vote
1answer
43 views
Merging the sysdb database (a dependency due to conversion from Oracle) into my SQL Server 2014 Express Database
I am looking to convert my SQL Server 2014 Express Database to Azure SQL Database.
My SQL Server database was automatically converted from Oracle a number of years ago, and needs the sysdb database (...
-1
votes
1answer
57 views
How to copy data and schema from oracle to ms sql
Is there any easy way to copy data and schema from oracle to ms-sql.
i am using sql server 2017 and oracle sql developer Version 4.1.4.21
I need one time migration.
I am using SSMA but getting ...
1
vote
1answer
49 views
migrating from a local PostgreSQL database to Amazon Aurora
I have a local PostgreSQL database and I want to migrate it to Amazon Aurora, how do I do that? I found a documentation on how to migrate from RDS PostgreSQL database, however, mine is local and I ...
0
votes
1answer
34 views
Moving Oracle / Oracle datafiles to different file system on Linux
We have Oracle installed on /root, which is now running out of space due to increasing data in Oracle database. On the same machine we have another file system with free space.
I want to know the ...
1
vote
2answers
371 views
Undefined symbol when migrating to Postgres 11 [closed]
After upgrading Postgres 10 to version 11, by using pg_upgrade, I get this error:
could not load library "$libdir/postgis-2.4": ERROR: could not load library "/usr/pgsql-11/lib/postgis-2.4.so": /...
0
votes
1answer
76 views
Sybase to SQL Server Migration [closed]
What is the fastest/best approach to load data from SYBASE to SQL server DB. I have tables with 500 million records. I tried using SSMA and BCP, both are taking over 24hrs. I tried using datastage (...
1
vote
1answer
57 views
How to copy selected table data from sql server to mysql on a daily basis? [closed]
I am having a retail pos application with MSSQL database. Now I need to transfer selected table data from SQL server to MYSQL database on a daily basis like job.
How to achive this?
0
votes
2answers
123 views
Migration of MariaDB/MySQL to another server without downtime
System : MariaDB (MySQL 5.5)
Parameters : innodb_file_per_table=1
The database I have now is approaching its full capacity (94% full now, 6.4TB out of 6.9TB)
I can't run OPTIMIZE TABLE to reclaim ...
0
votes
2answers
51 views
How to make a backup of an Oracle database that does not mess up the regular backup cycle?
Goal
I want to move a database from server A to server B. Both server have the same technology so one way is to shutdown the source database, copy data files,control file, redo logs, parameter file ...
3
votes
0answers
35 views
Measure CPU, Disk (I/O) and Memory Used by a Specific Database [duplicate]
For reasons outside the scope of this question, I need to deploy a specific database from my main server to a secondary server; the problem I have is that the secondary server does not exist yet and I ...
1
vote
2answers
226 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
79 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
73 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 ...
1
vote
1answer
192 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
27 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
401 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
72 views
Migrating Oracle 10g on Solaris Sparc to Linux RHEL 5 VM
if i will rate my oracle expertise i would give it 3/10. i just started learning oracle, solaris and linux 2months ago and was given this task to migrate. yes our oracle version is quite old and might ...
0
votes
1answer
186 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
20 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 ...
3
votes
1answer
530 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
18 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
51 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 ...
2
votes
1answer
99 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
109 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 ...
1
vote
0answers
87 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
137 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 ...
-1
votes
1answer
1k 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
134 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
747 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
30 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
86 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
395 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
21 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
136 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 ...
