On Sun, 28 Oct 2007 21:08:21 -0700 (PDT), Vijaya Lakshmi
<[EMAIL PROTECTED]> wrote:
>
>Hi,
>Thank you very much for your response.I tried to convert SQLite2.1 version
>to SQlite3 version but unable to convert them .Could you please explain in
>which command prompt we need to convert them.
>From a command shell (CMD.EXE in windows).
With
>> sqlite2 yourv2.db .dump | sqlite3 yourv3.db
I mean:
sqlite2 = sqlite.exe, SQLite v2 command line program
yourv2.db = your v2 database
.dump = the SQLite command that dumps schema
and data to stdout
| = pipe symbol
sqlite3 = sqlite3.exe, SQLite v3 command line program
yourv3.db = the v3 database you might want to make.
>From given url we found only
>.exe file not software. We need software. If we convert them into SQLite3
>version we nee to change source code of .Net. So we don't want to convert
>them. Thats why we need SQLite2.1 version software.
The windows .dll for v 2.8.17 is still available from:
http://www.sqlite.org/sqlitedll-2_8_17.zip
(that is what I meant with: the download page doesn't list them,
but old versions are still available with the same naming scheme
as current versions). You might even be able to find v2.1 in
this way, but first you should try v2.8.17.
You can use the v2.8.17 sqlite.exe program to test if your
version 2.1 database is accessible from version 2.8.17.
>thank u
>vijaya
>
>
>Kees Nuyt wrote:
>>
>> [Default] On Thu, 25 Oct 2007 21:04:44 -0700 (PDT), Vijaya
>> Lakshmi <[EMAIL PROTECTED]> wrote:
>>
>>>Hi all,
>>> I need small help regarding software .Acutually my application was
>>>developed in SQLite2.1 by some body now i need SQLite2.1 version.Actually
>I
>>>found SQLite3 version but by using this software i am unable to run my
>>>application.please let me know from which site i can get SQLite2.1 version
>>>software.
>>>thank for ur help in advance.
>>>
>>>vijaya
>>
>> http://www.sqlite.org/download.html
>> Scroll to: Historical Binaries And Source Code
>>
>> You will find 2.8.17 there.
>> 2.8.17 is outdated but stable.
>> You should try 2.8.17, 2.1 is really obsolete.
>> See http://www.sqlite.org/cvstrac/timeline for changes, at the
>> bottom you can specify what you want to see.
>>
>> If 2.8.17 really is not an option for you, you'll have to try to
>> get an earlier version from CVS, or try to download an earlier
>> version by specifying the version you need by hand, using the
>> same naming scheme as the versions listed on the download page.
>> Often the older files are still there, just not listed anymore
>> on the download page.
>>
>> Upgrading to 3.5.1 might be less difficult than you first think,
>> and v2 databases can usually be converted easily to v3 with:
>> sqlite2 yourv2.db .dump | sqlite3 yourv3.db
>>
>> HTH
>> --
>> ( Kees Nuyt
>> )
>> c[_]
>>
>> -----------------------------------------------------------------------------
>> To unsubscribe, send email to [EMAIL PROTECTED]
>> -----------------------------------------------------------------------------
>>
>>
>>
--
( Kees Nuyt
)
c[_]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
