B'more on Rails Message Board › Off topic: port SQL Server 2000 DDL scripts to Oracle 10g

Off topic: port SQL Server 2000 DDL scripts to Oracle 10g

George A.
user 3366585
Baltimore, MD
Post #: 7
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.

Details below.

Thanks,

George


++++++++++++++++++

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:

Databases
|
--- Workflow
| |
| --- Tables
| |
| --- Table1
| |
| --- Table2
|
--- IAL
|
-- 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

<database>.<schema>.<tabl­e_name>

MS SQL always uses dbo as the schema. This happens automatically. So I
access the tables like so:

Workflow.dbo.Table1

IAL.dbo.Table2

etc.

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.
Powered by mvnForum

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy