Questions tagged [migration]
the process of moving databases or data from one place to another
685
questions
-3
votes
0answers
17 views
Migrate VIEWs from Oracle to SQL Server [on hold]
Is there any tool to migrate views from Oracle to SQL Server?
0
votes
1answer
41 views
What are possible ways to migrate SQL Server DB to PostgreSQL DB? [closed]
Currently I am assigned to complete the task of migrating several small to large databases (from 10GB to 200GB) from SQL Server to PostgreSQL RDBMS.
I would like to ask the community to share ...
0
votes
0answers
17 views
SSMA - Sysdb - Tables Missing
Based on my test, when I use SSMA for Oracle.8.4.ExtPack.exe to install, after the installation, I can see the table ssma_oracle.bcp_migration_packages and other tables are not in the sysdb database,
...
1
vote
1answer
43 views
SQL Server - Migration script testing - Refresh table definition manually without dropping it
How can a table definition be manually refreshed without also manually crafting a bunch of ALTER TABLE statements, or dropping and recreating the table?
This is normally handled by the publish ...
0
votes
1answer
16 views
how to upgrade postgresql 9.0.4 to latest with minimum downtime
I have master-slave-slave setup for postgresql 9.0.4 in our production setup.
We need to upgrade it to latest (11.X), so my question is what would be the procedure to do so with as little downtime as ...
0
votes
0answers
21 views
Migrate Mariadb 10.3 to Mysql 8
What is failsafe way to migrate ?
Both database are on CentOS 7 different servers and latest versions of database.
2
votes
2answers
54 views
How to Exclude Foreign Keys during Publish action in sqlpackage
I am trying to publish a .dacpac extract to a target database, I want to exclude just the foreign key constraints in all the tables. After going through the ExcludeObjectTypes options I do not find a ...
0
votes
0answers
45 views
SSMA cannot read meta data (missing runtime components)
What I want to do should be rather easy: Use SSMA to transfer internal Access tables and queries to SQL-Server.
On my Notebook I'm running SQL-Server 2017 and Office 365 (32 bit)
As I have 32 bit ...
0
votes
0answers
18 views
What is the best way to migrate old data into a running mariadb database?
We have a need to migrate a large number of 100GB databases onto a new infrastructure.
I would like to minimise downtime as much as possible, so am toying with the idea of migrating the clients to ...
2
votes
1answer
42 views
Adding indexes to production MySQL database without downtime?
I am looking to improve the performance of queries on a large MySQL database that is running in production by adding proper indexes. We have tried to add the indexes on the live database, but of ...
2
votes
2answers
55 views
SQL Managed Instance - Cross Subscription Restores/Migration
Short Version:
I am trying to restore a backup from one SQL Managed Instance to another SQL Managed Instance. These are in different subscriptions. Using Example 3 from here I can at least get it ...
1
vote
2answers
54 views
Migration to SQL Database using Transaction Replication - down time?
I am looking to migrate two on-prem SQL Servers into Azure Hyperscale. Both 28 cores, 1.5 TB of RAM with 10TB data disks.
I can NOT afford any downtime during the migration and have heard transaction ...
0
votes
1answer
28 views
Issue migrating oracle package to postgres using ora2pg
I was migrating an oracle(12c) package to postgres(Enterprise db 10.5) using ora2pg.
The migration run successfully for most of the functions. However, one function referenced multiple times in the ...
1
vote
2answers
67 views
Replicate a database with a subset of data offered by custom queries [closed]
As seen in this question I can use the following sql command:
CREATE DATABASE newdb WITH TEMPLATE olddb;
In order to replicate a database into my machine. But in my case my new database only to ...
1
vote
2answers
50 views
MS SQL Server Error 18456 after database move [duplicate]
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
28 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.
0
votes
0answers
46 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
18 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 ...
0
votes
1answer
51 views
Replicate SQL Server 2008 across domains
I have been tasked with migrating a database, size being up to 15Gb, from a SQL Server 2008 database in a 3rd party cloud VM, to SQL Azure. On go-live day, when we switch from the old host, the Azure, ...
-4
votes
1answer
145 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
37 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
27 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
36 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
26 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
24 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
29 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
29 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
80 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
9 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
33 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
85 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
138 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
39 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
13 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
93 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
27 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
412 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
129 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
147 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
144 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
42 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
38 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
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
164 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
27 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
709 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 ...
