Questions tagged [migration]
the process of moving databases or data from one place to another
0
votes
0answers
15 views
Daily migrate Firebird file to SAP Hana
I've just started to work with Database manipulation and queries. Our company is focused in Business Intelligence, and we were asked to daily extract and analyze information from a FDB file, that ...
1
vote
1answer
34 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
48 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 ...
1
vote
0answers
23 views
Migrate Access tables to generic SQL Server tables [closed]
I have the need to migrate about 800 or so Access database tables to one or more generic SQL Server database tables. The requirement is to have no more than 2 or 3 tables in the SQL Server database.
...
0
votes
1answer
30 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
37 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 (...
0
votes
0answers
25 views
Two SQL Transaction log backups and one of them copy only
We have two different Transaction log backups and one of them copy only.
Copy-only triggered from Veeam backup tool. Normal one from SQL native one.
I would like to configure Log shipping for all the ...
0
votes
0answers
11 views
Moving a mysql table from one db to an other results `packet_write_wait: Connection to 50.16.16.16 port 22: Broken pipe`
I was trying to move a 20G database from one server to an other, and it stopped every time I tried importing it (mysqldump for the old db and then moving to the new one).
I decided to move some ...
0
votes
0answers
17 views
AWS Aurora to Redshift continuous data capture
We have a Aurora database which is very write heavy, few tables are continuously being populated(lots of insert/update) throughout the day.
The query on the Aurora are slow when some bigger clients ...
-1
votes
1answer
46 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
31 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
33 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
188 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
38 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
42 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
80 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
0answers
22 views
How to change version of .mdf file to lower version [duplicate]
I have SQL Server database file with .mdf extension. which I created on visual Web Developer 2015 then now I am using Visual Studio 2010 and I attached that .mdf file (which was created in Visual Web ...
0
votes
0answers
24 views
Automate merging of DB Changes, after successful Execution in Dataabase
I am trying to automate the DB Release for MariaDB.
Our code repository is in Bitbucket.
Is the following possible,
Code added to the repository.
Teamcity executes the changes in DB based on the ...
0
votes
2answers
48 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
96 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
71 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
46 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
124 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
21 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
109 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
54 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
90 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
In plsql program
CREATE OR REPLACE TRIGGER EVENT_ALLOWABLE_STATUS_S ...
0
votes
0answers
25 views
SQL Server 2012 to Oracle 12c migration
I am very new to Oracle world and I am trying to migrate a SQL Server 2012 database to Oracle 12 using SQL Developer. Looks like I am able to migrate the database successfully as I got a popup saying "...
0
votes
1answer
19 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 ...
0
votes
0answers
71 views
Users are missing in Database restored from .bacpac file
I am creating a new database from a reference .bacpac db file but the issue is that in the new Database, users are corrupted and I cannot login through any of the database users that were there ...
1
vote
0answers
25 views
Oracle Database Recovery [closed]
I recently develop an app using Oracle Application Express on a Windows OS, after uploading lots of data. Unfortunately for me the OS field before I could make any backup but, I salvage the data files ...
3
votes
1answer
333 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
16 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
47 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 ...
0
votes
0answers
27 views
Migrating SSRS reports with shared data sources between instances using rs.exe
Has anyone successfully used rs.exe and ssrs_migration.rss to migrate reports using shared data sources between SSRS instances? This doesn't seem like it would be that unusual of a situation but I ...
2
votes
1answer
60 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
79 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
60 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
97 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
806 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
111 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
692 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
28 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
61 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
281 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
20 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
110 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
53 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
57 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 ...
