I did that but I did it table by table and used DTS for the
transformations. I extracted the DDL for the tables from Oracle and
modified the datatypes as necessary for the SQL definition. Tables
without dates were run through a simple copy column DTS package. Tables
with dates needed ActiveX transformation to handle the default date and
convert it to an SQL default. There were perhaps a 100 tables but it did
not take that long to work up. The same method also worked for AS400 DB2
to SQL.



You could also export to a delimited file and bcp the data in.

-----Original Message-----
From: prashanth
[mailto:oracledba-ezmlmshield-x15199227.[Email address protected]
Sent: Thursday, September 28, 2006 8:27 AM
To: LazyDBA Discussion
Subject: RE: export / import issues


Hi Experts, I need to export the full database from oracle and import in
to SQL server

Plz. Give me the exact commands

Regards,
Prashanth R


-----Original Message-----
From: Mohamadou David Mirdassou [ MTNCameroon IS - DMSC ]
[mailto:oracledba-ezmlmshield-x38832220.[Email address protected]

Sent: Thursday, September 28, 2006 6:54 PM
To: LazyDBA Discussion
Subject: export / import issues

Hi everyone.




I am having some difficulties with exporting and importing a database.

I would like to export the QA instance on UNIX and import it on the


DEV instance on windows.

DB size on QA is around 30GB.

Can any one help me through this?




NOTE: This e-mail message is subject to the MTN Cameroon disclaimer, see
http://www.mtncameroon.net/disclaimer.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




The information contained in this electronic message and any attachments
to this message are intended for the exclusive use of the addressee(s)
and may contain proprietary, confidential or privileged information. If
you are not the intended recipient, you should not disseminate,
distribute or copy this e-mail. Please notify the sender immediately and
destroy all copies of this message and any attachments.


WARNING: Computer viruses can be transmitted via email. The recipient
should check this email and any attachments for the presence of viruses.
The company accepts no liability for any damage caused by any virus
transmitted by this email.


www.wipro.com


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page