the process of moving databases or data from one place to another
2
votes
1answer
1k views
How do I have RMAN treat my restored data files like they are originals?
I am planning a migration for this ancient-but-critical Oracle database from one Windows Server 2003 cluster to another.
The database has many data files and they are all getting new paths on the ...
2
votes
2answers
487 views
Attach database from SQL Express 2008 Edition to SQL Server 2008 Enterprise Edition
My friend is stuck on moving a database stored in SQL Express 2008 Edition in a server (called server A) to SQL Server 2008 Enterprise Edition in another one (called server B). There are two SQL 2008 ...
2
votes
2answers
160 views
Validate and Verify Data After SAN Migration
We are preparing to migrate to a new SAN and I have been tasked with verifying/validating data after migrating a server.
Other than the DBCC commands that would tell me about data integrity, and ...
2
votes
1answer
45 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.
...
2
votes
1answer
143 views
ETA: translate Oracle SQL queries to MySQL
task: replace Oracle 11g with MySQL
current setup:
Oracle 11g SE One
about 80 tables
stored procedures, PL/SQL are in place but out of scope for this question
client applications do not use a ...
2
votes
1answer
1k views
Migration from DB2 to MySQL
Does any one have experience on migration from DB2 to MySQL ?
Please share with me.
I tried googling, but I have not received much information on this.
2
votes
1answer
204 views
Migrating database from SQL Server 2005 Enterprise to SQL Server 2008 Standard
I'm attempting to migrate a database from SQL Server 2005 Enterprise to SQL Server 2008 Standard. I've run into an issue because there is a partition function defined in the database of the Enterprise ...
2
votes
1answer
250 views
.NET SQL Server Authentication Schema issue
I am currently working on a project for a client. The application is written in ASP.NET C#. The Database used is SQL Server 2008. The project has been to migrate the old Oracle database to a new SQL ...
2
votes
2answers
396 views
php/mysql database redesign and migration: changing databases to tables
I wrongly designed my application to have one database to each user. each user had 3 similar tables. I now want to have one database and 3 tables only; where i will use the database name in the old ...
2
votes
1answer
215 views
Oracle to PostgreSQL
I'm having som test databases running Oracle 10 & 11 that I plan to try to migrate to PostgreSQL.
Some googling hinted that the perl script "ora2pg" could be of use, and free of charge. However, ...
2
votes
1answer
380 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 ...
2
votes
1answer
696 views
How to migrate data from Google AppEngine Datastore
How to migrate data from Google AppEngine's Datastore to other database (not Datastore)?
There is appcfg.py download_data but it produces sqlite3 file with empty bulkloader_database_signature and ...
2
votes
0answers
165 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
2answers
406 views
Oracle Procedure to Enable/Disable all constraints
I have this nice piece of code:
begin
for i in
(
select constraint_name, table_name
from user_constraints
where constraint_type ='R'
and status = 'ENABLED'
) LOOP
execute immediate ...
1
vote
2answers
74 views
How can I append a column to an inner SQL statement?
I have two tables that have the same structure except one has an additional column that should be auto-incremented. Sequence and trigger are defined.
I want to copy all data from one table to ...
1
vote
2answers
119 views
Workload analysis before migration
Does anybody have a recommendation on which performance counters to collect and/or templates to use on the profiler before migrating SQL databases? The purpose is to evaluate the workload and make ...
1
vote
1answer
448 views
How do Savepoints work in Oracle?
I'm doing pretty serious operations on my DB and I would like to keep my data safe.
Unfortunately something is going wrong, look:
SAVEPOINT before_foo_update;
CREATE TABLE AUX_FOO as
SELECT * ...
1
vote
1answer
300 views
Ms Access queries equivalent in Sql Server
Queries in MS Access can act like views do in oracle in that you can query against them. Example: if you have a query in access called allProducts, you can also do
SELECT * from allProducts;
My ...
1
vote
2answers
113 views
How can I migrate a sybase database to mysql?
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 ...
1
vote
2answers
206 views
PostgreSQL Database Migration
How can I migrate data from on PostgreSQL database to another PostgreSQL database? Is there any technique to migrate data with SQL scripting?
1
vote
1answer
29 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 ...
1
vote
3answers
52 views
Transfer data from DB2 to Oracle
I want to transfer data from an old DB2 system to a new Oracle database.
How should I go about doing this?
1
vote
1answer
53 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 ...
1
vote
2answers
570 views
Move an Oracle database by moving the raw data files
I have a large Oracle database (~300 GB) and I need to move a copy of the database to a new environment in a short period of time. I was wondering if there is a way to just pick up the raw files ...
1
vote
1answer
86 views
Migrate Data and/or Schema from DBv1 to DBv2
I have a production database which has been plugging away for several months. I have been making modifications to a duplicate copy on a test/dev server. I've added some additional fields (null ...
1
vote
1answer
104 views
I need help migrating data through databases
i've a web page with some data about the users. Recently I made a complete change and start developing a new portal and of course a new DB structure. My question is what's the best way to migrate my ...
1
vote
1answer
194 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
4answers
90 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 ...
1
vote
1answer
87 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 ...
1
vote
1answer
428 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 ...
1
vote
1answer
569 views
New SQL instance and migration
What are the best practices of creating new SQL Server instance on SQL Server Clustering 2008 R2 and migrating a database with high transactions?
1
vote
1answer
237 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 ...
1
vote
1answer
87 views
What should be checked after an Oracle migration
After a large data migration, what needs to be checked to be confident that the data move has succeeded?
the number of tables and rows in each schema is the same.
the text data in the tables has ...
1
vote
1answer
56 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 ...
1
vote
2answers
147 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 ...
1
vote
1answer
124 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
230 views
Alternative tools to export Oracle database to SQL Server?
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
44 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
265 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
65 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
307 views
Moving database to another SQL Server instance
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 ...
0
votes
2answers
546 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
1answer
175 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
1answer
51 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
89 views
Help me convert SQL statement to MySQL
I have an application called Moodle version 1.9 and was migrated from Windows platform and Microsoft SQL Server to Linux and MySQL.
Now, when I click save changes the SQL query statement from Custom ...
0
votes
1answer
64 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
2answers
172 views
Migrate DB2 UDB (Iseries) to SQL Server
I'm looking for a tools that allows migration of DB2/UDB databases to SQL Server.
It's quite easy migrate schema and data using linked server or import export with SISS.
But what about stored ...
0
votes
1answer
286 views
Converting a large SQL Server database to MySQL. Database corruption? Can't access data after transferring
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
212 views
Tools for synchronizing database schema with Oracle, SQL-Server and Netezza databases
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
642 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 ...
