SQL SERVER – CSVExpress and Quick Data Load
- by pinaldave
One of the newest ETL tools is CSVexpress.com. This is a program that can quickly load any CSV file into ODBC compliant databases uses data integration. For those of you familiar with databases and how they operate, the question that comes to mind might be what use this program will have in your life. I have written earlier article on this subject over here SQL SERVER – Import CSV into Database – Transferring File Content into a Database Table using CSVexpress.
You might know that RDBMS have automatic support for loading CSV files into tables – but it is not quite as easy as one click of a button. First of all, most databases have a command line interface and you need the file and configuration script in order to load up. You also need to know enough to write the script – which for novices can be extremely daunting. On top of all this, if you work with more than one type of RDBMS, you need to know the ins and outs of uploading and writing script for more than one program.
So you might begin to see how useful CSVexpress.com might be! There are many other tools that enable uploading files to a database. They can be very fancy – some can generate configuration files automatically, others load the data directly. Again, novices will be able to tell you why these aren’t the most useful programs in the world. You see, these programs were created with SQL in mind, not for uploading data. If you don’t have large amounts of data to upload, getting the configurations right can be a long process and you will have to check the code that is generated yourself. Not exactly “easy to use” for novices.
That makes CSVexpress.com one of the best new tools available for everyone – but especially people who don’t want to learn a lot of new material all at once. CSVexpress has an easy to navigate graphical user interface and no scripting or coding is required. There are built-in constraints and data validations, and you can configure transforms and reject records right there on the screen. But the best thing of all – it’s free!
That’s right, you can download CSVexpress for free from www.csvexpress.com and start easily uploading and configuring riles almost immediately. If you’re currently happy with your method of data configuration, keep up with the good work. For the rest of us, there’s CSVexpress.com.
Reference: Pinal Dave (http://blog.SQLAuthority.com)
Filed under: Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology
