X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E4CAB5289B for ; Tue, 9 Aug 2005 16:02:17 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31283-07 for ; Tue, 9 Aug 2005 19:02:13 +0000 (GMT) Received: from mail.segrestfarms.com (unknown [65.124.195.241]) by svr1.postgresql.org (Postfix) with SMTP id 39B9E5288B for ; Tue, 9 Aug 2005 16:02:11 -0300 (ADT) Received: (qmail 4681 invoked by uid 399); 9 Aug 2005 19:00:15 -0000 Received: from unknown (HELO njord.segrestfarms.com) (65.124.195.227) by 65-124-195-241.dia.cust.qwest.net with SMTP; 9 Aug 2005 19:00:15 -0000 Received: from [192.100.100.176] (unknown [192.100.100.176]) by njord.segrestfarms.com (Postfix) with ESMTP id 2351D80AE1E; Tue, 9 Aug 2005 19:08:55 -0400 (EDT) Message-ID: <42F8FD9B.2090908@segrestfarms.com> Date: Tue, 09 Aug 2005 15:01:47 -0400 From: "josh@segrestfarms.com" User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Ben Kim Cc: pgsql-admin@postgresql.org Subject: Re: SQL Server 2000 to PostgreSQL 8.0.3 References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.803 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_IN_DSBL X-Spam-Level: ** X-Archive-Number: 200508/118 X-Sequence-Number: 18437 I have successfully moved the schema over to PostgreSQL. Now I am working on the data. In reviewing my tables, I found that for some strange reason a handful of fields are not double-quoted. Strange quirk: -- Table: "Orders" -- DROP TABLE "Orders"; CREATE TABLE "Orders" ( "OrderID" int4 NOT NULL, "CustomerID" int4 NOT NULL, "DateCreated" timestamptz, "TotalPrice" numeric(19,4), "ShipAddressID" int4, "ShipDate" timestamptz, "ShippingMethod" varchar(50), "sfrepID" varchar(50), "StatusID" int4, "TrackingNumber" varchar(50), ponumber varchar(50), <--------------HERE "Comment" char(254), "sfOrderNumber" varchar(50), "UpdateDate" timestamptz ) WITH OIDS; ALTER TABLE "Orders" OWNER TO postgres; What to make of this strangeness? Ben Kim wrote: >Here's my 2 cents. > >If you have access to DTS in SQL Server 2000, it will be one convenient >solution for simple transfer. > >It's a matter of creating a new task, defining the SQL Server database as >source and PostgreSQL database as destination, and clicking through. There >will be some mismatches in data types, but you can convert data using >scripts inisde the DTS task on the fly. > > >Regards, > >Ben Kim >Developer >College of Education >Texas A&M University > > > > >