Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Convert SQL Views to SQLite Expand / Collapse
Author
Message
Posted Friday, December 6, 2013 8:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 8:05 AM
Points: 4, Visits: 14
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.
Post #1520785
Posted Saturday, December 7, 2013 11:58 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:16 AM
Points: 12,876, Visits: 31,784
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1520831
Posted Saturday, December 7, 2013 9:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 8:05 AM
Points: 4, Visits: 14
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.
Post #1520852
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse