the process of moving databases or data from one place to another
0
votes
1answer
46 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
26 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 ...
0
votes
1answer
150 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
vote
1answer
32 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
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
1answer
232 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 ...
2
votes
2answers
54 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
1
vote
3answers
55 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?
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 ...
1
vote
2answers
150 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 ...
7
votes
8answers
16k 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 ...
5
votes
0answers
214 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
1answer
95 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
125 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 ...
9
votes
4answers
2k views
Tools to migrate from SQLite to PostgreSQL
I need to continuously migrate from SQLite to PostgreSQL. By continuously, I mean that I will reimport the SQLite database into PostgreSQL every day. It would be nice if I could make changes to the ...
3
votes
2answers
44 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 ...
1
vote
2answers
116 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 ...
34
votes
14answers
48k 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, ...
1
vote
1answer
195 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 ...
3
votes
2answers
196 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 ...
3
votes
2answers
70 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
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.
...
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
1answer
240 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
301 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
244 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
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 ...
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 ...
1
vote
0answers
270 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 ...
0
votes
2answers
173 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 ...
2
votes
1answer
381 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 ...
0
votes
0answers
28 views
tools and ETLs for migrating data benchmarking - from shapefile to SQL SERVER
i need to migrate my shapefiles to my database SQL SERVER, and i don't know what's the best tool or ETLs to choose, i already tried FME Desktop and i succeded to load the shapefiles on my db, but ...
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 ...
0
votes
1answer
175 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
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
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 ...
2
votes
2answers
98 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
106 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 ...
3
votes
1answer
142 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 ...
4
votes
3answers
2k 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 ...
6
votes
1answer
203 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 ...
25
votes
2answers
2k views
Are SQL Server in-place upgrades as ill advised as they used to be?
I have been working with SQL server on and off since SQL Server 6.5, the old advice that still rings in my head was never to do an in-place upgrade.
I'm currently upgrading my 2008 R2 DEV and TEST ...
3
votes
1answer
102 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 ...
3
votes
1answer
504 views
Generate insert statements for table AND related data
I'm looking to move data from tables and related tables between 2 databases. The trouble is the primary keys are out of sync.
Is anyone aware of a tool which can generate insert statements for a ...
3
votes
1answer
271 views
“Zero” downtime and minimal space requirements for upgrade to PostgreSQL 9.2
Need to migrate from PostgreSQL 8.3.x to 9.2
Constraint 1: 8.4 and above have made datetime format to be integer by default. Wasn't so in 8.3.x. As a result pg_upgrade can't be used. Unless server is ...
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 ...
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
2answers
409 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
1answer
454 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 * ...
