attach?backup?export?

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
Hi Napo,
You can't use detach/attach or backup/restore to move a database from sql
server to oracle. You need to recreate your schema on the oracle system and
then move your data there. Easiest starting point (if you have Enterprise
Manager) would likely be to use DTS (Data Transformation Services) to help
you with this. You can use it like a "data pump" as long as your copy of
Enterprise Manager has access to both the sql server and oracle systems.
(You can connect to oracle via an OLEDB driver).
If your application is complex, you might need to look at some 3rd party
tools that help with these migrations.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Napo" <Napo@.discussions.microsoft.com> wrote in message
news:D346C199-2716-4138-935A-CB7D8F444976@.microsoft.com...
> 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
|||Hi Greg,
Thank you for your reply.
My current job is to investigate the solution of migrate db from
sqlserver to oracle. My key eyepoint is .net client code but not DB
administration.At current system, they use ado.net to execuate sqlserver
detach/attach. I just want to know if i can write code to hot backuo(or cold
backup) oracle db using by ado.net(c#).
"Greg Low [MVP]" wrote:

> Hi Napo,
> You can't use detach/attach or backup/restore to move a database from sql
> server to oracle. You need to recreate your schema on the oracle system and
> then move your data there. Easiest starting point (if you have Enterprise
> Manager) would likely be to use DTS (Data Transformation Services) to help
> you with this. You can use it like a "data pump" as long as your copy of
> Enterprise Manager has access to both the sql server and oracle systems.
> (You can connect to oracle via an OLEDB driver).
> If your application is complex, you might need to look at some 3rd party
> tools that help with these migrations.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Napo" <Napo@.discussions.microsoft.com> wrote in message
> news:D346C199-2716-4138-935A-CB7D8F444976@.microsoft.com...
>
>