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

On Jul 16, 7:17 am, gazzag <gar..._at_jamms.org> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

Thanks for your feedback guys. The reference page is a humongous (?) help. Can't wait to dive in there and see just how confused I can actually get :) Received on Wed Jul 16 2008 - 08:39:50 CDT