SQL Server Migration
I knew that there was a toolkit to help move an application from Oracle to SQL Server, but I hadn’t appreciated that there was one for Sybase and Access these also now come in two flavours, one to move you to SQL Server 2005, and one for SQL Server 2008:
SQL Server 2005 Migration Assistant for:
SQL Server 2008 Migration Assistant for:
Before you ask, there aren’t any assistants fromMicrosoft to do migrations to these platforms from SQL Server, although I am sure that Oracle and Sybase will be happy to help with that. What I can’t understand is why anyone would go this way, so post some comments and enlighten me.
Technorati Tags: SQL Server,Oracle,Sybase ASE,migration
Comments
Anonymous
August 05, 2008
The comment has been removedAnonymous
August 06, 2008
James No my mad bad typing fixing it Now!Anonymous
August 06, 2008
I know some businesses that are happy to use SQL Server for their small applications, but on the enterprise level run their data centers on Oracle. It might be more cost effective to move a rapidly growing application over to Oracle and reuse the existing environment rather than build a SQL Server based data center?Anonymous
August 07, 2008
The comment has been removedAnonymous
October 15, 2008
Andrew, Do you have any news or info regarding an SSMA DB2 to SQL Server. Has there been much interest in this?Anonymous
October 16, 2008
Not off hand I will get some inof for you if you can e-mail me (afryer@microsoft.com) with you detailsAnonymous
March 31, 2009
What about migration from Flat files to SQL Server?Anonymous
March 31, 2009
What about migration from flat files to SQL Server>Anonymous
April 01, 2009
The comment has been removedAnonymous
April 16, 2009
SQL Server Migration Assistant is nice for migrating schema or even pl sql store procedures. However it does not well to migrate large data sets like terabytes or tens of terabytes data from Oracle. This is a real pain to migrate data from Oracle and I don't know tool better than Fastreader from wisdomforce - http://www.wisdomforce.com/products-FastReader.html which can do a better job when it comes to migrate large databases from Oracle to other like SQL Server.Anonymous
June 11, 2009
Hi: I have several SQL Server 7 instances (on Windows 2000 server) that I need to migrate to SQL Server 2008 (new Windows 2008). Several of the SQL Server 7 databases have compatibility for 6.5 ON. I need to migrate all databases (include the master) along what all logins/passwords and roles, etc. As a newbie to SQL sever, what is the best way to migrate? I have done some tests to migrate to SQL server 2005 using detach/attach but the 6.5-compatiable databases failed. Thanks a lotAnonymous
June 11, 2009
Aironyu That is a world of pain for a newbie. I think fpor 6.5 you'll havre to go via sql 2000 as an intemreidiate step. AndrewAnonymous
August 07, 2009
You can also check this blog on SQL Server migration and SSMA. http://ssmablog.blogspot.comAnonymous
August 24, 2009
Andrew, Have you found anything out on SSMA DB2 to SQL Server.Anonymous
August 25, 2009
Lou No plans at the moment to bring out an assitant for DB2 I'm afraid. Akll I can suggest you do is to raise the question yourself on Connect (http://connect.microsoft.com).Anonymous
April 08, 2010
I'm in the middle of a migration from Sybase ASE on Solaris to SQL Server 2008. Have worked through most issues so far but one. In Sybase ASE you have an identity_gap parameter that defines the sze of the block of ID numbers in the table's object allocation map. This has to do with the db server "caching" a list if id numbers for use with an identity column and you ending up with a mess if the server goes down without the proper shutdown. Is there an equivlent in SQL Server or does SQL Server just grab the next ID number one at a time? ThanksAnonymous
April 12, 2010
Ron Nice one! I am not aware of any caching we just grab the next one afaik Andrew