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 |
|
kkr12
Starting Member
12 Posts |
 Posted - 2006-03-03 : 15:09:11
|
| Hi, We've 2 databases on Oracle and SQLServer and both has same data elements.I've some insert scripts in Oracle database which needs to be converted so that they can be executed in a SQL Server database. Does any one know of any way of converting these insert statements so that they can be run in query analyzer or from command prompt in a sqlserver database ?Thanks,kkr |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-03 : 16:32:40
|
| Depends upon how complicated the scripts are. If they only do single inserts, then your task may not be difficult. But if they do multi-record inserts then Oracle's dependence upon cursors may make your current algorithms unsuitable for SQL Server's set-based paradigm. |
 |
|
|
kkr12
Starting Member
12 Posts |
Posted - 2006-03-06 : 09:26:45
|
| The scripts only have single record inserts, normal insert into table statements with commit key word at the end. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-06 : 09:35:15
|
| If they are simple insert statements, you can use them in SQL Server also. Post the Oracle code you usedMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Coverting Oracle scripts to t-sql