Convert SQL Views to SQLite

• djacobos

  SSC Eights!

  Points: 891

  More actions

  December 6, 2013 at 8:16 pm

  #150527

  What i want to do is migrate my SQL Views to SQLite.

  I have tried the following tools:

  http://www.codeproject.com/Articles/26932/Convert-SQL-Server-DB-to-SQLite-DB

  http://convertdb.com/views_translation

  But those tools seem to only migrate my SQL Tables and not my views. Any tool out there to do that?

  The big picture is that i need to put a website on a CD that connects to a database. MS Access could not hold my data so i am trying to use SQLite insead.

• Lowell

  SSC Guru

  Points: 323522

  More actions

  December 7, 2013 at 11:58 am

  #1671731

  in both SQL and SQLite, a view is a saved select statement.

  it's pretty much just CREATE VIEW VIEWNAME AS SELECT.....

  where are you having trouble? do you want to materialize the SQL view as a table in SQLite, or still as a view?

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• djacobos

  SSC Eights!

  Points: 891

  More actions

  December 7, 2013 at 9:25 pm

  #1671746

  I just ended up keeping MS Access on my application and did away with the view that was giving me problems. When you import a SQL View to MS Access it imports the data as a table and it was too large.

  My workaround was to replace in my code where i was calling a View, to a dynamic SQL Statement.