[sqlite] SQLite to SQL Server

2015-04-15 Thread Erik Ejlskov Jensen
If you have VS, you can use my free SQLite Toolbox add-in, just added feature to migrate to and from SQL Server with "a single click". http://erikej.blogspot.dk/2015/03/sql-server-compact-sqlite-toolbox-42.html https://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1

[sqlite] SQLite to SQL Server

2015-04-14 Thread Drago, William @ CSG - NARDA-MITEQ
M.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: [sqlit

[sqlite] SQLite to SQL Server

2015-04-14 Thread Igor Korot
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 >> wrote: >> >> > Is there a convenient way to transfer data fro

[sqlite] SQLite to SQL Server

2015-04-14 Thread R.Smith
On 2015-04-13 11:38 PM, Drago, William @ CSG - NARDA-MITEQ wrote: > 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. Depend

[sqlite] SQLite to SQL Server

2015-04-13 Thread Simon Slavin
On 13 Apr 2015, at 10:38pm, Drago, William @ CSG - NARDA-MITEQ 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

[sqlite] SQLite to SQL Server

2015-04-13 Thread Drago, William @ CSG - NARDA-MITEQ
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 Narda-MITEQ

[sqlite] SQLite to SQL Server

2015-04-13 Thread James K. Lowden
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 o