oracle to sql2k5 migration - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

oracle to sql2k5 migration

Author

Topic

hrishy
Starting Member

47 Posts

Posted - 2007-10-09 : 07:32:52

Hi

I am a Oracle DBA who is going to embark upon a
oppurtunity to migrate Oracle to sqlserver.

Can somebody give me tips for
Learning sqlserver2k5 for a Oracle DBA Books
Or Beginner DBA/Development Books for sql2k5

How good is the migration assistant from m$$ for
migrating from oracle to sql2k5

Does it migrate data as well as procedural code ?

Do you anything for me to watch out for best parctices
migration guides

You opinion would be higly appreciated

regards
db2hrishy

Kristen
Test

22859 Posts

Posted - 2007-10-09 : 07:42:32

I doubt you'll have too much trouble with the data, it will be the procedural code that is the issue. Especially any server-side procedures ...

I expect there are some resources for re-skilling-DBAs, but I'm haven't had that need and can't advise on those, sorry.

Kristen

langdu
Starting Member

9 Posts

Posted - 2007-10-18 : 09:32:34

Migration between Oracle and SLQ Server will be OK with data in tables, but many store procedures have to be rewritten.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources