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
12 views

Change Azure Standard to Premium

I have one application using SQL Server Standard and would like the change to Premium, but I need to understand about the DTU. The application reaches 100% in DTU every day. Would talk know if I need ...
-1
votes
0answers
33 views

ORACLE DMU (database migration assistant for unicode) Tool

Reading the documentation for Oracle DMU tool, when I try the step create a step for DMU Repository tablespace the document says to use the result of the query for initial size. However; I could not ...
2
votes
0answers
48 views

How to install Distributed Replay (dreplay.exe) for SQL Server 2017

In SQL Server 2014, dreplay.exe was available under "Management Tools – Basic" feature. However, in SQL Server 2017 that feature no longer exists (Enterprise edition) and it doesn't come with SSMS ...
-1
votes
0answers
12 views

Convert mailing label pdf to csv file [on hold]

I have a large pdf file of post addresses formatted to be printed on labels. There are 30 addresses on each page. Some are three rows, others are 4 rows. I want to convert the data from the pdf file ...
0
votes
0answers
82 views
+100

Removing foreign keys to reduce downtime

In an attempt to reduce downtime on our production servers we are considering using one of the following tools to do schema migrations without any downtime: Percona Toolkit — pt-online-schema-change ...
0
votes
1answer
25 views

Migrate legacy application to new db/schema

I apologize if I made any mistake/missing info, fist post here! I am in the process of rewriting a website from scratch to a newer tech stack with a completely redesigned architecture. The website in ...
1
vote
0answers
22 views

What All Is Factored Into A MySQL Checksum? (Why Could They Be Different?)

I'm currently going through the excruciating task of moving MySQL databases from one shared web hosting environment to another. This has been a multi-month battle (and I'm learning a lot). After ...
0
votes
0answers
25 views

Need to move ssis package from SQL server 2008 to 2012

We have to move ssis package from SQL server 2008 to 2012 on another server. Package on source is stored in msdb. What is the best way to move the packages to 2012?
3
votes
1answer
49 views

Migrate large (200GB) mysql databases to new hosts with as little downtime as possible

My question is about migrating large amounts of MySQL data with as little downtime as possible. I have 3 MySQL databases that need to be moved from one RDS instance inside a VPC into a brand new AWS ...
1
vote
4answers
127 views

How to prevent a full database backup

We are in the middle of migration, a full backup has been taken and copied to the destination. On Friday, we plan to do a differential backup, but someone has by mistake taken another full backup (did ...
0
votes
1answer
51 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
37 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 ...
0
votes
3answers
57 views

Error messages while migrating from Oracle to MSSQL [closed]

I got these error messages when migrating from Oracle to MSSQL (Unfortunately, the error messages are in German languages) Verletzung der PRIMARY KEY-Einschränkung "DTR_PK". Ein doppelter Schlüssel ...
3
votes
2answers
248 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
42 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
20 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
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
22 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
27 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
66 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
61 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
19 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
47 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 ...
3
votes
2answers
81 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
72 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
31 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
73 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
30 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
50 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
31 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
42 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
30 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
37 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
25 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
30 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
93 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
127 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
10 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
105 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
180 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
52 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
182 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 ...