Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [migration]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
558 views

AWS DMS Fails with “Command failed to load data with exit error code 1”

I am trying to Migrate my Postgresql RDS to Aurora Postgresql using DMS. All my tasks are failing, and I am unable to understand what can be done to help the tasks progress. The error from cloud ...
0
votes
0answers
158 views

How to improve the speed of a large data migration between SQL Server and MySQL server?

I have an application that is connected to a SQL Server Express database. The database grew and the database is almost at 10GB which is the max limit that SQL Server Express allows for. I am trying ...
3
votes
1answer
203 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 ...
0
votes
0answers
16 views

regularly calculating data and then loading to production database

I have a Postgres database running a small website. Most of the tables in the database are calculated values derived from various input data. This input data is updated approximately monthly. The ...
0
votes
1answer
26 views

“Pausing” log shipping to allow normal DB use. Is this process valid?

I am in the process of migrating a server to AWS. Right now it is just for Dev/QA work, but will eventually be turned into our production server. It is a 2 node AG. Server is all up and running, ...
0
votes
2answers
160 views

Issue migrating from SQL Server 2008 R2 to SQL Server 2017 Standard (on Linux)

I am currently trying to carry out a database migration from SQL Server 2008 to SQL Server 2017 (Linux) using the DMA tool. I get the all green after running the assessment, however I get hit with ...
0
votes
2answers
48 views

sql server: get all the databases in which a login is being used

I'm creating a few migration scripts to generate a sql server database from scratch. In my '0005-create_login.up.sql' script I have something like: CREATE LOGIN [mylogin] WITH PASSWORD=N'xxx=', GO ...
0
votes
0answers
39 views

I am migrating SSRS from SQL server 2008 r2 to sql server 2016 on another server. Finding and backing up the right web.config and machine.config

I am following "https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/migrate-a-reporting-services-installation-native-mode?view=sql-server-2017#bkmk_backup". Under "Backup Files 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 ... ...
0
votes
1answer
58 views

Migration to Oracle Autonomous Database

What prerequisites, if any (such as version number, database objects in use), does an existing Oracle database have to fulfil in order to be able to migrate it straight away to Oracle Autonomous ...
1
vote
0answers
191 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
0answers
28 views

Escape from Alcatraz: SqlAnywhere to MSSQL [closed]

Is there a migration tool that actually works for SAP SqlAnywhere 17 to MSSQL (any recent version)? Searching for "sqlanywhere mssql migration" yields a variety of hits including SQL Server ...
1
vote
1answer
844 views

Copy/move data from one cassandra server to another

I'm in the midst of replacing a kubernetes stack (to more specific: moving it from a locally hosted cluster to an AKS cluster in Azure), and as a result have to re-create all of my services, including ...
0
votes
1answer
47 views

Veryfing pg_restore database with pg_dump database

I just did a migration from Postgres 9.4 to 10 database. How to verify if everything is okay? I tried to look into huge tables, the rows are different (somehow in Postgres 10 then are more rows than ...
1
vote
2answers
133 views

Migrating to a new (upgraded) SQL server

We have a single SQL server with about 60 databases running on Win2012r2 with SQL 2014. I am in the process of planning a hardware refresh and plan to migrate to WIN2016 with SQL 2017, I understand ...
0
votes
0answers
76 views

Azure MariaDB log_bin_trust_function_creators

I'm testing AzureDB for MariaDB and for my DB to work properly I must change log_bin_trust_function_creators variabl. However, it isn't available in Azure Portal Server Parameters. I've checked and ...
0
votes
1answer
331 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
364 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 ...
-1
votes
2answers
187 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
1answer
263 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
46 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
91 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 ...
0
votes
0answers
32 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
32 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
1answer
70 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
63 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
27 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
161 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
52 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
106 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
73 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
260 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
312 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
64 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
839 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
442 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
245 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
304 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
68 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
41 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
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
162 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
238 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
488 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
172 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
3k 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
213 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
599 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
27 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 ...