Copying database schema from SQL Server 2008 to SQLite

Question

I am trying to replicate a portion of an SQL Server 2008 database in an Android application.

Is there anyway to import into SQLite directly from a script generated by SQL Server?

I have a come across one conversion tool, which is Windows only (doesn't help me), and there is no mention of how get the result onto the Android device.

p.campbell · Accepted Answer · 2011-11-09 21:39:56Z

1

Use the SQL Server Management Studio command "Generate Scripts". You choose the tables, and potentially include the data in the table. It will build the CREATE statements, along with the INSERT statements, if you choose. You may have to modify your column datatypes to fit SQLite.

Use any SQLite front-end as you like to execute those scripts into your Android SQLite file.

answered Nov 9, 2011 at 21:39

p.campbell

101k70 gold badges264 silver badges326 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mike D Over a year ago

@p.campell That's what I'm in the process of doing, just its 400 lines of SQL to inspect. I was hoping there was an easier way.

user226555 · Accepted Answer · 2011-11-09 22:01:46Z

1

I have no experience with SQLite, but I have had a certain amount of success migrating data from MS SQL Server to other DBs by using .NET's DataSet.WriteXml to create an xml representation of the data which can then be imported. Takes only a few lines of code.

If you have the tools to develop in the Windows environment at all, I believe you can also connect directly to SQLite with .net, so that you could directly create your SQLite DB on that platform, then just move the DB file.

answered Nov 9, 2011 at 22:01

user226555

Collectives™ on Stack Overflow

Copying database schema from SQL Server 2008 to SQLite

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related