SQL Server Migration

re: SQL Server Migration

James Rowland-Jones — Tue, 05 Aug 2008 18:35:18 GMT

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

re: SQL Server Migration

Andrew_Fryer — Wed, 06 Aug 2008 09:24:22 GMT

James

No my mad bad typing fixing it Now!

re: SQL Server Migration

Andrew — Thu, 07 Aug 2008 06:33:30 GMT

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?

re: SQL Server Migration

Andrew_Fryer — Thu, 07 Aug 2008 09:23:30 GMT

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

re: SQL Server Migration

Michael — Wed, 15 Oct 2008 19:06:52 GMT

Andrew,

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

re: SQL Server Migration

Andrew_Fryer — Fri, 17 Oct 2008 01:50:00 GMT

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

re: SQL Server Migration

Mukesh Loya — Tue, 31 Mar 2009 11:24:12 GMT

What about migration from Flat files to SQL Server?

re: SQL Server Migration

mukeshloya — Tue, 31 Mar 2009 11:41:05 GMT

What about migration from flat files to SQL Server>

re: SQL Server Migration

Andrew_Fryer — Wed, 01 Apr 2009 10:20:56 GMT

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)

re: SQL Server Migration

Peter Watmon — Thu, 16 Apr 2009 08:54:54 GMT

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.

Migrate from SQL Server 7 to SQL Server 2008

aironyiu — Thu, 11 Jun 2009 08:47:08 GMT

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

re: SQL Server Migration

Andrew_Fryer — Thu, 11 Jun 2009 11:35:19 GMT

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

re: SQL Server Migration

Manu — Fri, 07 Aug 2009 22:06:05 GMT

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

http://ssmablog.blogspot.com

re: SQL Server Migration

Lou — Tue, 25 Aug 2009 02:01:04 GMT

Andrew,

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

re: SQL Server Migration

Andrew_Fryer — Tue, 25 Aug 2009 09:55:11 GMT

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