In my experience changing databases is a throughly manual process. You might be able to write something to inspect schemas and re-create them but you will likely have to write custom code to move the data over.
For what it's worth, I've written a small utility in C# that may help you to the conversion from SQL Server to SQLite.
Go to http://www.codeproject.com/KB/database/convsqlservertosqlite.aspx for more details
Good luck
Liron
Excellent! Exactly what I was after. With a little tweaking, I could create an Excel to SQL Lite app as well. Regards Andrew
Did it work for you?
If you add code for Excel, maybe it will be a good idea to send me the updated code so I can enhance the utility to handle Excel files also :-)