Questions tagged [migration]
the process of moving databases or data from one place to another
779
questions
0
votes
1answer
320 views
Moving Partitioning Files To Another Disk Drive In SQL Server
There is a production table which was partitioned by someone in our company. Some partitioning files was wrongly located to different disk drive.
I have to move those files to the disk where they ...
0
votes
2answers
138 views
Can a SELECT statement block an ALTER TABLE?
I see in Postgres docs:
Two transactions cannot hold locks of conflicting modes on the same table at the same time
During maintenance (schema migration) we saw cases when we can't ALTER TABLE ...
3
votes
2answers
269 views
Migrate foreign key type from char to binary - ways to deal with the fallout?
I am in the process of slimming down a database that has been using char/varchar fields where binary/varbinary would be a better choice (given the data represented is byte arrays).
One of the fields ...
0
votes
1answer
102 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 ...
1
vote
1answer
44 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
96 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
182 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.
3
votes
3answers
597 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
425 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
21 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
1k 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 ...
5
votes
3answers
2k 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 ...
2
votes
2answers
274 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
158 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
207 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
81 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
86 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
127 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
1answer
66 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
146 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
130 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
105 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
360 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
27 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
47 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
79 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
32 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
230 views
Mongo replication sync to newer version
I got one mongo v2.4.10 server with 1.7TB data, I am trying to migrate and upgrade the mongo to mongo v.3.0.15 server
I've setup a new mongo v.3.0.15 and configured replication for v3.0.15 to be ...
0
votes
1answer
1k 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 ...
1
vote
1answer
47 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
269 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
1answer
202 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
1answer
2k 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 ...
1
vote
0answers
3k 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
691 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
676 views
How to migrate Unicode UTF-8 CLOB data from Oracle to SQL Server 2017 UTF-? [closed]
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
24 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
27 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
229 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
297 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
...
1
vote
0answers
27 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
83 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 ...
2
votes
0answers
516 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
52 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
2k 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
123 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
314 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
1answer
1k 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
838 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
599 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'...