Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3CB0E476BD2 for ; Tue, 28 Jan 2003 18:40:17 -0500 (EST) Received: from web20807.mail.yahoo.com (web20807.mail.yahoo.com [216.136.226.196]) by postgresql.org (Postfix) with SMTP id 25E3E477082 for ; Tue, 28 Jan 2003 17:36:15 -0500 (EST) Message-ID: <20030128223617.72040.qmail@web20807.mail.yahoo.com> Received: from [208.13.35.65] by web20807.mail.yahoo.com via HTTP; Tue, 28 Jan 2003 14:36:17 PST Date: Tue, 28 Jan 2003 14:36:17 -0800 (PST) From: Jeff Eckermann Subject: Re: converting microsoft sql server 2000 sql-code for postgresql 7.2.1 To: william windels , pgsql-sql@postgresql.org In-Reply-To: <000901c2c6b5$2deef350$240aa8c0@L1PC01> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/446 X-Sequence-Number: 11311 --- william windels wrote: > how can I convert sql-code , for microsoft sql > server 2000, to sql-code for > postgresql? > In addition to the suggestions given in other replies, have a look at PGAdminII: http://pgadmin.postgresql.org That is an excellent utility, and comes with a database migration utility (separate download) that will migrate MS SQL Server databases. __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com