Re: scripts de sql convertir a postgresql

Luis Nieto escribió:
> saludos
>
> me pueden ayudar a convertir este scripts que esta hecho en sqlserver
> necesito para un proyecto, o si me puedes informar de una herramientas
> que me permita convertir a un scripts de postgresql... no importa si
> no lo hace en su totalidad pero me puede servir cualquier informacion
> que me puedan brindar...
>
> /************************************************************/
> /***** Initialization Script *****/
> /***** *****/
> /***** *****/
> /***** Note: To manually execute this script you must *****/
> /***** perform a search and replace operation *****/
> /***** for {databaseOwner} and {objectQualifier} *****/
> /***** *****/
> /************************************************************/
>
> if exists (select * from dbo.sysobjects where id =
> object_id(N'Version') and OBJECTPROPERTY(id, N'IsTable') = 1)
> begin
> if '{objectQualifier}' <> ''
> begin
> EXECUTE sp_rename N'{databaseOwner}Version',
> N'{objectQualifier}Version', 'OBJECT'
> EXECUTE sp_rename N'PK_Version', N'PK_{objectQualifier}Version',
> 'OBJECT'
> EXECUTE sp_rename N'IX_Version', N'IX_{objectQualifier}Version',
> 'INDEX'
>
> ALTER TABLE {databaseOwner}{objectQualifier}Version ADD CONSTRAINT
> IX_{objectQualifier}Version UNIQUE NONCLUSTERED
> (
> Major,
> Minor,
> Build
> ) ON [PRIMARY]
> end
> end
> else
> begin
> if not exists (select * from dbo.sysobjects where id =
> object_id(N'{objectQualifier}Version') and OBJECTPROPERTY(id,
> N'IsTable') = 1)
> begin
> CREATE TABLE {databaseOwner}{objectQualifier}Version (
> [VersionId] [int] IDENTITY (1, 1) NOT NULL ,
> [Major] [int] NOT NULL ,
> [Minor] [int] NOT NULL ,
> [Build] [int] NOT NULL ,
> [CreatedDate] [datetime] NOT NULL
> ) ON [PRIMARY]
>
> ALTER TABLE {databaseOwner}{objectQualifier}Version WITH NOCHECK ADD
> CONSTRAINT [PK_{objectQualifier}Version] PRIMARY KEY CLUSTERED
> (
> [VersionId]
> ) ON [PRIMARY]
>
> ALTER TABLE {databaseOwner}{objectQualifier}Version ADD CONSTRAINT
> IX_{objectQualifier}Version UNIQUE NONCLUSTERED
> (
> Major,
> Minor,
> Build
> ) ON [PRIMARY]
>
> end
> end
> GO
>
> if exists (select * from dbo.sysobjects where id =
> object_id(N'{objectQualifier}GetDatabaseVersion') and
> OBJECTPROPERTY(id, N'IsProcedure') = 1)
> drop procedure {databaseOwner}{objectQualifier}GetDatabaseVersion
> GO
>
> create procedure {databaseOwner}{objectQualifier}GetDatabaseVersion
>
> as
>
> select Major,
> Minor,
> Build
> from {objectQualifier}Version
> where VersionId = ( select max(VersionId) from {objectQualifier}Version )
>
> GO
>
> if exists (select * from dbo.sysobjects where id =
> object_id(N'{objectQualifier}FindDatabaseVersion') and
> OBJECTPROPERTY(id, N'IsProcedure') = 1)
> drop procedure {databaseOwner}{objectQualifier}FindDatabaseVersion
> GO
>
> create procedure {databaseOwner}{objectQualifier}FindDatabaseVersion
>
> @Major int,
> @Minor int,
> @Build int
>
> as
>
> select 1
> from {objectQualifier}Version
> where Major = @Major
> and Minor = @Minor
> and Build = @Build
>
> GO
>
> if exists (select * from dbo.sysobjects where id =
> object_id(N'{objectQualifier}UpdateDatabaseVersion') and
> OBJECTPROPERTY(id, N'IsProcedure') = 1)
> drop procedure {databaseOwner}{objectQualifier}UpdateDatabaseVersion
> GO
>
> create procedure {databaseOwner}{objectQualifier}UpdateDatabaseVersion
>
> @Major int,
> @Minor int,
> @Build int
>
> as
>
> insert into {objectQualifier}Version (
> Major,
> Minor,
> Build,
> CreatedDate
> )
> values (
> @Major,
> @Minor,
> @Build,
> getdate()
> )
>
> GO
>
> de antemano gracias por su respuesta.... me podrian enviar a mi email....
>
> attt
>
> luis
>
>
> ------------------------------------------------------------------------
>
> Yahoo! MTV Blog & Rock
> ¡Cuéntanos tu historia, inspira una canción y gánate un viaje a los
> Premios MTV!
> Participa aquí http://mtvla.yahoo.com/
Creo que por ahí circula una herramienta llamada "Cerebro", hay varias
versiones con varias capacidades. :D

Ya en serio, dale una leída al manual. Y si tienes dudas entonces preguntas.

http://www.postgresql.org/docs/8.3/interactive/index.html

Saludos.