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?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.