Re: Migracion de Oracle a SQL2000 Server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tom Spitzer (tkspitzer_snip_at_snip_ecwise.com)
Date: 08/12/04 

Date: Wed, 11 Aug 2004 23:35:19 -0700

Yes, but not necessarily "all objects". Use OLE DB to connect to Oracle.
Some objects don't translate well, there are data type issues, and some
stored procedures are not going to be compatible with SQL Server.

I know the people at DBBest have tools and expertise migrating from Oracle
to SQL Server:

http://www.dbbest.com/

You might check them or follow up with me.

Tom Spitzer
EC Wise, Inc.
tspitzer@ecwise.com

"Matias" <Matias@discussions.microsoft.com> wrote in message
news:C2B5DE61-9AAE-47C1-B469-1F7F52174920@microsoft.com...
> Con el DTS de SQL2000 Server, se puede migrar bien la Base de datos de
Oracle?.
> Migra todos los datos y objetos?.
>
>

Relevant Pages

  • Re: What is Oracles version of MS SQL Profiler
    ... Tracking code path of a stored procedure (find out what is being ... I'm new to Oracle coming in from Sql Server. ... what I use to debug stored procedures and track performance. ...
    (comp.databases.oracle.server)
  • Re: Migrate SQL Server Stored Procedures
    ... SQL Server uses Transact-SQL as a language and Oracle uses PL/SQL. ... > How can I migrate all SQL server Stored Procedures to Oracle adn Oracle ...
    (microsoft.public.sqlserver.programming)
  • Re: Get all stored procedures
    ... Does anyone know the specific select for Sql Server and/or Oracle to get the ... >> Is there a way under ADO .NET to get all stored procedures in a database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Please help!! How to get parameter back in ADO.NET
    ... Jet/Access, SQL Server, Oracle, 3x5Card? ... Note the OUTPUT parameters ONLY work with stored procedures. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)