But let your communication be Yea, yea; Nay, nay: for whatsoever is more than these cometh of evil
Friday, November 21st, 2008

How to transfer a MS SQL server to an OS X sqlite database

Here is what worked for me: Start up MS SQL server and run a tool that can be compiled from sources at Codeproject. Transfer the resulting SQLITE3 database to the Mac where it can be accessed by R via the RSQLite library. Many thanks to Liron Levi and his patient help with tables having more than 1000 columns!
I am in the process of setting up a graphical ER management tool while the native ODBC driver still seem to have some problems. Any workaround is greatly appreciated.

Related Posts: Quick database edit from webbrowser, Convert an Access(R) database into mySQL format, PDF rename based on Zotero entry, A database driven epidemiological questionnaire
Categories: Asthma + Allergy
Keywords:
Trackback: http://www.wjst.de/blog/blog/2008/11/21/how-to-transfer-a-ms-sql-server-to-an-os-x-sqlite-database/


Comments are closed.