Thanks for the tip. I've used dump before to move data around between SQLite databases. I should have realized that I could have used it to move data to SQL Server.
-- Bill Drago Senior Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -----Original Message----- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- > users-bounces at mailinglists.sqlite.org] On Behalf Of Simon Slavin > Sent: Monday, April 13, 2015 6:24 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SQLite to SQL Server > > > On 13 Apr 2015, at 10:38pm, Drago, William @ CSG - NARDA-MITEQ > <William.Drago at L-3com.com> wrote: > > > 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. > > If you're just doing it once, use the SQLite shell tool to '.dump' the > database to a text file of SQL commands, then read the text file into a > fresh database in SQL Server. > > You may have to do some minor editing of the text file to make it > conform to SQL Server's notion of SQL rather than SQLite's notion of > SQL. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any attachments are solely for the use of the addressee and may contain information that is privileged or confidential. Any disclosure, use or distribution of the information contained herein is prohibited. In the event this e-mail contains technical data within the definition of the International Traffic in Arms Regulations or Export Administration Regulations, it is subject to the export control laws of the U.S.Government. The recipient should check this e-mail and any attachments for the presence of viruses as L-3 does not accept any liability associated with the transmission of this e-mail. If you have received this communication in error, please notify the sender by reply e-mail and immediately delete this message and any attachments.