Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [migration]

the process of moving databases or data from one place to another

Examples of migrations:

  • Moving databases across machines or instances (e.g. host1 -> host2)
  • Moving databases across different platforms (e.g. MySQL -> SQL Server)
  • Moving large amounts of data in a one-time change (e.g. ETL)
916 questions
39
votes
5 answers

Can I write portable SQL statements?

I am wondering if it is possible to write SQL statements that are 100% interoperable with most or all databases including: MariaDB/MySQL/Percona Postgres Microsoft SQL Oracle SQLite (Eg, can I just follow a specific SQL standard? Eg, is there…
James Shewey
  • 505
  • 5
  • 8
3
votes
2 answers

How to migrate data between "all-surrogate" databases?

With some periodicity this needs to be done: Inserting data from a production database into a test/development database, so that programmers have fresh data to test on. Migrating data from a database into another, for whatever reason. Note:…
Tulains Córdova
  • 713
  • 6
  • 13
  • 27
3
votes
4 answers

The term Database Migration

I'm curious, when I first heard of the term database migration, it was unequivocally pertaining to moving entire databases from one platform to another. However, recently I had to build a server that required setting up a database myself. Then I…
krenova
  • 33
  • 3
3
votes
1 answer

Managing schema changes between transactional and analytical databases

How would you manage changes in a transactional database that affect an analytical database? Environment: Transactional database is a current, or near current version of MySQL. Size of the transactional database appears to be around a few…
blunders
  • 334
  • 3
  • 13
0
votes
2 answers

Importing external data with different field format

I have the source file in Excel as follows: Item-------Reference---Description -400020--20045-------Ruler 60cms 8900032--20012-------Eraser 45gr Notes: Because I can add many spaces here, the dash"-" denotes a space on the original file The…
daniel2126
  • 1
0
votes
1 answer

SQL agent job Error while migrating from 2008 R2 to SQL 2014 for openrowset query

I need to insert metadata into temp table. It was working fine in 2008 R2. Below is my query. Insert INTO #Temp (SELECT * FROM OPENROWSET('SQLNCLI','Server=.;Trusted_Connection=YES;', 'set fmtonly off; EXEC msdb.dbo.sp_help_job') ) Getting this…
Puskar
  • 181
  • 1
  • 3
  • 15
-1
votes
1 answer

DBMS To Load multiple types of dump files

I just want to know if there's a DBMS for Linux that I can use to restore dump files from various other DBMS's, for example MySQL, PostgresSQL, SQL Server, etc. I am in the task of migrating data from various DBMS's and I'm wondering if instead of…
tango ward
  • 215
  • 1
  • 4
  • 9