Re: Trying to implement our database (SQL-server) in ORACLE.

I use Embarcaderos product dbartisan and it works fine version 5.03 also the have a schema manager this works very good as well. If you have a problem with Embarcadero's program they will help you for free during your 30 day eval.

Bill

stef ten bras wrote:
>
> For our product we will be supporting two databases.
>
> MS-SQLserver and ORACLE.
>
> The database was build in MS-SQLserver, mainly using the
> SQL Server Enterprise Manager.
>
> At the moment we are evaluating DBArtisan from
> Embarcadero (http://www.embarcadero.co.uk),
> to get the tables from SQL-server towards ORACLE.
>
> We have transported our tables, indexes and constraints.
> But up to now we haven't been able to transport our :
>
> Views.
>
> And also not the diagrams, stored procedures and triggers.
> (But these are all less inportant than the views).
>
> Does anybody have a workable way to transport the views
> from SQL-server to ORACLE.
> (Most problems stem for joins (outerjoins specificaly)).
> If there is a solution for transporting from ORACLE to
> SQL-server, then we might consider this for the future.
>
> We wil be continueing with both products and would like to have
> a procedure / tool to transport the metadata etc. from one
> to another. Doing the maintanance on both databases, makes
> it more funarable to mistakes.
> Doing the conversion of views by hand is very errorprone.
>
> Thanks,
>
> stef ten bras,
Received on Fri Jan 21 2000 - 00:00:00 CET