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

learn more… | top users | synonyms

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
787 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
584 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
880 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
3answers
12k 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
87 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
413 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 ...
1
vote
2answers
1k 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
145 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
1k 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
136 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 ...
4
votes
4answers
3k 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
352 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
112 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
122 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
241 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
200 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
224 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 ...
11
votes
7answers
25k 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
782 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 ...
2
votes
1answer
703 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
270 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
567 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
840 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 ...
4
votes
2answers
3k 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
269 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
3k 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
676 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 ...
3
votes
2answers
73 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 ...
54
votes
14answers
100k 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
1k 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
136 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
169 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
53 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
407 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
581 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
1k 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
143 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
986 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 ...
1
vote
0answers
748 views

Migrating from Oracle to MySQL using WorkBench Migration Tool

I am currently migrating from Oracle to MySQL and I am going to use the migration tool in workbench to help me with the procedure. I have entered my source connection details as follows: Database ...
2
votes
1answer
615 views

copy schema across different physical databases in db2

Is there any way to programatically copy across schema (i.e. tables,functions,views) etc from one database over to another one. Assuming both are running same versions of DB2. I found a few utilities ...
1
vote
1answer
106 views

Expanding contractions/number ranges into separate records [closed]

I am planning the migration of a directory of image files plus a FileMaker-database containing the corresponding metadata into an Imagic IMS database (formerly known as ImageAccess). The vendor ...
0
votes
1answer
481 views

oracle clob export/import across non linked instances

I'm trying to migrate table data across two instances(different instance schemas, but same table schema) that are not connected(not an option). The problem is that I can not access host file systems ...
2
votes
0answers
513 views

How much disk space needed for 100GB of DBs?

Hard to explain in the title, but I'm planning a migration from SQL Server 2000 databases to SQL Server 2008 R2. The databases are under 100GB total space, but this is only with the Simple recovery ...
1
vote
1answer
101 views

Migrating SQL Server 2008 R2 to new server

I need to migrate an instance of SQL Server 2008 R2 (20+ databases) to a new server this weekend. The new server is exactly the same as the old server in all respects, including SQL Server version ...
2
votes
2answers
125 views

Migrating SQL Server 2000 to SQL Server 2008

I'm migrating SQL Server 2000 to SQL Server 2008. I have many views. How do I check each views that if they have an order by clause? Thanks.
3
votes
1answer
344 views

Migrating development and production databases to AWS

After careful thinking and asking on meta.stackoverflow, I'm posting this question on the DBA site. If anyone thinks this question should be on serverfault or any other site, feel free to close and ...
5
votes
3answers
5k views

Fastest way to move a database from one server to another

I'm moving a single MySQL database (~10GB uncompressed) from one server to another on the same network. The current MySQL version is 5.1.41 and the new version is 5.5.24. The database contains both ...
8
votes
1answer
1k views

SQL Server 2000 to 2008 to 2012

We are migrating from SQL Server 2000 to 2008 now. We are making lot of changes to code, scripts because there has been a lot of change since 2000 to 2008. While making these changes, What I want to ...
3
votes
1answer
192 views

I need help to migrate denormalized table content to normalized form- MS Access

I have a staff database where we are storing information in Normalized form. There are 3 entity tables and 2 mapping tables connecting these with m-n relationships However, for ease of collecting ...