Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

SQL Server Migration

SQL Server Migration

  • Comments 17
  • Likes

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.  

Comments
  • Hi Andrew,

    I'll confess I could be having a mad moment but I am a bit confused by this post.  

    The Migration Assistants move databases to SQL Server away from these platforms - which seems entirely fitting given they are available from Microsoft.  It may be me but I am left with the impression that you are saying it works the other way around.

    If the question is around why anyone would leave SQL Server to go to say Oracle I have to say I can think of a couple of reasons off the top of my head.  

    1) Microsoft's "Shared Nothing" architecture for clustering means that there is always downtime in a failover as far as the DB is concerned.  I am no expert but I believe that Oracle is shared disk and is more elegant in this area.  It does seem to be easier to add machines to their clusters as well.

    2) BI.  I do think Oracle have built a very credible BI portfolio through their acquisitions and there is some way to go in terms of catch up.  Waiting till Office 14 for PPS is not the way forward IMO.  SSAS is very cool indeed though but by no means complete and I am a little underwhelmed by the BI value-add we are seeing in SQL 2008 (SSAS,SSIS in particular).

    Cheers, James

  • James

    No my mad bad typing fixing it Now!

  • 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?

  • Andrew

    I don't see how that would be cheaper by any criteria as I have yet to see a like fo rlike Oracle data centre cost less than  a SQL run. So drop me a line and let's compare notes.

    Andrew Fryer

  • Andrew,

    Do you have any news or info regarding an SSMA DB2 to SQL Server.  Has there been much interest in this?  

  • Not off hand I will get some inof for you if you can e-mail me (afryer@microsoft.com) with you details

  • What about migration from Flat files to SQL Server?

  • What about migration from flat files to SQL Server>

  • Well you can load flat files intoo SQL Server if they have any kinfd of structure (e.g. fixed width, defined seperator such as e.g. a comma).  But what application do you have as front end to that?

    Can we take this off line so e-mail me the details (afryer@microsoft.com)

  • 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.

  • 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 lot

  • 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.

    Andrew

  • You can also check this blog on SQL Server migration and SSMA.

    http://ssmablog.blogspot.com

  • Andrew,

    Have you found anything out on SSMA DB2 to SQL Server.  

  • 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).

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment