I am looking for a way to synchronize Salesforce data with a local database. At the moment I just want a pain free way of downloading the data. I've been playing around with importing CSVs from the data loader and direct database inserts using Jitterbit. This all works fine (as fine as CSVs can be!) but it is very tedious work to create tables without any strict data type/constraint definitions for classes with many fields. Is there a way to find this information so that I can create the tables with more confidence? Or better yet a tool or some APEX that will output a create table script based on the actual Salesforce class fields?
The destination database is SQL Server 2008.