[sqlite] SQLite to SQL Server

All, Is there a convenient way to transfer data from SQLite to SQL Server? I'm presently writing code to do a row by row transfer of all my tables, but the thought crossed my mind that maybe there's a better way. Thanks, -- Bill Drago Senior Engineer L3

[sqlite] JSON expressions for records and synchoronisation

On Fri, 10 Apr 2015 14:15:43 -0700 Roger Binns wrote: > On 04/10/2015 01:51 PM, Simon Slavin wrote: > > With a cursory glance I do see important incompatibilities with > > SQLite. > > I use JSON as the data format for $work stuff (startups) for years, > and these JSON schemas etc miss why some

[sqlite] SQLite to SQL Server

On Mon, 13 Apr 2015 21:38:25 + "Drago, William @ CSG - NARDA-MITEQ" wrote: > Is there a convenient way to transfer data from SQLite to SQL Server? If I were doing it, I'd produce tab-delimited files with sqlite3 and use the SQL Server bcp utility to upload the output. The current trunk

[sqlite] JSON expressions for records and synchoronisation

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/13/2015 03:15 PM, James K. Lowden wrote: > I beg to differ, Roger. Note that I deliberately said "some" and not "all". Everyone has their reasons, and not everyone has the same reason. > The programming language of choice doesn't affect the

[sqlite] Performance issue

On 2015-04-13 09:49 AM, Jeff Roux wrote: > Hi everyone, > > I have copied the original database on my personnal website in a tbz > archive here : > > http://nice-waterpolo.com/misc/db/ > > There is only one index on timestamp,protocol. Hi Jeff, I am not sure what is wrong your side, but the

[sqlite] Performance issue

Hi everyone, I have copied the original database on my personnal website in a tbz archive here : http://nice-waterpolo.com/misc/db/ There is only one index on timestamp,protocol. Thanks. 2015-04-08 14:38 GMT+02:00 R.Smith : > > > On 2015-04-08 01:57 PM, Dominique Devienne wrote: > >> No