Hi All,

We have a windows based application using Oracle8.1.7 back end.
The application do not use any stored procedure, triggers.
The queries used by the application uses many specific features.
We are going to support SQL Server 2000 in future as back end.

Can anyone provide points which need to be taken into account for this activity?
Also what will happen to followings ?
1) Sequences and Insert queries
2) Synonyms
3) Dual table
4) Views (system, user-defined)
5) Joins (Inner, Outer)
6) DDL and Data Types
7) Storage specific parameters (pctfree, extent etc)
8) Permissions (Grants)


Oracle Functions/Statements
1) To_Char
2) To_Date
3) Decode
4) RowNum
5) Level
6) Mod
7) Connect By Prior
8) RTrim
9) Trunc

Please guide on any additional things to be considered.

Many Thanks in advance.

Regards,
Yogesh



















MS Sql Server LazyDBA home page