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 E246653518 for ; Fri, 6 May 2005 15:03:10 -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 53029-07 for ; Fri, 6 May 2005 18:03:03 +0000 (GMT) Received: from mta10.nationwireless.net (mta10.nationwireless.net [63.163.128.10]) by svr1.postgresql.org (Postfix) with ESMTP id DFADF5350F for ; Fri, 6 May 2005 15:03:01 -0300 (ADT) Received: from jfradkin [63.162.100.127] by mta10.nationwireless.net with ESMTP (SMTPD-8.20) id A15503F4; Fri, 06 May 2005 14:03:01 -0400 From: "Joel Fradkin" To: , "'pgsql-admin'" Subject: Re: Need help in data migration Date: Fri, 6 May 2005 14:03:13 -0400 Message-ID: <000001c55265$df4012e0$797ba8c0@jfradkin> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable In-Reply-To: <5944.64.165.0.91.1115400833.squirrel@datalong.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.583 tagged_above=0 required=5 tests=AWL, MSGID_DOLLARS X-Spam-Level: * X-Archive-Number: 200505/70 X-Sequence-Number: 17499 I wrote a program to move my data it is a .net app. If you are interested let me know and I can email It to you off list. It does some conversions specific to my scenario but you could comment = that out (like making all my isdeleted fields Boolean (I had a mixture of = stuff). Takes 6 hours to move over a 4 gig MSSQL data base. Does do txt fields. Joel Fradkin =20 Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 =20 jfradkin@wazagua.com www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized = review, use, disclosure or distribution is prohibited. If you are not the = intended recipient, please contact the sender by reply email and delete and = destroy all copies of the original message, including attachments. =20 =20 -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Michael Long Sent: Friday, May 06, 2005 12:34 PM To: pgsql-admin Subject: Re: [ADMIN] Need help in data migration > If you are interested give me a call or we can go back and forth here. > Please do it here as I may have a similar situation with SQL Server soon = and would like to learn from your experience. Thanks, mike ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org