From: Terry Fielder <terry@ashtonwoodshomes.com>
To: Kenneth Gonsalves <lawgon@thenilgiris.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: migrating numeric to serial from MSSQL to postgres
Date: Sun, 15 Oct 2006 09:54:45 -0400
Message-ID: <45323DA5.1080601@ashtonwoodshomes.com> (raw)
In-Reply-To: <56210BFF-763D-4FC2-AA43-D514C19DB37F@thenilgiris.com>
References: <56210BFF-763D-4FC2-AA43-D514C19DB37F@thenilgiris.com>
I believe:
IDENTITY(1, 1) just means "Primary Key" in M$SQL
numeric 18,0 means a numeric field of zero decimal points. Hence we are
looking at a 18 byte integer. bigint is not big enough, so probably
should use the same in numeric 18,0 in postgres
There may be a way to get MSSQL to dump a SQL compliant dump, which
would make a migration to postgres much easier if your schema is large.
Without a SQL compliant dump, you have a lot of cleaning up/tweaking the
dump to make it readable by Postgres (but that's what I have done the
few times in the past I have had to do that, fortunately not for many
statements :)
Terry Fielder
terry@greatgulfhomes.com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Kenneth Gonsalves wrote:
> hi,
>
> am migrating a database from MSSQL to postgres. How would i migrate this:
>
> [Id] [numerc](18, 0) IDENTITY (1, 1)
>
> --
> regards
> kg
> http://lawgon.livejournal.com
> http://nrcfosshelpline.in/web/
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: terry@ashtonwoodshomes.com, lawgon@thenilgiris.com
Subject: Re: migrating numeric to serial from MSSQL to postgres
In-Reply-To: <45323DA5.1080601@ashtonwoodshomes.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox