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

learn more… | top users | synonyms

0
votes
1answer
43 views

PostgreSQL migrate data from one table to another (which inherits the first one)

I have a table "company" and another named "school" ("school" table inherits "company"). Most of the data is community generated and sometimes a cleaning is needed. I would like to be able to ...
0
votes
2answers
23 views

SSRS Migration To a separate Network

We are building a new SSRS 2008R2 environment on a separate network. How can I migrate the reports from our current network to the new network? Can I backup the reports from the existing SSRS server ...
0
votes
1answer
42 views

How to do Mysql migration from 5.0 (320bit windows) to 5.6 (64 bit windows)?

I want migrate My Mysql 5.0 windows 32 bit to Mysql 5.6 Windows 64 bit? Please suggest me the best way to do migration, i have around 10gb of data present in Mysql 5.0.
0
votes
1answer
165 views

Data Migration or Sharded Cluster to new Cluster

We have Sharded Mongo Cluster. However some documents are sharded and others are unsharded. We are planning to migrate these databases to new cluster. Please update if there is any process or steps ...
0
votes
1answer
66 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
31 views

SQL Server 2005 Whole-Migration, which databases should I recreate?

In relation to my question about SQL Server 2005 migration procedure, I am re-creating the databases on the new server. I noted that the old server has the following databases (outside of System ...
0
votes
1answer
874 views

migration from mysql 4.1.0 to mysql5.6.2

I have been trying to backup data with structure from my old legacy server to my local server for modifications. PhpMyAdmin timed out at the time of export, MySQL Workbench has performed connections ...
0
votes
1answer
180 views

Looking for suggestions to Migrate Amazon RDS Large Instance to non-amazon host - Live

We have an Amazon RDS Large instance with a database of about 20GB that needs to be migrated without having to take our website down or minimize downtime to less than a couple of hours. And I am ...
0
votes
1answer
1k 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 ...
0
votes
3answers
146 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 ...
0
votes
1answer
440 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 ...
0
votes
1answer
493 views

Tools for synchronizing database schema with Oracle, SQL-Server and Netezza databases [closed]

I'm looking for software tools to move database schema for Oracle, SQL Server and Netezza. We use Oracle for our ODS, Netezza for our Data Warehouse (for it's bulk loading capabilities) and SQL ...
0
votes
2answers
1k views

DBCC CHECKDB errors migrating from SQL Server 2000 to SQL Server 2008R2

I'm getting integrity issues after I migrate a DB from SQL Server 2000 to SQL Server 2008 R2. I ran a DBCC CHECKDB on the old db, and it returned no issues. Then I FTP-ed the backup file to the new ...
0
votes
1answer
34 views

Adding columns & index to a huge table

I'm working with a Rails app backed by a MySQL database. One of the more-frequently used models is backed by a table with over 200,000,000 rows (and growing). We've been aware for a while that the way ...
0
votes
1answer
13 views

Entity Framework: Automatic migration failed on huge DB

I am using EF 6.1.1, and DB has three million records and migration has to change the precision of a coulumn of type decimal. And the migration timeout window set to max value, CommandTimeout = ...
0
votes
0answers
32 views

how to migrate data between two distincts tables

I have a database with millions of records in a table users. I need to collect this data, tranform to a new format (removing a field, for example) and save it to another database. I'm currently doing ...
0
votes
0answers
41 views

Moving Database SQL Server 2012 to 2008/R2 [duplicate]

I'm planning to move a Large Database from SQL Server 2012 to 2008/R2. I tried the scripting thing, it works on a small-medium type of database but not on Large database w/c is about a hundred MB. Any ...
0
votes
0answers
19 views

Postgres: Migrate data with FKs to multi-database

I currently have a single DB with data from a number of clients. I have been tasked with writing a script that splits the data up into separate DBs per client (each DB will have the same schema). For ...
0
votes
1answer
47 views

Strategies to import big data into oracle

Which strategies are available to import very larg amount of data from an external system which is delivering about 500 million small transactions every day? Oracle becomes very slow with high ...
0
votes
1answer
31 views

Migrate MySQL 3.23 Data

I have .FRM, .MYD and .MYI files from a MySQL (version 3.23 I think) database from back in the early 2000's. I managed to get the files into a Windows installation of 3.23 and then dump it, however I ...
0
votes
1answer
24 views

Migrating from 32 bit using pg_basebackup

Has anyone migrated a 32 bit postgres 9.2 database to a 64 bit postgres 9.2? I'm trying to use pg_basebackup but I'm not sure whether this is the right approach.
0
votes
0answers
27 views

SQL Server to Oracle migration

Converted model resulted into incomplete script generation as all stored procedures, triggers and views were missing, only table structures were generated and i did not get any error messages for it. ...
0
votes
0answers
17 views

Moving Replicated & Partitioned SQL2005 Enterprise to SQL 2008R2 Enterprise

Our SQL2005 Enterprise has 4 databases which are all partitioned, each have 5 files and a handful of tables replicated, compatibility mode is 90. They are on an old Windows Server 2003 32bit machine ...
0
votes
1answer
87 views

What's the fastest way to migrate an Oracle database from Unix to Linux?

We have an Oracle database installed on AIX 7.1, and now we want to migrate our database instance to RedHat 6.2. The RedHat server has Oracle 11.2 installed already. What's the fastest way to ...
0
votes
1answer
72 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
70 views

Postgresql 9.1 PITR file system base backup - do I need to stop database?

I am preparing for a migration of a big database to another server and plan to use WAL archiving and Point-In-Time-Recovery to minimize downtime. After reading the documentation I learned I have to do ...
0
votes
0answers
17 views

mysql Migrating large amount of data times out

I'm a beginner with manipulating db's. I'm trying to migrate (about 70,000) posts from a Drupal setup to Wordpress on my localhost machine and it appears to be timing out, either constantly staying ...
0
votes
1answer
48 views

migrating legacy databases from SQL Server 2000 via SQL Server 2008 to SQL Server 2012: users and logins

I have some legacy SQL Server 2000 databases to migrate to SQL Server 2012. In my dry run, I have done this: I created empty databases of the same names in SQL Server 2008. Then I backed up the SQL ...
0
votes
1answer
86 views

Restoring a database using Postgres data files instead of .sql files

I backed up my Ubuntu 14.04 system using rsync to a USB stick, but apparently it wasn't formatted for booting. The original disk has been erased and I put a fresh install of Ubuntu on it. In migrating ...
0
votes
0answers
34 views

SSMA mysql double to sqlserver decimal, decimals getting cut off

I have a field that is a (signed) double in mysql, and I want it to be a decimal(18,4) in sqlserver. I have changed the Type Mapping for Source Types double and double precision to decimal[18][4] in ...
0
votes
0answers
21 views

Simple way to migrate application SQL database into an archive database?

I'm not super technically oriented. I've used SQL for many years, but primarily operating within databases and not so much managing them in total. Anyway, we have an application we're getting rid of, ...
0
votes
0answers
34 views

MySQL: migration huge tables between two databases

Hello guys (and sorry for my English). I have 2 DB's - DB1 (staging) and DB2 (production), each day some contend added/changed in some tables in DB1 and should be moved to DB2. Right now it works ...
0
votes
2answers
283 views

Creating a MySQL db from an Informix database

There is an existing database that was created in Informix. I would like to export it and then import it into MySQL. I tried to export it using dbschema and it created the dbase.sql file and several ...
0
votes
0answers
55 views

Using Configuration Management for DBA tasks?

We have a couple of Postgres 9.3 database servers in our system, all of them with their respective config files, databases, roles, role groups, permissions on schema/tables, extensions etc. We use ...
0
votes
0answers
39 views

Books on mongodb data migration

Thanks for reading this post. I have no db/dba background and just started evaluating mongodb for our project. Could someone share experiences of migration data in mongodb? for example, today's ...
0
votes
0answers
101 views

How to migrate a mysql server in production to Percona XtraDB Cluster

I need some help : I have a mysql server in production and i want to migrate all the database to an existing cluster (percona xtradb). For now , my idea is : 1) Lock all tables 2) do a dump per ...
0
votes
0answers
369 views

SQL Server to MySQL migration using MySQL workbench

I tried to migrate database from SQL Server 2012 to MySQL v5.5. I used MySQL workbench v6.1 community edition. What I was migrating is just schema only, not for the data. I got this error Reverse ...
0
votes
0answers
88 views

Migrate Linked Server Connections

I am getting ready to migrate a DB from one server to a new machine...but were wondering if there is an easy way to migrate those connections over as well...we have about 6-7 linked servers set up to ...
0
votes
1answer
61 views

mysql hardware refresh + version upgrade

currently I am running MySQL 5.0.80 on windows server 2003 (x64), 64gb memory, I have a master and 2 slaves. It's a large 400 gb Database. I am setting up all new hardware (SAN + dedicated MySQL ...
0
votes
1answer
60 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 ...
0
votes
1answer
56 views

Extra column when migrating Sybase databases to single SQL Server database

I'm trying to use Microsoft's SQL Server Migration Assistant for Sybase ('SSMA') to migrate multiple Sybase databases (that have the same schema) to a single SQL Server database. All of the tables in ...
0
votes
1answer
97 views

MS Access migration from Oracle to SQL server?

Let me start off by saying I'm relatively new to databases etc. I have been asked to undergo a project is which I will attempt to migrate about 100 or so existing MS access 2003 databases from using ...
0
votes
1answer
141 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
806 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
0answers
33 views

Post Database upgrade on new instance [duplicate]

I reviewed the SQL Server 2012 technical upgrade guide and also googled for more recommendations. I am migrating a SQL Server 2008 R2 instance to SQL Server 2012 on a separate machine. Here is what ...
0
votes
0answers
151 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
1answer
46 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
2answers
309 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 ...
0
votes
2answers
2k 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
643 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 ...