Migrating to SQL Server 2008


Microsoft SQL Server 2008

SQL Server 2008 delivers exceptional value in Database Management and Business Intelligence causing many customers to choose SQL Server over other database solutions. The information on this page will help you find the resources needed to migrate you data to SQL Server 2008.

To read more about What’s new on Microsoft SQL Server 2008, how to migrate from different RDBMSs to Microsoft SQL Server 2008 check this http://www.microsoft.com/Sqlserver/2008/en/us/migration.aspx

4 Responses to Migrating to SQL Server 2008

  1. terry says:

    Hi Rammy; have you used SSMA to migrate Oracle schemas to MSSQL?

    We have 4 Oracle schemas that we have to port over to SQLServer including all the PL/SQL, triggers, packages etc

    Any help would be appreciated.

    Thanks

  2. Ramy Mahrous says:

    Hey, Terry…
    I didn’t use it for Oracle but tell me about that http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx and if there’s any problem faced you tell me please.

  3. terry says:

    Hi Ramy; we tried the 2008 version…

    http://www.microsoft.com/downloads/details.aspx?FamilyId=3E8722AE-77F3-4288-906D-F421E24D322F&displaylang=en

    and I must say is worked like a charm. It would have taken a day but it took us 2 days for 4 schemas.

    In hindsight we should have:
    – changed the default mapping for all sequences to identities
    – Numbers converted to floats

    So we had to change these in the generated scripts and this took some time. But all-in-all I can’t complain. Of course we will need some testing which we will be doing now for the application side.

    Cheers!

  4. Ramy Mahrous says:

    Great news, and if you’ve some comments please let me know -especially in testing phase- I can deliver them to SQL Server team.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: