Hi, On Tue, Apr 14, 2015 at 10:31 AM, Drago, William @ CSG - NARDA-MITEQ <William.Drago at l-3com.com> wrote: > 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.
And you can use bcp (freebcp from freeTDS package) to move the data from the text file in the SQL Server. For 'bcp' I don't think any editing is required.... You may need to check the result though. ;-) Thank you. > > -- > 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. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
