Questions tagged [migration]
the process of moving databases or data from one place to another
0
votes
1answer
24 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
65 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
26 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
12 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
21 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
35 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
32 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
23 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
44 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
0answers
23 views
Sybase database migration from old SAN storage to new SAN storage
I need best practice recommendation regarding Sybase database migration from old SAN storage to new SAN storage.
0
votes
1answer
14 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
46 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
30 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
37 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
43 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
42 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
56 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
33 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
46 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
24 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
21 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
43 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
19 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
58 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
50 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
58 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
49 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
81 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
116 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
37 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
440 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
158 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
115 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
174 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
55 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
36 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
541 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
96 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
103 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
260 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
35 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
954 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
118 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
307 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
745 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
25 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
57 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 ...
