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

learn more… | top users | synonyms

0
votes
2answers
1k 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 ...
0
votes
1answer
38 views

Migration query taking time

I'm doing a migration from Oracle to SQL Server and, for one of the tables where we have 3 million records, it is taking a lot of time to complete. When I check the activity monitor, I can see the a ...
0
votes
1answer
68 views

Fastest way to migrate database to AlwaysOn cluster

I want to make the fastest migration plan to move a SQL Server database in simple recovery from a standalone server (SQL 2005) to a two node AlwaysOn cluster in full recovery. Some databases are ...
0
votes
1answer
67 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
1answer
156 views

NVARCHAR issue when migrating from SQL Server to MySQL with MySQL migration wizard

My issue is similar to this one but and I have tried what has been suggested but I still get the error. I have set the target column from VARCHAR(5120) to TEXT (tried LONGTEXT too) but the issue still ...
0
votes
1answer
36 views

Migrating database with views trough phpMyAdmin causes error in second host

I'm trying to migrate a database which contains some views and I'm doing trough phpMyAdmin export feature. MySQL version on servers are: Server to migrate: Server version: 5.5.34-0ubuntu0.12.04.1 ...
0
votes
1answer
500 views

Proper procedure for migrating a MySQL database to another Debian machine?

I have one server running an older Debian version with MySQL 5.x and a newer Debian server, also running MySQL. I've created a backup of all databases on the first server like so: mysqldump -uuser ...
-1
votes
1answer
282 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
0answers
196 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 ...
2
votes
0answers
414 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
0answers
42 views

How to limit the no of rows to copy in MySQL Workbench Data Migration

I am trying to migrate a huge MS SQL database to a MySQL database using MySQL Workbench. The source database is too big and i am only interested in 1000 records per table for migration. ...
1
vote
0answers
66 views

Moving a SQL Cluster to Another Data Center w/No Downtime

We have a two node SQL 2008 Enterprise cluster in a data center in California, and are looking to move hosts from a leased environment to a colo environment much closer to our home office. Our ...
1
vote
0answers
26 views

Migrating from SQL Server to IBM Filent P8

I am Newbie to IBM Filenet P8. I was trying to migrate my sample SQL Server database to IBM Filenet the other day and was stuck right at the beginning. I was just wondering FROM WHERE I SHOULD BEGIN. ...
1
vote
0answers
75 views

Migrate from Interbase to MySQL

I need to migrate a big database from Interbase to MySQL, I'd like to have suggestions about free and non-free tools to perform this task. I've found this one: ...
1
vote
0answers
126 views

How to upgrade MySQL 5.0 to 5.5 with master-master replication?

I have to update 2 hosts with SUSE Linux Enterprise 11 from SP2 to SP3 which implies an update from MySQL 5.0.94 to 5.5.31. The release notes state: SLE 11 SP3 introduces the upgrade of the MySQL ...
1
vote
0answers
325 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
vote
0answers
279 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 ...
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
0answers
660 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 ...
1
vote
0answers
96 views

migrations within transactions

I have a bash script to run migrations on our MySQL databases. Is it possible to wrap migrations within a single transaction when running multiple migration scripts from the command line? ...
0
votes
0answers
28 views

Migrate from mysql to oracle

I'm trying to migrate a db from mysql to oracle, I'm trying to follow the videos from the official page of oracle: Here! But I have a doubt, when I'm trying to do the step of "translate" I don't have ...
0
votes
0answers
45 views

MySQL migration to new hardware + upgrade + huge DB + windows

I am relatively new to DBA work and have a critical task in front of me, I really appreciate any detailed help you could offer. What I have a is a roughly 340 GB MySQL database on a Windows server. ...
0
votes
0answers
13 views

Reducing schema to shrink real-world data to a functional subset

I work with two editions of a shipping product; call them "A" and "B". Both use similar a database schema, but edition "B" has a strict super-set of the schema (and features) used for edition "A". ...
0
votes
0answers
54 views

Merge Similar Schema from one MySQL DB to Another

I have two databases (db1 and db2). db2 has all tables from db1 but not necessarily the same columns. I want to move any missing columns in db2 from tables in db1 but keep the rest unchanged. ...
0
votes
0answers
178 views

Importing data from Firebird to SQL Server 2008 R2 using ODBC

I need to import data from a source table in a FireBird database to SQL Server. Our network admin has created an ODBC connection to the FireBird database. I use SQL Import Data wizard to load data ...
0
votes
0answers
191 views

migrate APEX to a new database with newer APEX version?

what is the best approach to migrate an APEX app to a newer version of APEX (4.2.3) on a fresh installed database on a new server? is there any straightforward step by step? I never done that before! ...