the process of moving databases or data from one place to another
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 ...
15
votes
4answers
480 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 ...
2
votes
3answers
640 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 ...
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 ...
2
votes
1answer
695 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 ...
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, ...
2
votes
1answer
508 views
SQL Server Migration restore backup vs copy data and log files
Hey guys, I'm tasked with doing a SQL Server 2000 to 2005 migration. I will be doing a side-by-side migration. I've read from a few different sources that I can either:
perform a backup of the ...
