Mitchell Vincent wrote:
Fantastic idea, but I'm afraid this will all be on Windows. I'll see
about getting a sed-like program to distribute with my converter,
though, thanks!!
check out http://unxutils.sourceforge.net/ for a Win32 version of sed
--
J. Scott Wilkinson
On 3/9/07, Scott Hess <[EMAIL PROTECTED]> wrote:
On 3/9/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote:
> I'm looking into ways of changing the schema type name when I do my
> SQLite2->SQLite3 conversion. Most likely I'll have to pipe the .dump
> from the SQLite2 db through a program to replace '
On 3/9/07, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
If you don't have the word varchar anyplace else, e.g. in your data, you can
simply do:
sqlite OLD.DB .dump | sed 's/varchar/text/' | sqlite3 NEW.DB
If the word varchar may exist elsewhere, or be in various cases (VARCHAR,
Varchar, etc.
On 3/9/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote:
I'm looking into ways of changing the schema type name when I do my
SQLite2->SQLite3 conversion. Most likely I'll have to pipe the .dump
from the SQLite2 db through a program to replace 'varchar' with
'text'... I'm working on that now!
You
"Mitchell Vincent" <[EMAIL PROTECTED]> writes:
> I have an old SQLite 2.8 database that shared it's schema with
> PostgreSQL. One of the nifty things about PostgreSQL (that admittedly
> has me spoiled) is the ability to just say "varchar" without any
> length specifier.
>
> Specifying "varchar" in
On 3/9/07, Christian Werner <[EMAIL PROTECTED]> wrote:
Mitchell Vincent wrote:
>
> I have an old SQLite 2.8 database that shared it's schema with
> PostgreSQL. One of the nifty things about PostgreSQL (that admittedly
> has me spoiled) is the ability to just say "varchar" without any
> length spe
Mitchell Vincent wrote:
>
> I have an old SQLite 2.8 database that shared it's schema with
> PostgreSQL. One of the nifty things about PostgreSQL (that admittedly
> has me spoiled) is the ability to just say "varchar" without any
> length specifier.
>
> Specifying "varchar" in SQLite works great
On 3/9/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"Mitchell Vincent" <[EMAIL PROTECTED]> wrote:
>
> Now comes the fun part. I'm converting these databases (and there are
> a LOT of them), I'm doing "sqlite OLD.DB .dump | sqlite3 NEW.DB" which
> works flawlessly. Is there any way to change t
"Mitchell Vincent" <[EMAIL PROTECTED]> wrote:
>
> Now comes the fun part. I'm converting these databases (and there are
> a LOT of them), I'm doing "sqlite OLD.DB .dump | sqlite3 NEW.DB" which
> works flawlessly. Is there any way to change the schema on the fly to
> say "Varchar(1024)" instead of
I have an old SQLite 2.8 database that shared it's schema with
PostgreSQL. One of the nifty things about PostgreSQL (that admittedly
has me spoiled) is the ability to just say "varchar" without any
length specifier.
Specifying "varchar" in SQLite works great - no problem at all. Until
I tried to
10 matches
Mail list logo