Re: Migrating an Application from SQL Server 2000 to Oracle 10g

On 15 Jul, 23:38, tcole6 <tco..._at_gmail.com> wrote:
> We have an application that was written using SQL Server 2000 as the
> RDBMS. We now have a need to convert this to Oracle. We know that we
> obviously need to hire an Oracle DBA, but we don't have one at this
> time...
>
> Our application uses queries with joins across databases. In SQL
> Server this is acheived like so:
>
> SELECT a.a, a.b, b.a, b.b from Database1.dbo.Table1 a LEFT JOIN
> Database2.dbo.Table1 b WHERE a.c = '123'
>
> We absolutely do not understand the how Oracle uses Schemas, but we
> are hoping to be able to create a structure where the above select
> statement would still function. In other words we need to create these
> databases with tables under the schema dbo. Otherwise we would need to
> rewrite lots of code.
>
> Are schemas tied to user accounts? Can anyone help me understand this,
> or is this information just too vague?
>
> Thanks in advance.

In addition to everything Joel Garry said, this may be of some use too: http://www.psoug.org/reference/sqlserver.html

HTH -g Received on Wed Jul 16 2008 - 06:17:16 CDT