![]() I would choose "Sql Script" but there's so much data that the script would just be enormous.įinally, I tried "Data Export Wizard" and I don't see an option to export to a sql server database. All the options are to hard file (sql script, CSV, tab-delimited, etc). I then tried right-clicking table and "Export Wizard", but I don't see an option to export to another database. ![]() I right-click on the table, but I don't see the option "Copy Data to Another Schema". I was looking at this Toad link but I don't have a Schema Browser I only have and "Object Explorer". ![]() I have read-only access to the remote Oracle DB, but I have owner access to the local sql server DB. It's the same thing as the sql server Import/Export utility, but using Toad Data Point. ![]() Toad Data Point to export sql statement from Oracle to Sql Server? - toad We have a remote Oracle database, and I need to export data from that DB to a sql server database.
0 Comments
Leave a Reply. |