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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-24 : 09:04:52
|
| Suresh writes "Hi,Our client has an application that is currently working on Oracle he intends toport the same to MS SQL Server. In order to come up with an effort estimation just wondering if you have some material, which points out the work involved.Cheers!!" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-06-28 : 20:42:05
|
| Porting the DATA is easy. DTS (Data Transformation Services) in SQL Server will do that nicely. Porting the application code is nigh-on to impossible. In order to make it run efficiently on SQL Server, expect to do a major re-write of the SQL code (stored procedures, triggers, etc.). Any client-application code (such as ASP or VB) will work with little if any change needed except the change to the connection string and any embedded SQL. |
 |
|
|
|
|
|
Data Porting from Oracle to MS SQL Server