-
11/23/2020 - Updated V8 - Added Oracle Export option (beta)
-
11/22/2020 - Updated V7 with following changes
- Extraction Performance improvements for larger datasets.
-
11/21/2020 - Updated V6 with following changes
- Added Windows Authentication support for SQL connection
- Added max file size option for exporting chucks for large table exports (10, 25, 50, 75 & 100 MB)
- Added Option to Enable/Disable client side file compression (gzip) prior to uploading to Snowflake
- Enhanced logic to reduce redundant SQL create schema commands.
- Fixed an issue with Column names with spaces.
- Fixed an issue displaying status for tables with 0 records
Windows export utility to automatically transfer entire set of tables from Microsoft SQL server to Snowflake
- Tool requires Snowflake_ODBC_driver Win64 to be installed on the machine before it can run.
Download SQL_to_Snowflake Installer
Snowflake Win64 ODBC Driver Download
Oracle OLEDB 64-bit Driver Download - (optional for Oracle connections)
This utility will automatically move tables (in full) from a Ms SQL server to Snowflake. All you have to do is select a list of tables from SQL server and point to an existing Snowflake account & a database with proper user cridentials to create schemas & tables.
The tool will do the following for each table:
- Generate a DDL & Create the table in Snowflake.
- Auto map proper datatypes.
- Perform date type conversion
if COPY DATA is checked (checked by default)
- Export the data into files in 10MB batches into a temp folder.
- Create an internal stage in the target Snowflake database & Upload the files
- Copy the uploaded files into the proper table in snowflake.
This product is a personal project & provided as is without any warranty. This application is not associated with Snowflake Inc. & not a supported product. Please use it at your own risk.
