Questions tagged [migration]
the process of moving databases or data from one place to another
671
questions
1
vote
2answers
39 views
MS SQL Server Error 18456 after database move
I have a windows service connecting to a SQL database. Recently, I was told to change the DB name in the connection string, all else was the same. When I attempted to connect, it threw Error 18456. ...
0
votes
1answer
26 views
Does Data Migration Advisor migrate system databases?
I would like to know if Data Migration Assistant copies system databases (master, model, msdb) into the new server.
1
vote
0answers
42 views
Tool to migrate data to another database with different object names [on hold]
We are working on a project to migrate our Oracle database to SQL Server. There are many off the shelf products that seem to do this such as Microsoft SQL Server Migration Assistant & Navicat ...
0
votes
0answers
43 views
Migrating from windows-1252 to UTF-8 character set
I'm thinking of migrating my database (oracle) from windows-1252 to UTF-8 by doing the following:
export all data (backup)
truncate all tables
run alter database character set
import data back
Is ...
0
votes
0answers
14 views
Not able to migrate DTS package from SQL Server 2008 to 2012. Getting errored out
Requirement: We need to migrate SSIS/DTS package from SQL Server 2008 to another machine having SQL Server 2012 on it.
Steps performed so far:
1. First I exported the package from Source server to ...
-4
votes
1answer
143 views
Is SQL Server 2016 already in a good shape to be used? [closed]
So it's time to upgrade out servers. I'm new in this company and we have SQL Servers from 2008 to 2014. I really don't see a problem upgrading all of them to 2014 because it's really wel documented ...
0
votes
0answers
19 views
How do I migrate mysql .frm and .ibd files to sqlite?
Mysql seems to not work anymore on my machine. I have spend way too much time trying to fix it but without success.
But I found out that sqlite does all the stuff I need so why not just change to it. ...
0
votes
1answer
18 views
“Cannot open user default database. Login failed” after altering MDF and LDF locations and bringing DB offline
I was attempting to move my database to a separate hard drive on the server, so I ran the following commands in the following order (I was following this question : How to change location of SQL ...
0
votes
2answers
35 views
Migrate large postgresql database (windows -> linux) [closed]
I have a "large" PostgreSQL (9.6 with timescale plugin) database (about 1Tb). And would like to migrate it to a Linux machine. The naive approach would be pg_dump and pg_restore.
(Not sure how long ...
1
vote
0answers
25 views
Centralizing Databases
I have a very challenging scenario at hand and would like to hear suggestions on the solution I am considering implementing.
I have several databases that have similar (non-identical) structures and ...
0
votes
1answer
23 views
How to speed up Oracle to PostgreSQL data transfer
I have an Oracle schema that I am transferring to PostgreSQL with ogr2ogr.
This particular table has 5 columns with number(22) each. There are some 300M rows. In under 10 minutes I can transfer this ...
2
votes
1answer
21 views
pg_restore “CREATE CAST” not executed if using public or pg_catalog schemas
While moving database to another instance I'm using pg_dump and pg_restore with intermediate file.
Dump file was created like this:
pg_dump --host $SRC_DB_HOST --port 5432 "dbname=$SRC_DB user=$...
1
vote
1answer
28 views
Inspecting the status of a long-running COPY statement
I need to migrate a table from one PostgreSQL database to another. There was a chance I would need to fix some data, so I exported to a CSV. Then I imported the CSV in the second database with a COPY ...
0
votes
1answer
50 views
Postgres column type unknown
I am trying to port a database where there is a table with a column of type unknown. pg_restore raised the error
pg_restore: [archiver (db)] could not execute query: ERROR: column "color" has ...
0
votes
0answers
6 views
How can I get the MySQL Workbench migration report in a file?
I am looking into a possible migration from SQL Server to MySQL. I've run the migration tool and generated a report but the output is HUGE and I need to share different parts of the report with ...
0
votes
0answers
30 views
Are temporary columns a good solution for loading data for a small scale data migration?
Our team is facing the following scenario. We're trying to import data from a denormalized data set in MySQL into a normalized MySQL database and are unsure of what a good solution would be for ...
1
vote
1answer
29 views
Legacy data migration to Always on Availability group database
In our application there is a data conversion process that brings all the legacy data to the production database.
Since our database is on availability group and the migration might bring 100GB + ...
1
vote
1answer
54 views
Help using SQL Server Database Experimentation Assistant for performance testing
I am following the guide for capturing a trace in SQL Server Database Experimentation Assistant here: https://docs.microsoft.com/en-us/sql/dea/database-experimentation-assistant-capture-trace?view=sql-...
0
votes
0answers
70 views
Migration from MySQL 5.7.10 to Aurora (MySQL)-5.6.10a Serverless and switching sql_mode
I am looking into migrating my locally managed MySQL 5.7.10 database to Amazon Aurora Serverless. I am tired of managing my database manually and I would like to use an auto-scaling feature of Aurora ...
0
votes
1answer
28 views
WHILE Loop for data migration/merge with multiple fields for matching
Ok so I have two identical databases in two parts of the world. I need to merge everything into the one I will call North (the other being South). North data trumps South data. I started thinking ...
0
votes
0answers
10 views
Migrate data from database on MarkLogic 7 to database on MarkLogic 9
I need to copy data from a MarkLogic 7 database to MarkLogic 9 database on another system. I tried backup and restore option provided by the MarkLogic Admin console. The original database in MarkLogic ...
0
votes
1answer
42 views
Can I upgrade SSIS 2008 packages directly to SSIS 2017 SSISDB?
I'm planning a mifgration of a SQL Server 2008 instance running the DB engine and SSIS.
The SSIS is deployed to the file system.
Am I able to copy those SSIS packages to a directory on my new ...
0
votes
0answers
19 views
SSMA Migration data failed from Oracle to Azure Database
I'm having an issue with the migration between an Oracle database and an Azure Database using SSMA v7.10.0.
I can connect, convert the schema and synchronize with the Azure database with no problem.
...
0
votes
0answers
181 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
83 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
107 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
15 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
112 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
39 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
29 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
25 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
54 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
113 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
26 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
472 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
30 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
76 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
58 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
202 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
164 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
106 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
144 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
38 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
61 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
29 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
39 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
54 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
24 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 ...
