REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on Linux

--_5045f853-6c73-4ed7-b6aa-158bb52c2d87_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Good
morning=2C 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=2C and this field is
paramount in my application for purposes of monitoring=2C postgresql 8.4
now also have the same timestamp but refers to other data (date +
time)=2C I investigated other
types of data such as (serial=2C uuid=2C xid=2C byte etc) in postgresql and
not get something just to replace it=2C I thought of a function that do
something similar but not yet tried=2C and of course I turn to you to see
if I can lend a hand with this rut that I have right now ....=A1

From: bcld-PkbjNfxxIARBDgjK7y7TUQ [at] public.gmane.org
To: pgsql-es-ayuda-RDL/qDirzP4Vy2MP9T7GeA [at] public.gmane.org=3B vepug-RDL/qDirzP4Vy2MP9T7GeA [at] public.gmane.org=3B pgsql-admin [at] po=
stgresql.org
Subject: REF : MIgracion de datos ms sql server 7.0 a Postgresql 8.4 en Lin=
ux
Date: Thu=2C 11 Feb 2010 12:58:46 +0000

Buenos dias=2C 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 =2C y este campo es
primordial en mi aplicacion para efectos del seguimiento=2C ahora en
postgresql 8.4 tambien tengo el mismo timestamp pero se refiere a otro
tipo de dato (fecha+hora )=2C he investigado otros tipo de datos tales
como (serial=2C uuid=2Cxid=2C bytea etc)en postgresql y no consigo algo igu=
al para
sustituirlo=2C he pensado en una funcion que realice algo parecido pero
todavia no lo intento=2C y por supuesto recurro a ustedes para ver si me
pueden echar una mano con este bache que tengo ahorita ....=A1

Saludos
Luis Dominguez

____________________________________________________________ _____

--_5045f853-6c73-4ed7-b6aa-158bb52c2d87_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style></style>
</head>
<body class=3D'hmmessage'>
 <span style=3D"backgrou=
nd-color: rgb(255=2C 255=2C 255)=3B" title=3D"Buenos dias=2C estoy en estos=
momentos en un proceso de migracion de una base de datos de un manejador m=
s 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" onmouseover=
=3D"this.style.backgroundColor=3D'#ebeff9'" onmouseout=3D"this.style.backgr=
oundColor=3D'#fff'">Good
morning=2C 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 <span styl=
e=3D"background-color: rgb(255=2C 255=2C 255)=3B" title=3D"campo binario un=
ico que se actualiza en forma aleatoria por fila =2C y este campo es primor=
dial en mi aplicacion para efectos del seguimiento=2C ahora en postgresql 8=
..4 tambien tengo el mismo timestamp pero se refiere a otro tipo de dato (fe=
cha+hora )=2C he investigado" onmouseover=3D"this.style.backgroundColor=3D'=
#ebeff9'" onmouseout=3D"this.style.backgroundColor=3D'#fff'">single
binary field that is updated randomly by row=2C and this field is
paramount in my application for purposes of monitoring=2C postgresql 8.4
now also have the same timestamp but refers to other data (date +
time)=2C I investigated <span style=3D"background-color: rgb(255=2C =
255=2C 255)=3B" title=3D"otros tipo de datos tales como (serial=2C uuid=2Cx=
id=2C bytea etc)en postgresql y no consigo algo igual para sustituirlo=2C h=
e pensado en una funcion que realice algo parecido pero todavia no lo inten=
to=2C y por supuesto recurro a ustedes para ver si" onmouseover=3D"this.sty=
le.backgroundColor=3D'#ebeff9'" onmouseout=3D"this.style.backgroundColor=3D=
'#fff'">other
types of data such as (serial=2C uuid=2C xid=2C byte etc) in postgresql and
not get something just to replace it=2C I thought of a function that do
something similar but not yet tried=2C and of course I turn to you to see
if <span style=3D"background-color: rgb(255=2C 255=2C 255)=3B" title=
=3D"me pueden echar una mano con este bache que tengo ahorita ....=A1" onmo=
useover=3D"this.style.backgroundColor=3D'#ebeff9'" onmouseout=3D"this.style=
..backgroundColor=3D'#fff'">I can lend a hand with this rut that I have righ=
t now ....=A1 <hr id=3D"stopSpelling">=
From: bcld-PkbjNfxxIARBDgjK7y7TUQ [at] public.gmane.org To: pgsql-es-ayuda-RDL/qDirzP4Vy2MP9T7GeA [at] public.gmane.org=3B vepug [at] postgr=
esql.org=3B pgsql-admin-RDL/qDirzP4Vy2MP9T7GeA [at] public.gmane.org Subject: REF : MIgracion de datos=
ms sql server 7.0 a Postgresql 8.4 en Linux Date: Thu=2C 11 Feb 2010 12=
:58:46 +0000 

<style>
..ExternalClass .ecxhmmessage P
{padding:0px=3B}
..ExternalClass body.ecxhmmessage
{font-size:10pt=3Bfont-family:Verdana=3B}
</style>

=3B Buenos dias=2C estoy en estos momentos en un =3B proces=
o
de migracion de una base de datos de un manejador ms sql server 7.0 =3B=
a
postgresql vesion 8.4 pero tengo un problema con un tipo de dato el
(timestamp) que en sql server 7.0 =3B se refiere a un campo binario uni=
co
que se actualiza en forma aleatoria por fila =2C y este campo es
primordial en mi aplicacion para efectos del seguimiento=2C ahora en
postgresql 8.4 tambien tengo el mismo timestamp pero se refiere a otro
tipo de dato (fecha+hora )=2C he investigado otros tipo de datos tales
como (serial=2C uuid=2Cxid=2C bytea etc)en postgresql y no consigo algo igu=
al para
sustituirlo=2C he pensado en una funcion que realice algo parecido pero
todavia no lo intento=2C y por supuesto recurro a ustedes para ver si me
pueden echar una mano con este bache que tengo ahorita ....=A1 Salud=
os Luis Dominguez <hr> <a href=3D"http://"></a> =

<hr /> <a href=3D'' target=3D'_new'></a></body>
</html>=

--_5045f853-6c73-4ed7-b6aa-158bb52c2d87_--

Luis Dominguez <bcld-PkbjNfxxIARBDgjK7y7TUQ [at] public.gmane.org> 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-createseq uence.html

-Kevin
--
TIP 1: para suscribirte y desuscribirte, visita http://archives.postgresql.org/pgsql-es-ayuda

This is a multi-part message in MIME format.

------=_NextPart_000_00B8_01CAAB3E.735B3640
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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=92t 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 [at] hotmail.com]
Enviado el: jueves, 11 de febrero de 2010 14:36
Para: pgsql-es-ayuda [at] postgresql.org; vepug [at] postgresql.org;
pgsql-admin [at] postgresql.org
Asunto: [ADMIN] REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 o=
n
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 hav=
e
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 i=
f
I can lend a hand with this rut that I have right now ....=A1

------=_NextPart_000_00B8_01CAAB3E.735B3640
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>

</style>

</head>

<body lang=3DES link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Hola Rafael.<o:p></o:p>

<o:p> </o:p>

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.<o:p></o:p>

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.<o:p></o:p>

<o:p> </o:p>

Espero haberte dado alguna idea.<o:p></o:p>

<o:p> </o:p>

<div>

<div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt =
0cm 0cm 0cm'>

De:</=
b> Luis =
Dominguez
[mailto:bcld [at] hotmail.com] 
Enviado el: jueves, 11 de febrero de 2010 14:36 
Para: pgsql-es-ayuda [at] postgresql.org; vepug [at] postgresql.org;
pgsql-admin [at] postgresql.org 
Asunto: [ADMIN] REF: Data Migration MS SQL Server 7.0 to =
PostgreSQL 8.4
on Linux<o:p></o:p>

</div>

</div>

<o:p> </o:p>

 
 
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 =
.....=A1 
 
 
<o:p></o:p>

</div>

</body>

</html>

------=_NextPart_000_00B8_01CAAB3E.735B3640--

REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on Linux

Re: [ADMIN] REF: Data Migration MS SQL Server 7.0 to

Re: REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on Linux