Tuesday, March 27, 2012

export data to oracle db

Who knows a simple way to export a table from SQL server
to oracle databases? Thanks a lot.Hi Jiaxin,
You can use DTS to do that I believe. From Enterprise Manager, right click
on the table, export data,
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||Hi Yih,
Thank you very much for you reply. But I am not a DBA and
the only client software that I can use to access the SQL
Server is MS access97.
Any other suggestions?
Jiaxin
>--Original Message--
>Hi Jiaxin,
>You can use DTS to do that I believe. From Enterprise
Manager, right click
>on the table, export data,
>Sincerely,
>Yih-Yoon Lee [Microsoft]
>Microsoft SQL Server Support
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Subscribe to MSDN & use
http://msdn.microsoft.com/newsgroups.
>.
>

No comments:

Post a Comment