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.
| Author |
Topic |
|
Ranjan
Starting Member
2 Posts |
 Posted - 2004-12-16 : 07:44:30
|
| Hi, I am an SQL Server DBA. Currently we have a business need where we need to migrate from ORACLE database to SQL Server database. Can any one please give me a brief idea about about the below points1. How to migrate from Oracle database to SQL Server database?2. What are the steps need to be followed?2. What all things i need to consider while planning for migration?3. Is there any scripts or tools i can use?4. Is there any documentation avaiable for the same?Hope to get a quick reply.Cheers,Ranjan |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-16 : 08:12:09
|
| http://www.microsoft.com/sql/techinfo/deployment/70/oraclemigrate.asphttp://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htmhttp://freedownloadswindows.com/6514643/adventnetswissqloracletosqlservermigrationtool_24.htmlin factsearch for oracle sql server migrationin google==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Ranjan
Starting Member
2 Posts |
Posted - 2004-12-17 : 02:13:19
|
| Dear, Can anyone Tell me what is best approach to migrate the ORACLE schema to SQL Server 2000. Approach which i think of is1. Linked Server Approach2. Using SQL Server's DTS concept.Regds.,Ranjan |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-17 : 15:17:55
|
| So did you read those articles that Nigel posted?Tara |
|
|
|
|
|
|
How to migrate from Oracle to SQL Server?