Editor's review
CSV to MSSQL is a tool to Convert, Migrate data from/to MS SQL Server to CSV or from CSV files to MSSQL. You can convert multiple files in one go from CSV to MSSQL or from CSV / Delimited files to MS SQL Server database.
Features: CSV to MSSQL is a tool that can facilitate moving of data to/from CSV formatted data. It is able to handle delimited data format in general. This utility is able to do the conversion either way. It does handle multiple files too. There is a wizard available and it takes you through the necessary steps automatically using default parameters. You are able to map the source data columns to the destination data columns. You can select/deselect columns when transferring data. Selection of a single or multiple tables are available. Changing of destination data types and widths is possible. There is automatic check of data types mismatch. Rows can be picked up selectively by using the WHERE conditions.SQL dump files can be created easily. There is no need for programming expertise or to write code to get the functionalities done. Transferring large amount of data is no problem with the utility. It has a built in scheduler that can run transfer jobs at specified intervals. No repeated runs of transfers are needed, you are able to create sessions that define the date and time and the loader automatically does the transfer job. The actions and events are logged. All such sessions are stored in a repository. The user interface is easy to use. Even complete beginners can get productive very quickly. The sessions are thus managed easily. You manage backup and restores as well as creation of a new repository should you need it. It has a command line interface too.
Overall: It is a nice and handy utility for data transfer to and from delimited data files.
User comments