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

learn more… | top users | synonyms (2)

3
votes
1answer
43 views

Cloning a database to another collation

I'm not sure if this is the best way to migrate data to another collation but I've done the following: Scripted the source database and changed the collation in the script to my required one Ran the ...
5
votes
2answers
495 views

Physically migrate MySQL without a dump

A client ask me to migrate his MySQL DB: The server doesn't have free space and it also has a very big table that is broken, so I can't dump it. I can't REPAIR it because of lacking of free space. ...
4
votes
2answers
3k views

How to compare two SQL Servers instance level objects for a migration?

I'm currently working on a SQL Server migration (from a SQL Server 2005 to a 2008 R2 server, on a new physical server). The databases themselves will be transferred using a database backup and ...
0
votes
0answers
39 views

Updating 2M rows based on 2M individual rules (MYSQL)

I'm carrying out a fairly simple (but large) Database combine/migration (simple/dumb, but slow work). It's 2 systems that are very similar, but do have slight differences. Currently the main issue is ...
1
vote
1answer
43 views

migrate over clause from mssql to mysql

How to write the following code into mysql, SELECT SUM(COUNT(col1)) over (PARTITION by col2) as summation FROM TABLE GROUP BY col2
2
votes
1answer
4k views

Can I upgrade SQL Server 2008 R2 Standard to SQL Server 2014 Developer?

Is there a migration path to upgrade SQL Server 2008 R2 Standard to SQL Server 2014 Developer? If so, are there any pain points? If not, how would you recommend I proceed? The context of this ...
9
votes
2answers
234 views

Bulk insert M:N relation in PostgreSQL

I need to import data from an old database to a new one, with slightly different structure. For example, in the old database, there is a table recording employees and their supervisors: CREATE TABLE ...
2
votes
1answer
175 views

migration of oracle xe 10 to xe 11 fails with wrong paths used in the import

I'm following the documentation to upgrade an OracleXE 10.2 database to OracleXE 11.2. The export succeeded without any problem, the import (on another machine with XE 11) fails though. The log file ...
0
votes
1answer
232 views

How to convert database mysql4 to mysql5

I have mysql dump file named booster.dump. It was export from 4.0.27-standard mysql server. Now I want to convert this database to mysql 5.1.73-cll. How can I do it? I search about this topic in ...
0
votes
0answers
29 views

One bitmask column vs multiple bit columns [duplicate]

I have many tables with a column storing a set of days of week. I used to use MySQL and data type "set" worked well. For example: [worker] id weekday_mask (data type: ...
1
vote
1answer
61 views

Best way to transfer millions of rows from one database to other

There are two databases: DatabaseA and DatabaseB with the same schema. These databases have millions of rows. The plan is to convert them into one single database (DatabaseCommon) and multiple ...
0
votes
2answers
32 views

Migrate MySQL tables to new server with same tables already on it?

We migrated our web server to a newer server. We have the old and new both running while we do testing on the new one. The old one is still being used in production by our clients and internal staff ...
1
vote
1answer
50 views

mysql workbench migration changed my database. Can I trust it?

I'm migrating a large production database(s) from mysql 5.5 to 5.6. Used Mysql Workbench Migration Wizard which creates a shell script to run on source and taget machines. The process worked well but ...
0
votes
2answers
3k views

SQL Server to Oracle export using Microsoft OLEDB Provider for Oracle

I am trying to Export Data from SQL Server to Oracle using the "Microsoft OLEDB Provider for Oracle". I am using "Export Data..." option from Task menu. I get to connect to the source database (SQL ...
2
votes
1answer
198 views

Can Unicode columns include non-Unicode values in SQL Server?

I need to convert Unicode column values from UTF16-LE to UTF-8 to then import into MySQL. Is it safe to assume columns of NVARCHAR, NTEXT, NCHAR, BIT, INT, DECIMAL, FLOAT, and DATETIME all must be ...
3
votes
0answers
100 views

Options to migrate large database from Sybase ASE to SQL Server with minimum downtime

The problem: Our server database contains 1TB of data. It runs on a Sybase ASE 15.7 server and shall be migrated to SQL Server 2014. The servers will be located in the same data center during ...
0
votes
1answer
45 views

Move data from 4 shard, replicated mongodb cluster to a single server without downtime

I need to move sharded data from four replica sets to a single remote machine without downtime. Can you describe the process step by step?
0
votes
0answers
49 views

MySQL performance issue after migration

I have a MySQL performance issue with a brand new server, and am somewhat of a beginner as a database administrator (I'm mostly a general-purpose Linux sysadmin). I'm looking for pointers where to ...
3
votes
1answer
66 views

Is replication a suitable method to move a SQL Server database to new hardware?

I need to move a live database with about 100 GB of data to a new machine. As I understand the easiest way to do that would be to take it offline, move the files and bring it back online. But: The ...
12
votes
2answers
495 views

Is there a penalty for using BINARY(16) instead of UNIQUEIDENTIFIER?

I've recently inherited a SQL Server database that uses BINARY(16) instead of UNIQUEIDENTIFIER to store Guids. It does this for everything including primary keys. Should I be concerned?
1
vote
1answer
162 views

Migrating from Oracle to MySQL via MySQL workbench: Table list is empty

MySQL workbench offers a migration tool that I'm using to migrate an Oracle database to MySQL. I'm using the migration wizard to migrate the complete Oracle schema to MySQL. I used that for the ...
1
vote
0answers
42 views

How do I disable constraint checking during schema migration?

How do I disable FOREIGN KEY checking for the time of database schema migration? Currently I found engine-based commands like: PostgreSQL: SET CONSTRAINTS ALL DEFERRED; MSSQL: EXEC ...
2
votes
1answer
33 views

Replace content of only one table with new version (should disable foreign keys?)

I have 2 tables. 2nd has foreign keys to reference 1st. I need to replace the whole content of the 1st table with the new version from another database. The new version satisfies all constraints and ...
0
votes
0answers
31 views

SQL Server 2000 Migration on Production [duplicate]

I have a couple databases on server1 and I want to put them on server2. Application is adding new data in every couple of minutes to databases on server1. I would like to not switch off application ...
27
votes
1answer
9k views

Best practices for schema changes and data migrations to a live database without downtime?

How do you make schema changes to a live database without downtime? For instance, lets say I have a PostgreSQL database with a table including various user data like email addresses etc, all ...
1
vote
1answer
39 views

Migrate Postgres from VM to VM

I have 2 VMs, both are identical in structural terms (came from the same snapshot, nothing installed, upgraded or removed). One VM is "clean", never used. The other VMs was heavily used and it has ...
2
votes
1answer
80 views

SQL Server Database Migration - Backup/Restore while Original DB still in Production

I have a very large DB in full recovery mode. My SQL Server is 2008 R2. The thing is that I need to migrate to a new server while having the original DB still in production. Both backup and restore ...
1
vote
0answers
50 views

How to speedup pg_dump big database

I've got big database (about 900GB), and when I migrate it to new server dump speed is not more than 2MB/s (very slow). Link between servers is 10Gb/s. The database contain 20 tables with different ...
63
votes
5answers
15k views

Are SQL Server in-place upgrades as ill advised as they used to be?

I have been working with SQL server on and off since SQL Server 6.5, the old advice that still rings in my head was never to do an in-place upgrade. I'm currently upgrading my 2008 R2 DEV and TEST ...
3
votes
1answer
44 views

How to handle Schedules when moving Jobs to another server?

We are migrating our SQL Server 2008 R2 to another physical server. For this, I will script out all jobs and run it on the target server. My question is about handling the schedules: When a job is ...
1
vote
1answer
164 views

Don't delete exist data with SSMA

I'm trying to use Microsoft's SQL Server Migration Assistant for Sybase 5.3 ('SSMA') to migrate multiple Sybase databases (that have the same schema) to a single MSSQL database. The first database ...
4
votes
3answers
2k views

Migrate SQL Server database to multiple files (shrinkfile emptyfile vs log shipping)

I have a SQL Server 2008 database in production that we are moving onto a new server. The current database has a single ~400GB .MDF file. The new server will be running SQL Server 2012, and we are ...
0
votes
0answers
26 views

Slony PostgreSQL replication from Chile to US (between datacenters)

We are moving from a datacenter in Chile to one in AWS (in USA). We've already moved most of our servers but the database (PostgreSQL). As the source server is in a VMWARE environment, we took a copy ...
0
votes
2answers
26 views

Migrating Pure PHP Site with Associated Database To New Server

First, let me say I'm not a DBA or network admin, but have moved large scale CMS websites from host to host. But, I have never moved a pure php coded database driven website from one host to another. ...
3
votes
1answer
55 views

MS SQL Server IP address change considerations

I am very new to MS SQL Server Administration and wants to learn on Migration of SQL Server in detail. We are in a Datacenter migration Project where the Windows server (SQL Server is residing in it) ...
3
votes
1answer
40 views

Agent shows disabled(although it is not) after migration

I am migrating our old server to a more reliable and powerful new server. SQL Server edition and build number stays the same (SQL Server 2008 R2 Standard). For this I followed the steps given in this ...
0
votes
1answer
134 views

Migrate/Export DB from Oracle 11g Enterprise to Oracle 11g Express

So I'm a DBA newbie and I've got an Oracle Enterprise server running in production with the following information under All Reports -> Data Dictionary Reports -> Version Banner, under ...
0
votes
2answers
91 views

Database Migration - Can it be this easy?

We have an old SQL Server 2008 server that needs to be replaced, and as the sole developer (and by extension DBA), I have been asked to figure out the best way to move the 5 databases to a new server. ...
0
votes
1answer
69 views

How to skip/ignore duplicate records on insert based on a generated string

I have hundreds of millions of rows in one table (snapshots_old) and I want to copy it to another table (snapshots), with one new column (snapshot_id) for which values will be generated while ...
6
votes
6answers
1k views

Move SQL Server 2008 database from machine A to B with no downtime

I got a bit of a problem. I have a SQL Server database in box A which has approximately 60gb of data. I need to move this to a new machine but I cannot have downtime at all. Every second that goes by ...
2
votes
1answer
51 views

Migrate a schema structure from one server to another MySQL

We have two Database environment server (Development and Production). Production DB is already being used in Production(means it already has production data etc.). My question is, is it possible to ...
3
votes
1answer
274 views

Migrating Oracle to MySQL: MySql Workbench Not Available

I am currently trying to migrate information from a query of a remote Oracle database to a local MySQL database. I have poked around and have found it has been frequently suggested to use the ...
0
votes
1answer
96 views

Microsoft SQL Server -> Postgres Data Migration

I have data in a Microsoft SQL Server that needs to be migrated to Postgres. The problem is that the SQL Server gets continuous updates and is hosted on our local net, while the Postgres instance is ...
0
votes
1answer
68 views

Migrating a database from one PostgreSQL server to another cleanly

I have a Rails app server that uses Postgres for the DB backend. I'm spinning up a new server and I want to get a clean and up to date copy of the database. I've tried it once so far while the ...
0
votes
0answers
33 views

Which would be a recommended approach for migrating a Postgresql database from one server to another?

We are moving out of our current dataserver based on Santiago, Chile to Amazon (AWS) in North Carolina, all other servers have been successfully migrated with no problem, but our "migration consultant ...
3
votes
2answers
1k views

Schema Migration: SQL Server Data Tools vs Liquibase and Flyway

This might seem like a stupid question, but I've been looking into open source solutions for schema migration, namely Liquibase and Flyway. However, my boss told me that SQL Server Data Tools (SSDT) ...
11
votes
2answers
3k views

Best way to migrate a huge SQL Server database with low downtime over network

Problem definition Our database server needs to be transferred to an other datacenter. It runs on Microsoft SQL Server 2012 Enterprise (64-bit) and contains two databases of about 2TB and 1TB. ...
0
votes
0answers
17 views

Temporary migration to a new server for firmware upgrade

I need to temporarily migrate an SSRS deployment to a new server so that I can perform a firmware upgrade on the server. Once the firmware upgrade has been completed, I will move SSRS back to its ...
0
votes
0answers
24 views

Data Base Migration - Adaptative Server Anywhere to Maria DB

I need to migrate a data base which is in my local computer to a on-line server. The RDBMS used in my local computer is Adaptative Server Anywhere 9.0.2.2451 while the RDBMS used on the server is ...
1
vote
1answer
47 views

Final steps of data center migration

Just to preface this, I am just a developer with some DBA experience but not an expert. We are migrating from one data-center to another. Basically we are doing this: Create a full copy of ...