B'more on Rails Message Board › Off topic: port SQL Server 2000 DDL scripts to Oracle 10g
I have a friend who has a small(ish) job to port SQL Server 2000 scripts to Oracle 10g. If anyone is interested in some side work, please email me at george -at- benevolentcode -dot- com. The need is immediate.
My apologies is this is too off topic for this list, but I know our group has technical depth and I'd rather give the work to someone local.
We develop using an MS SQL database exclusively. We develop on 2000
but have a 2005 server available.
My setup in MS SQL is as such:
| --- Tables
| --- Table1
| --- Table2
My applications need to access multiple databases so I connect JDBC
(Java Database Connectivity) connections to the server, not the
database. Therefore when I make queries I need to reference the tables
in the format
MS SQL always uses dbo as the schema. This happens automatically. So I
access the tables like so:
My problem is that I don't understand Oracle and it's schema thing at
all. What I need to know is what is involved with creating a database
in Oracle that has a schema named dbo under which I can put tables so
I can also access the Oracle versions of these tables as
Workflow.dbo.Table1, etc.? Schemas look like they might be tied to
users or something?
If I can create this type of landscape in the Oracle database, I can
avoid rewriting a LOT of code.
Help with converting some SQL Scripts to Oracle scripts would also
help. We currently create our databases and tables using sql scripts
for MS SQL customers.