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

learn more… | top users | synonyms

1
vote
1answer
127 views

Migrating a tablespace to a different database on the same ASM

How might one go about copying or moving tablespaces between databases that uses the same ASM instances? Might it be possible to cut some corners in RMAN or have ASM remap files belonging to a ...
1
vote
2answers
2k views

How can I synchronize data between two RDS MySQL databases

I have 2 Amazon RDS MySQL instances, one is MySql v5.5 and the new one is 5.6. I want to upgrade the 5.5 to the 5.6 but you cannot do upgrades at this time, so we are trying to migrate the data. I ...
1
vote
2answers
806 views

Moving data in multiple tables from old database to one table in new database [closed]

I have two SQL Server 2008 databases. One is for my old application (full of data) and the other is for a complete re-write of my application. I want to migrate the data, but I have no idea how to ...
8
votes
1answer
4k views

Upgrade SQL Server 2000 database to 2008 R2 and enable new features

I have recently upgraded SQL Server 2000 database to 2008 R2. What I did was: Shutdown SQL Server 2000 (express) service on old machine, Move datafiles (mydatabase.mdf and mydatabase.ldf) to new ...
3
votes
1answer
96 views

Migrating database live while being severely handicapped

I "inherited" a web application which is designed and implemented horribly (both the application and the database). For example, the main data is stored using a sort of emulated key-value storage in a ...
3
votes
0answers
192 views

Stubborn autovacuum process slow things dows

We are facing a strange problem since yesterday. In a database of ours there is a partitioned table containing historical data. That is, every week's data goes to a different partition and stays ...
1
vote
0answers
323 views

How do I convert unicode data from UTF-16LE to UTF-8 when migrating from SQL Server to MySQL?

Objective: Ensure existing Unicode (UTF-16LE) data is displayed the when moved to MySQL (UTF-8). Background: I'm migrating 1TB from SQL Server to MySQL. The current Collation in SS is ...
-1
votes
1answer
269 views

Problems migrate database from 4 to 5.5 mysql

I have a server with 4.0 mysql version innodb engine. I need to migrate to other server with 5.5 version (linux) ok I dump the full database using mysqldump, when i try to restore on the 5.5 ...
3
votes
2answers
1k views

What specific tests need to be performed under Database migration from DB2 to Oracle?

Currently I am going to be testing (I am a Data Analyst) of a larger migration project where they are planning to migrate from DB2 to Oracle. My question may be little broader; however any ...
2
votes
2answers
528 views

Tool to export data with all relational data?

Is there a tool to export data from selected rows in a table with all data stored in other tables in other tables linked by relational design? The purpose is to ease migrations of bits of data ...
0
votes
1answer
363 views

Moving MySQL Cold Backup to Another DB Server

I am new to MySQL and want to know the info whether taking a cold backup from source and copying it onto new server with same version require any additional configurations settings to be changed. As ...
1
vote
1answer
762 views

Alternative tools to export Oracle database to SQL Server? [closed]

I've got an Oracle database that I need to export (schema and data) to SQL Server. I am trying the Microsoft SQL Server Migration Assistant for Oracle, but it is horribly slow, grossly inefficient ...
1
vote
1answer
932 views

SQL Server to MySQL migration - how can I remove UCS-2 surrogate pairs in SQL Server?

I have been tasked with migrating a SQL Server 2005 database to MySQL 5.6 (these are both database servers runnig locally) and would really appreciate some help. -------Edit - Answered------- This ...
1
vote
3answers
10k views

How to migrate SQL Server to MySQL

I'm trying to migrate a SQL Server db to MySQL, and I'm having a tough time. I've tried: MySQLWorkbench -- migration tool fails because my login only shows views in SQL Server, not the tables ...
0
votes
1answer
82 views

Practices to keep SQL Server databases easy to port to MySQL?

We've developing an ASP.NET Web application that is to be designed for MS SQL Server 2008. I'd like to minimize my future dB admin's headaches should there be a need to migrating over to MySQL. With ...
0
votes
1answer
388 views

Converting a large SQL Server database to MySQL. Database corruption? Can't access data after transferring [closed]

I have gigabytes of tabular data stored in a SQL Server database. I've been trying to migrate it to MySQL using the Migration Toolkit from Oracle. I didn't have any mapping errors and fixed all the ...
3
votes
2answers
629 views

How do you migrate a database from SQL Server 2008 to MySQL?

I'm just getting into MySQL, so forgive me if this is a basic question. For my application I need to migrate my database from SQL Server 2008 R2 to MySQL. Is there any mechanism or technique or ...
1
vote
2answers
866 views

How can I migrate a sybase database to mysql? [closed]

I've been tasked with migrating a fairly complex legacy Sybase database into a MySQL database and I have no idea where to start. I can't use any off the shelf software, so I'm going to have to write ...
3
votes
2answers
121 views

Moving a database to a new server

My database server is being decommissioned at work. We have a new database server to take its place. Both servers have the same operating system and SQL Server 2008. I need to move all my databases ...
2
votes
1answer
711 views

Migrate / Copy Huge data from Oracle to SQL Server

I have huge tables in oracle database, appx 1 crore+ (10 million+) rows and want to migrate / copy those table and data in sql server. Currently I am using Import functionality of SQL Server for this ...
0
votes
3answers
121 views

Database migration, how to

I have two databases DB1 and DB2. In both databases exists this two tables mo_sms and mt_sms. This is the structure of those tables: CREATE TABLE IF NOT EXISTS `mo_sms` ( `id_MO` int(11) unsigned ...
3
votes
4answers
2k views

Open source tools for Oracle schema compares

I'm looking for an open source tool to generate DDL scripts. Many tools call these synchronization scripts. We essentially want to compare schema of different environments (ie: DEV to QA, QA to ...
1
vote
0answers
276 views

How do I safely import MySQL data in a directory to a running MariaDB server?

We're integrating another office into ours. That includes some of their data. I have a new installed MariaDB 5.5 server. The data dir = /home/data/MariaDB. I've done a new/fresh install into that ...
2
votes
2answers
84 views

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 ...
1
vote
2answers
114 views

Migrating a database from SQL Server 2012 to the cloud

I have a sample SQL Server database which is running on my computer. I have a cloud database account on AWS (free account). I want to migrate the database, with all tables, to the cloud. How can I do ...
1
vote
1answer
132 views

Migrating Oracle packages to SqlServer

I'm moving database from Oracle to SQLServer (2012 if that matters). The process of migrating tables/views is more or less straightforward and automated. Triggers are also not an issue since I don't ...
4
votes
3answers
180 views

Easiest Way to Move 100 Databases

I need to move about 150 databases from one server to another server. SQL Server 2008 Web Edition SQL Server 2012 Preview (in a different datacenter - East Coast Azure) I was planning on moving ...
0
votes
2answers
155 views

Update primary SQL Server in mirrored environment using transaction logs from old environment

I'm currently migrating a large (~40gb) database to a new environment. The new environment is a HA/mirrored set up with primary, mirror and witness nodes. I'm backing up the database in the old ...
10
votes
7answers
22k views

Moving tables to another SQL2008 database (including indexes, triggers, etc.)

I need to move a whole bunch (100+) of large (millions of rows) tables from one SQL2008 database to another. I originally just used the Import/Export Wizard, but all the destination tables were ...
4
votes
2answers
525 views

What is the best way to migrate multiple databases?

I want to migrate my database server to a new server. Right now I have a database server with Windows Server 2008 and now I am migrating to a new, separate server with Windows Server 2012. There are ...
1
vote
1answer
504 views

Convert Oracle database to Derby

I need to migrate an existing Oracle Database into a Derby one. I want to know if there's a tool, a script or another way to do that work. It is using any of the interesting features of Oracle, as I ...
5
votes
1answer
266 views

Migrating MySQL to new server

We have a MySQL 5.1 instance running on Windows Server 2008 R2 x64 (Server A) replicated to another MySQL 5.1 instance on Windows Server 2003 R2 (Server B). We have a new MySQL 5.5 instance on ...
2
votes
2answers
417 views

Can I open a SQL Server 2008 R2 database in SQL Server 2008 R2 Express?

This question has probably been asked a dozen times but I couldn't find them here or at SO. Can I attach/restore a SQL Server 2008 R2 database to my local SQL 2008 R2 Express instance?
1
vote
1answer
606 views

Full-text search migration 2005 -> 2012 (.ndf file?)

So I'm trying to figure out the details for migrating from SQL Server 2005 to SQL Server 2012. I tried to do restore and backup of a DB from 2005 to 2012. This worked well and for the text search ...
3
votes
2answers
2k views

Is it okay to use rsync on InnoDB database if the MySQL server is shutdown?

Is it okay to use rsync on InnoDB database if the MySQL server is shutdown ? For example : /etc/init.d/mysql stop rsync -av /home/mysql/mydb/ root@newserver.com:/home/mysql
0
votes
1answer
199 views

DR - Moving databases from Active/Active cluster to Standalone server with LUN sync

We have an active/active cluster on LUNs (with one named instance on each node and a total of an 100 DBs) For DR purpose, LUNs will be replicated (with same drive letters) and attached to a ...
2
votes
1answer
2k views

Migrating from SQL Server 2005 to SQL Server 2008 R2 on a different box

We currently have a SQL Server 2005 instance hosting a lot of application specific databases (ArchiveManager, SolarWinds, Kaspersky etc). We are planning to deploy a new SQL Server 2008 R2 instance on ...
1
vote
1answer
542 views

Oracle Forms 10g to 11g migration Error

I having problems from first steps, while migrating Oracle Forms from 10g to 11g. Some of libraries dose not want to compile. the compiler just hangs up when I try to compile them, and Forms builder ...
10
votes
4answers
4k views

Tools to migrate from SQLite to PostgreSQL

I need to continuously migrate from SQLite to PostgreSQL. By continuously, I mean that I will reimport the SQLite database into PostgreSQL every day. It would be nice if I could make changes to the ...
3
votes
2answers
72 views

SQL Server migrations go through client machine or not?

I want to migrate a SQL Server db on one machine to another machine. Both machines are remote. If I run the Copy Database wizard, will it pull all the data across the Internet to my client machine and ...
49
votes
14answers
87k views

How can I move a database from one server to another?

How can I move MySQL tables from one physical server to another? Such as this exact scenario: I have a MySQL server that uses innodb table and is about 20GB size. I want to move it to a new server, ...
3
votes
2answers
907 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 ...
4
votes
2answers
118 views

SQL Server 2005 Database move and rationalisation - Recommended maintenance processes

We're moving a SQL Server 2005 database to a new server and upgrading to 2008, and I'm looking for some advice and reassurance that our approach is correct. I inherited this database and it came to ...
2
votes
1answer
118 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. ...
1
vote
0answers
49 views

Migration advice from SQL server 2000 bak

A small and old Windows 2003 server, just crashed; from the backup only the .bak files are available. A new server will be built, however, as the database is very small (20MB) and the Windows server ...
1
vote
1answer
345 views

SSMS Oracle import using OpenQuery over LinkedServer (Oracle Provider for OLEDB) - XML Parsing: unable to switch encoding

I am trying to migrate the data from an OracleDB to an SQL Server Express database. I'm doing this by openquerying a linked server (data provider based on Oracle Provider for OLEDB). Everything works ...
3
votes
1answer
519 views

SQL Server to Oracle Export - Data conversion error

I have a rather weird problem with exporting a bunch of tables from SQL Server 2005 to Oracle database. I have SQL Agent job that deletes Oracle tables, recreates them and then exports the data using ...
3
votes
2answers
761 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 ...
1
vote
4answers
131 views

Transfer selected information from a SQL Server business server to a MySQL web server?

I have a SQL Server dedicated server used for business information on service users etc, and a VPN with MySQL for the main website operation. I wish to transfer some selected tables from SQL Server to ...
0
votes
1answer
741 views

Moving data between Oracle and PostgreSQL

For a future project I need to use the following setup: Some small (offline) data boxes (colleting data over the time) fill PostgreSQL databases. (Summing up to about 1 TB a year. For time to time, I ...