Presents your SQL SERVER E-NEWSLETTER for September 12, 2002 <-------------------------------------------> DETERMINE THE PROPER TOOL FOR IMPORT/EXPORT At some point, you'll need to determine which SQL Server tool you'll use for data import/export. There are several tools available for data import/export, and each tool has a specific functionality. If you know your requirements and can correlate the requirements into criteria, you can use these criteria to determine the best tool. If you're unsure of the requirements, you may generate the criteria using the table provided in the SQL Server books online. The following is the list of functionality that the SQL Server tools may possess: * Import text data * Export text data * Import from ODBC data sources * Export to ODBC data sources * Import from OLE DB data sources * Export to OLE DB data sources * Graphical user interface (GUI) * Command prompt/batch scripts * Transact-SQL scripts * Automatic scheduling * Ad hoc import/export * Recurring import/export * Maximum performance * Data transformation * Programmatic interface ----------------------------------------