attach?backup?export?

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

From: Napo (Napo_at_discussions.microsoft.com)
Date: 01/10/05 

Date: Sun, 9 Jan 2005 20:01:02 -0800

what're the difference among these three functions?
I can use sp_detach_db/sp_attach_db SP to attach a db in sqlserver. But
what SP is in oracle to do the same work? If i want to migrate db from
sqlserver to oracle. how to do the attach function in oracle?

tks

Relevant Pages

  • Re: Attach & detach tablespace
    ... In SQLServer I detach from one server and then attach it to another ... Is something like this possible with Oracle? ... My recommendation would be that you start by reading the concept docs ...
    (comp.databases.oracle.server)
  • Re: changes to support Oracle 10 type BINARY_FLOAT
    ... > I was able to get DBD-Oracle-1.16 to read and write the new Oracle 10 ... > What follows are the diff files for Makefile.PL, ... > I would attach the edited files but I'm not sure how this mailer handles ... The edited files are available for now at ...
    (perl.dbi.users)
  • RE: Call Oracle Procedure from Excel macro
    ... there is a product from Oracle called "Oracle Objects for OLE". ... It allows you to attach to the database and ... retrieve data, change data, run procedures, etc. ...
    (microsoft.public.excel.programming)
  • Re: Oracle licence question
    ... Both SQLServer and Oracle have multiple data engines in their products - a SQL engine, ... Oracle's SQL engine is stronger than SQLServers SQL engine in terms of BI, in that there are SQL Extensions that support BI activities such as analysis, aggregation and modelling. ... These BI capabilities in the SQL engine are in ALL editions of Oracle ... SQLServer doesn't have many of these equivalent capabilities in the SQL engine, so SQLServer users tend to go to the OLAP engine in SQLServer for equivalents. ...
    (comp.databases.oracle.server)
  • Re: ADO.NET and SQL, Oracle
    ... >> pay over 2 million dollars a year to Oracle for licensing costs, ... I am curious why you say Paging code in Oracle is easier. ... >> lightweight client like SQL+, ... > I'm not talking about sqlserver 2005, ...
    (microsoft.public.dotnet.framework.adonet)