The options that Enterprise Manager gives for import and export through SQL Server Integration Services (SSIS) is very comprehensive. Their wizard walks you through being able to import data from any other ODBC data store (SQL, Access, Oracle, CSV, etc) to SQL and vice versa. I do a lot of this type of importing and exporting between database servers (local to test to production) and between server types (oracle to sql to access).
Can Toad for SQL Server access other data sources directly through ODBC or some other such mechanism?
There are no plans to introduce cross platform ODBC connectivity in Toad for SQL Server. For this type of functionality please consider Toad Data Point - https://www.quest.com/products/toad-data-point/
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center