Respond

RE: MS.SS to Oracle
Bob Dole (Jan 15 2003 8:22PM)

So, lets assume you've got a SQL-92 compliant script set.  Migrating generic SQL structures to Oracle is really not that complicated.  Oracle handles table ownership the same way SQLServer does.  You create a DB owner, create your objects with that owner, and set user permissions to the objects.  I have been using Oracle for a number of years, and havn't touched SQLServer in a few, so I can't remember some of the terminology, but i would suggest just reading up on Oracle's ownership and permission rules.  There's a difference between a DB owner and a DB user.  A user in a DB named JDoe can own an object "Customers".  THat table's fully qualified name would be "JDOE.Customers".  It is then up to a DBA to specify that DB user "BSMith" has permission to log on to JDOE's database and use JDOE's objects.

It may sound complicated, but once you read over it you'll see it's just a matter of organizing your DB owners and users.

other than that, things should run pretty smoothly, as long as you have generic SQL that works in both environments.  like i said, this would include the use of keywords, structures, and datatypes.  If you've kept your design SQL-92 compliant, everything should work fine.  If you've downloaded FieldDefs in your DFM files, SQL-92 compliant fields shoudl generate the same FieldDef info.

Hope that helps out a little
Respond

MS.SS to Oracle
Hans Pieters (Jan 17 2003 8:55AM)

Tx Bob.
Hans Pieters
Respond