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

learn more… | top users | synonyms

1
vote
0answers
26 views

How do I abstract a WHERE clause condition?

I'm wondering how a condition in a commonly used WHERE clause can be abstracted away so that it can be safely changed. Say I have data like ColA | ColB | ColC ================== 1 | 2 | ABC ...
1
vote
2answers
28 views

MYSQL to other DB migration using MYSQL workbench

is it possible to migrate MYSQL to other database platform like MS SQL 2012 using the MYSQL workbench migration wizard?. Everywhere the only destination DB is MYSQL, the reverse process is not ...
1
vote
1answer
66 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 ...
1
vote
0answers
26 views

why my data is not being sharded?

I am using mongo 2.6.7 I deploy a sharding cluster follow the guide: http://docs.mongodb.org/manual/tutorial/deploy-shard-cluster/ My sharding cluster include: - two replica sets (one primary + one ...
1
vote
0answers
49 views

Convert Teradata Database to SQL Server 2012 [closed]

I am just wondering if anyone has any experience, knowledge, or recommendations on migrating a Teradata database to SQL Server 2012. I have never worked with Teradata before so I am unfamiliar with ...
1
vote
0answers
243 views

SQL SERVER 2005 slow Performance on Windows Server 2008

Recently I have upgraded my server to new one. But because of compatibility issues with my old Windows Server 2003 R2 32 bit, I have also upgraded it to Windows Server 2008 R2 64 bit. (I have ...
1
vote
0answers
54 views

Migration error: “Invalid date literal detected” when reading decimal

I'm attempting a migration from MSSQL to MySQL and keep coming across a "Invalid date literal detected" error when reading certain decimal columns. I'm running the following (all up-to-date as of ...
1
vote
1answer
53 views

Find efficient way of migration 2TB GBK table in SybaseIQ to UTF-8 files

My project need to migrate more than 2TB raw data from SybaseIQ to another Database. SybaseIQ using GBK, the target Database using UTF-8, the target database can only load from UTF-8 files. We use ...
1
vote
1answer
154 views

Upgrading 8.1 to 9.3 - using statement log and WAL to check compatibility?

We're migrating from postgres 8.1 to 9.3, since we need streaming replication badly. All the application developers have deserted the company a long time ago, way before my time here, so there is ...
1
vote
0answers
154 views

Database Migration with Liquibase using different DBMS

Our customer is using Oracle and we want to use MySQL for development. Therefore our MySQL Scheme has to be in sync with Oracle. I tried to use Liquibase, but I get problems at the time of applying a ...
1
vote
0answers
50 views

How to tell if Database Certificate Used?

I plan to migrate a SQL Server database to another server. There is a certificate listed under the Security > Certificates view in SSMS Object Explorer. I ran the below query to check if database is ...
1
vote
0answers
116 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
59 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
95 views

How can I ensure a valid MySQL -> Postgres migration? [closed]

Our projects are migrating from MySQL to Postgres. We have a Ruby-on-Rails app that handles the schema (source code is on github). We have rewritten all queries to be ANSI-compliant. We have tried ...
1
vote
3answers
13k views

How to migrate Oracle database to MySQL server?

Currently our application is running using Oracle 11g database. We are developing newer version of the application which runs on MySQL cluster. We need to migrate the data from Oracle database to ...
1
vote
0answers
127 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
673 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! ...
1
vote
0answers
194 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
470 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
527 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
2answers
161 views

Migrating a database from SQL Server 2012 to the cloud [closed]

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
856 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 ...
1
vote
1answer
1k 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
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
0answers
906 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
116 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? ...
1
vote
0answers
507 views

Moving database to another SQL Server instance [closed]

I have an old database running on compatibility level 6.5 on a SQL Server 2005 instance. The support for compatibility level 6.5 has been deprecated as of 2005 and removed on 2008. The place where I ...
1
vote
3answers
202 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 ...
0
votes
2answers
2k views

Doing a comparison on two csv files with no Primary Key

I'm wondering if in SSIS there is a way to compare two csv files(with the same structure) with no reference key to make a record unique. To give you a better picture from what I mean; In initial load ...
0
votes
4answers
636 views

Can migration from MS Access to SQL Server or … make database faster? [closed]

A company asked me to migrate their database from MS Access to SQL Server or MySQL because they think that on those engines their database will run faster. But I wonder if their problem isn't because ...
0
votes
3answers
380 views

Sql Server 2012 Restoring Master and Migrating a server

I am migrating an entire SQL Server instance with 10 databases on it. It has many jobs and users. What is best practice regarding the master database? Should I backup and restore this too, or script ...
0
votes
1answer
1k 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 ...
0
votes
2answers
40 views

change column type from string to numeric

so I have a table with 5.2 million records. 3 columns in this table are for salaries. Those column are currently stored as string and I'd like to change the data type to numeric (I understood while ...
0
votes
2answers
52 views

Reinstall Oracle 11G2

Running Oracle 11GR2 instance (non-ASM). Plan to set it up again from the scratch(this time using ASM, Grid infrastructure). And I need the present database. I am thinking of the simple plan: 1) ...
0
votes
1answer
45 views

Need to migrate a SQL Server 6.5 Prod to SQL Server 2012 in VM

We are planning to move our SQL Server shop to VM(VMware). We still have one SQL Server 6.5 in production. What would be my course of action/path to move/migrate 6.5 to virtualized SS 2012? It's the ...
0
votes
1answer
382 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 ...
0
votes
1answer
45 views

improve long running query

I have this query INSERT INTO interactions( user_id, external_object_id, origin, interaction_type, interaction_sub_type, published_at, origin_id, created_at, updated_at) SELECT ...
0
votes
1answer
62 views

Oracle copy DB from one windows server to another

I am not an Oracle DBA but looking for the best approach to copy/clone an Oracle database from one windows server to another, here is my configuration and my requirements: Configuration Server 1 ...
0
votes
1answer
46 views

Restoring SQL Server 2000 database to SQL Server 2008

Is it necessary to restore system databases of SQL Server 2000 to SQL Server 2008, if I am restoring my other databases from 2000 to 2008?
0
votes
1answer
117 views

How To Migrate From MSDE 2000 to SQL Server 2008R2 Express

We need to migrate a MSDE 2000 database running on a Windows Server 2003 Standard to a Windows Server 2008 R2 running SQL Server 2008 R2 Express (fresh install). The database is small, about 300MB. ...
0
votes
1answer
28 views

Adding column to Postgres table fails

I have a Postgres (8.4.20) table that I'm supposed to add columns to, but it seems to have some problems that I have difficulties to debug: I'm attempting what I thought was a simple ALTER TABLE... ...
0
votes
1answer
766 views

SQL Server 2008R2 Migration to new Platform - What Steps Required?

We are migrating our SQL Server 2008R2 instance from one Windows Server platform to another. SQL Server will remain as 2008R2. The new plaform will have more disk space, memory and CPU. I am doing up ...
0
votes
2answers
4k views

SQL Server Reporting services migration (2008 to 2012)

We have a SSRS 2008 (not R2) instance with a few hundred reports, and now, on a new machine we have installed a 2012 instance of SSRS. We need to migrate all the reports, while keeping all their ...
0
votes
1answer
209 views

Postgres database dump and restore on different database [closed]

I have two Postgres databases on the same server, which have the same schemas. The goal is to have DB1 as the production and DB2, as the database that will receive all the data that is migrated from a ...
0
votes
1answer
80 views

Migration of MySQL to SQL Server

I need to migrate a MySQL database to SQL Server 2012. Found enough information about it -- looks like it can be done either with SSMA tool or via Data Import utility in SQL Server Management Studio. ...
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
49 views

Do I need to rebuild indexes when upgrading a DB from 2008 to 2012?

I can't find anything on BOL that indicates I need to rebuild indexes or statistics after the migration and compatibility level upgrade of a database. But I have read a few articles/answers around the ...
0
votes
1answer
46 views

Best Approach to Migrating Oracle to MySQL - Run on EC2 in AWS

I'm trying to migrate an Oracle schema as well as all of the data within the DB to a MySQL database. I want to then make an EC2 app on AWS to kick off whatever I've written for this. Are there any ...
0
votes
1answer
46 views

Backup/Restore Users/Passwords/Privileges

I am moving from one server to another and I want to backup all databases + users/privileges/passwords from my MySQL Server. I found to backup a database using mysqldump, but I cannot figure out, how ...
0
votes
2answers
65 views

In mongodb, is “sh.getBalancerState() is false” the same as “sh.isBanlancerRunning is false”?

During upgrading config servers to use WiredTIger, I stopped balancer using sh.setBalancerState(false), and then I run sh.getBalancerState(). The output is false. Does this mean the balancer is not ...