pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedREF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on Linux
4+ messages / 4 participants
[nested] [flat]
* REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on Linux
@ 2010-02-11 13:36 Luis Dominguez <bcld@hotmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Luis Dominguez @ 2010-02-11 13:36 UTC (permalink / raw)
To: pgsql-es-ayuda@postgresql.org <pgsql-es-ayuda@postgresql.org>; vepug@postgresql.org <vepug@postgresql.org>; pgsql-admin
Good
morning, I am now in the process of migrating a database from a driver
ms sql server 7.0 to postgresql 8.4 vesion but I have a problem with
the data type (timestamp) SQL Server 7.0 that refers to a single
binary field that is updated randomly by row, and this field is
paramount in my application for purposes of monitoring, postgresql 8.4
now also have the same timestamp but refers to other data (date +
time), I investigated other
types of data such as (serial, uuid, xid, byte etc) in postgresql and
not get something just to replace it, I thought of a function that do
something similar but not yet tried, and of course I turn to you to see
if I can lend a hand with this rut that I have right now ....¡
From: bcld@hotmail.com
To: pgsql-es-ayuda@postgresql.org; vepug@postgresql.org; pgsql-admin@postgresql.org
Subject: REF : MIgracion de datos ms sql server 7.0 a Postgresql 8.4 en Linux
Date: Thu, 11 Feb 2010 12:58:46 +0000
Buenos dias, estoy en estos momentos en un proceso
de migracion de una base de datos de un manejador ms sql server 7.0 a
postgresql vesion 8.4 pero tengo un problema con un tipo de dato el
(timestamp) que en sql server 7.0 se refiere a un campo binario unico
que se actualiza en forma aleatoria por fila , y este campo es
primordial en mi aplicacion para efectos del seguimiento, ahora en
postgresql 8.4 tambien tengo el mismo timestamp pero se refiere a otro
tipo de dato (fecha+hora ), he investigado otros tipo de datos tales
como (serial, uuid,xid, bytea etc)en postgresql y no consigo algo igual para
sustituirlo, he pensado en una funcion que realice algo parecido pero
todavia no lo intento, y por supuesto recurro a ustedes para ver si me
pueden echar una mano con este bache que tengo ahorita ....¡
Saludos
Luis Dominguez
_________________________________________________________________
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on Linux
@ 2010-02-11 15:06 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Luis Dominguez <bcld@hotmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Kevin Grittner @ 2010-02-11 15:06 UTC (permalink / raw)
To: Luis Dominguez <bcld@hotmail.com>; pgsql-admin; pgsql-es-ayuda@postgresql.org <pgsql-es-ayuda@postgresql.org>; vepug@postgresql.org <vepug@postgresql.org>
Luis Dominguez <bcld@hotmail.com> wrote:
> I am now in the process of migrating a database from a driver
> ms sql server 7.0 to postgresql 8.4 vesion but I have a problem
> with the data type (timestamp) SQL Server 7.0 that refers to a
> single binary field that is updated randomly by row, and this
> field is paramount in my application for purposes of monitoring,
> postgresql 8.4 now also have the same timestamp but refers to
> other data (date + time), I investigated other types of data such
> as (serial, uuid, xid, byte etc) in postgresql and not get
> something just to replace it, I thought of a function that do
> something similar but not yet tried, and of course I turn to you
> to see if I can lend a hand with this rut that I have right now
Did you consider creating a SEQUENCE used by a trigger on update or
insert of a row?
http://www.postgresql.org/docs/8.4/interactive/sql-createsequence.html
-Kevin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on Linux
@ 2010-02-11 16:19 Iñigo Martinez Lasala <imartinez@vectorsf.com>
parent: Luis Dominguez <bcld@hotmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Iñigo Martinez Lasala @ 2010-02-11 16:19 UTC (permalink / raw)
To: pgsql-admin; +Cc: bcld@hotmail.com
Hola Rafael.
You could generate a UUID. There is a contrib module in contrib/uuid-ossp
with several functions in order to generate an UUID with different
algorithms, as documentation says.
If you don’t want to use these functions because you use an specific
format, perhaps they could serve you as example in order to create a
custom one.
Espero haberte dado alguna idea.
De: Luis Dominguez [mailto:bcld@hotmail.com]
Enviado el: jueves, 11 de febrero de 2010 14:36
Para: pgsql-es-ayuda@postgresql.org; vepug@postgresql.org;
pgsql-admin@postgresql.org
Asunto: [ADMIN] REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on
Linux
Good morning, I am now in the process of migrating a database from a
driver ms sql server 7.0 to postgresql 8.4 vesion but I have a problem
with the data type (timestamp) SQL Server 7.0 that refers to a single
binary field that is updated randomly by row, and this field is paramount
in my application for purposes of monitoring, postgresql 8.4 now also have
the same timestamp but refers to other data (date + time), I investigated
other types of data such as (serial, uuid, xid, byte etc) in postgresql
and not get something just to replace it, I thought of a function that do
something similar but not yet tried, and of course I turn to you to see if
I can lend a hand with this rut that I have right now ....¡
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [ADMIN] REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on Linux
@ 2010-02-12 17:21 Jenaro Centeno Gómez <jcenteno@aldia.com.mx>
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 4+ messages in thread
From: Jenaro Centeno Gómez @ 2010-02-12 17:21 UTC (permalink / raw)
To: pgsql-es-ayuda@postgresql.org
On 11/02/10 09:06, Kevin Grittner wrote:
> Luis Dominguez<bcld@hotmail.com> wrote:
>
>
>> I am now in the process of migrating a database from a driver
>> ms sql server 7.0 to postgresql 8.4 vesion but I have a problem
>> with the data type (timestamp) SQL Server 7.0 that refers to a
>> single binary field that is updated randomly by row, and this
>> field is paramount in my application for purposes of monitoring,
>> postgresql 8.4 now also have the same timestamp but refers to
>> other data (date + time), I investigated other types of data such
>> as (serial, uuid, xid, byte etc) in postgresql and not get
>> something just to replace it, I thought of a function that do
>> something similar but not yet tried, and of course I turn to you
>> to see if I can lend a hand with this rut that I have right now
>>
>
> Did you consider creating a SEQUENCE used by a trigger on update or
> insert of a row?
>
> http://www.postgresql.org/docs/8.4/interactive/sql-createsequence.html
>
> -Kevin
> --
> TIP 1: para suscribirte y desuscribirte, visita http://archives.postgresql.org/pgsql-es-ayuda
>
>
>
timestamp type in SQL Server is like ROWID in Oracle, and as Kevin said,
you could use the serial type as a replacement.
--
-------------------------------------------------------------------------------------------
L.A. Jenaro Centeno Gómez Al-Día Se renueva con la mejora continua.
Jefe de Tecnologías de la Información
Alimentos La Concordia, S.A. de C.V.
Tel. 01 474 741 9200
Ext. 9280
www.aldia.com.mx
Attachments:
jcenteno.vcf (text/x-vcard, 497B) download
begin:vcard
fn;quoted-printable:Jenaro Centeno G=C3=B3mez
n;quoted-printable:Centeno G=C3=B3mez;Jenaro
org;quoted-printable:Alimentos La Concordia, S.A. de C.V.;Tecnolog=C3=ADas de la Informaci=C3=B3n
adr;quoted-printable:La Marimba;;Loma de Prados No. 1332;Lagos de Moreno;Jal;47460;M=C3=A9xico
email;internet:jcenteno@aldia.com.mx
title;quoted-printable:Jefe de Tecnolog=C3=ADas de la Informaci=C3=B3n
tel;work:474 7419200 Ext. 9280
x-mozilla-html:TRUE
url:www.aldia.com.mx
version:2.1
end:vcard
end of thread, other threads:[~2010-02-12 17:21 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-02-11 13:36 REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on Linux Luis Dominguez <bcld@hotmail.com>
2010-02-11 15:06 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-02-12 17:21 ` Re: [ADMIN] REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on Linux Jenaro Centeno Gómez <jcenteno@aldia.com.mx>
2010-02-11 16:19 ` Iñigo Martinez Lasala <imartinez@vectorsf.com>
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