You might want to try using the IMPORT Data under ALL TASKS in SQL SERVER ENTERPRISE MANAGER If you select the database and right click ----- all tasks----- you should see an IMPORT DATA. This allows many different options to convert. I think Oracle was one of them. Ali -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jamil tamimi Sent: Saturday, May 28, 2005 3:40 AM To: [email protected] Subject: [AspNetAnyQuestionIsOk] Export Data from Oracle to SQL Server
hi all, i have an oracle database that contain an tables and records. i want to export the updated data (change in data in this database) to sqlserver database in a quick and high performance. in the same issue i have to manage the differants in the data fields between oracle and sqlserver. i try to create database link from oracle and connect to odbc and it is slow to export data. what is the best way to do that or the best tool or anyway to do that. thank in advance __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] cribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of <http://docs.yahoo.com/info/terms/> Service. [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
