Although i might have suggested you using ODBC for the project, however, most RDBMS can be manipulated via SQL (4D inclusive). To accomplish this task, I intend collecting the entire content and format of your 4D database through SQL and use this collection to create a new one in MS SQL server (the power of SQL).
I'll be expecting your call. Thank you