the process of moving databases or data from one place to another
34
votes
14answers
51k 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, ...
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 ...
15
votes
4answers
481 views
What is your workflow for planning a data migration?
So many times I've been brought in at the end of a software development effort and been told something like "okay, we've got all this new code and it requires tables to change and data to be ...
13
votes
7answers
25k views
Need to migrate SQL Server to MySQL
I have a database on SQL Server 2008 on a Windows server and I want to move all of the data to a MySQL database on a Ubuntu server. I have tried using the SQL Server Import and Export Wizard with the ...
12
votes
1answer
2k views
Best practices for schema changes and data migrations to a live database without downtime?
How do you make schema changes to a live database without downtime?
For instance, lets say I have a PostgreSQL database with a table including various user data like email addresses etc, all ...
11
votes
3answers
826 views
Should I migrate data using detach/copy/attach or through backup-restore-replay?
I am about to embark on migrating database files to a new SAN (from an old SAN) abd I have a couple of options to implement this. (1) It was suggested that I look into the level of effort of restoring ...
9
votes
7answers
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 ...
9
votes
2answers
459 views
A Non-DBA Asks: How to Painlessly Copy/Move a SQL Server instance to another Server via Backup/Restore?
We've just got a new server so I need to copy the existing SQL Server 2008 instance over from the old db box.
I normally do this by copying .mdf and log files over and attaching them but I'm not able ...
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 ...
7
votes
1answer
2k views
How to migrate large blob table from mysql to postgresql?
I'm now in process of migrating my MySQL database to PostgreSQL. Almost everything went fine (well, after lots of googling for correct mysqldump params etc.) except one table I have - actually the ...
7
votes
2answers
1k views
How to migrate SQL Server Stored Procedures using temporary tables or table variables to Oracle?
C# developer encouraged by management to write SQL Server stored procedures often produce procedures like this
create table #t1 (...);
insert into #t1 Select ... from table_a where ...;
insert into ...
6
votes
1answer
220 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 ...
5
votes
2answers
517 views
Save postgres database from broken ubuntu 10.04 server
Recently a database server with an important db broke (some grub linux issue that I'd prefer not to solve).
I can still access the filesystem. Is there a chance to transfer the database by only ...
5
votes
3answers
215 views
Import 2 column CSV files to some sort of DB… preliminary planning
Every day I have a CSV file generated by a script. It has two columns. Column 1 is a name, column 2 is the size of their mailbox.
I have a years worth of these files. I would like to be able to ...
5
votes
4answers
94 views
Syncing Database for Server Transition
I'm transitioning from an old web/sql box combined to a much more robust solution on a completely different host (800hosting to RackSpace).
Our application has very high uptime requirements. It runs ...
5
votes
1answer
226 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 ...
5
votes
1answer
202 views
bcp database migration
I want one server to migrate the database to another server. On another server database already exists, then ist all the tables, but they are empty and I want to fill. For the filling, I want to use ...
4
votes
1answer
184 views
Migrating large database
What is a quick way of migrating 75G database to the cluster? I tried to test the backup and restore and it took more than 2 hrs. Business owners won't accept the long outage. Any idea how I can make ...
4
votes
2answers
55 views
What is the best way to migrate multiple databases?
I want to migrate my database server to a new server. Right now I have a database server with Windows Server 2008 and now I am migrating to a new, separate server with Windows Server 2012.
There are ...
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 ...
4
votes
1answer
3k views
Migrating from one SQL Server 2008 R2 instance to another
I just started a new dba job and have been given a new server and told to move everything from the old server to the new one, brand new windows and SQL Server installations. I know I have to transfer ...
4
votes
2answers
6k views
How to solve UTF8 invalid byte sequence copy errors on a restore, when the source database is encoded in UTF8?
I was given the task to migrate a PostgreSQL 8.2.x database to another server. To do this I'm using the pgAdmin 1.12.2 (on Ubuntu 11.04 by the way) and using the Backup and Restore using the ...
3
votes
2answers
3k views
How to migrate from SQL Server 2000 to SQL Server 2008 R2 Express Edition
I have been trying to migrate a database from SQL Server 2000 (part of SBS 2003) to SQL Server 2008 R2 Express Edition
I naively tried using the SQL Server Export and Import wizard. This has worked ...
3
votes
2answers
537 views
Should I move to InnoDB during a planned migration?
I'm shortly migrating a Debian Lenny webserver to another host and Debian Squeeze. The standard MySQL installation even on Squeeze is 5.1 and therefore would default to MyISAM - I'm inclined to stick ...
3
votes
2answers
47 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 ...
3
votes
2answers
72 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 ...
3
votes
1answer
2k views
What happens when you modify (reduce) a column's length?
Lets say I have two columns of type NUMBER (without precision, and scale) and VARCHAR(300). I saw that these columns are way too large for my data, so I want to modify them to NUMBER(11) and ...
3
votes
2answers
166 views
Migrating and normalizing data
We are rewriting a large Django application which uses a MySQL database, and the database schema needs to undergo major modifications. We're also porting the app to use PostgreSQL, for a couple of ...
3
votes
1answer
161 views
Managing schema changes between transactional and analytical databases
How would you manage changes in a transactional database that affect an analytical database?
Environment:
Transactional database is a current, or near current version of MySQL. Size of the ...
3
votes
1answer
172 views
DB2 Express-C 10.1 database move to DB2 Work group Server/Enterprise Edition
I have not done such migration before and I want to know if I am going to face such issues when moving my database (tables,views,table-spaces,functions,procedures,etc.) to other DB2 distribution.
If ...
3
votes
2answers
642 views
Character Set Database Migration
This is a follow-up question to a previous thread I had posted. We're in the process of migrating to a new character set. Now, I am a programmer and we have DBA's who will be performing the work but ...
3
votes
2answers
241 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
1answer
304 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 ...
3
votes
1answer
111 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
148 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 ...
3
votes
1answer
104 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
551 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
314 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
1answer
222 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, ...
3
votes
2answers
346 views
How do you migrate a database from SQL Server 2008 to MySQL?
I'm just getting into MySQL, so forgive me if this is a basic question. For my application I need to migrate my database from SQL Server 2008 R2 to MySQL.
Is there any mechanism or technique or ...
3
votes
1answer
340 views
Error moving SQL Server 2000 to SQL Server 2005 NOLOCK Error
I need to move a database from the SQL Server 2000 (32 bit) to SQL Server 2005.But,When I attacted my database to SQL Server 2005,it's gives me error.(NOLOCK error)
Also , After I running dbcc check ...
3
votes
2answers
256 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 ...
2
votes
4answers
2k views
SQL Server 2008 R2 Ent trial expired move to express?
So someone let our SQL server 2008 R2 enterprise trial expire on a web server. It was part of a plan to restart a project and move everything we had over to MySql instead. We don't need anything ...
2
votes
2answers
118 views
Can I open a SQL Server 2008 R2 database in SQL Server 2008 R2 Express?
This question has probably been asked a dozen times but I couldn't find them here or at SO.
Can I attach/restore a SQL Server 2008 R2 database to my local SQL 2008 R2 Express instance?
2
votes
3answers
279 views
Huge Data Migration in Oracle and space concerns
I am trying to do Insert append as part of data migration from SchemaA.table1 to SchemaB.table2 in the same Oracle database. Due to refactoring of Table2, there will be some form of data ...
2
votes
3answers
657 views
Migrating from ntext to NVARCHAR(MAX)
I have table with the columns of type ntext.And for some peculiar reasons, client want to migrate the column type to NVARCHAR(MAX).
While doing so , what all potential threat should i be careful ...
2
votes
2answers
87 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
2
votes
1answer
193 views
Data migration between databases in the same instance
I have two almost identical (structurally) databases:
Documents
DocumentsOld
The original database existed before table partitioning was available, so the solution they found was to create the ...
2
votes
2answers
428 views
Logical schema development and migration tool for different physical schema available including triggers and stored procedures?
We are planning to support for our application another rdbms (oracle).
At the moment we are design our database schema with the MySQL-Workbench. For every new database version we have
schema ...
2
votes
2answers
99 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.
