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 1020552984 for ; Tue, 9 Aug 2005 09:54:20 -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 21567-03 for ; Tue, 9 Aug 2005 12:54:14 +0000 (GMT) Received: from vms040pub.verizon.net (vms040pub.verizon.net [206.46.252.40]) by svr1.postgresql.org (Postfix) with ESMTP id 538955293D for ; Tue, 9 Aug 2005 09:54:11 -0300 (ADT) Received: from jfradkin ([66.15.127.235]) by vms040.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0IKY00LEEH6FGTAC@vms040.mailsrvcs.net> for pgsql-admin@postgresql.org; Tue, 09 Aug 2005 07:54:15 -0500 (CDT) Date: Tue, 09 Aug 2005 08:56:02 -0400 From: "Joel Fradkin" Subject: Re: SQL Server 2000 to PostgreSQL 8.0.3 In-reply-to: <42F8A369.60402@segrestfarms.com> To: , Message-id: <001501c59ce1$b2f9b0d0$797ba8c0@jfradkin> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.877 tagged_above=0 required=5 tests=AWL, MSGID_DOLLARS X-Spam-Level: ** X-Archive-Number: 200508/101 X-Sequence-Number: 18420 I am pretty sure a backup from sql is not going to restore on postgres. I wrote a .net application that read from one and wrote to the other. Does not like tables large then memory available though, since npgsql = .net components by default uses a read whole table approach (there is a = cursor way, but I never got that implemented). If you are .net savy and want the source for the conversion let me know = and I will forward off list. I am sure there are other methods as well (maybe dump to a csv file and = try reading that with aqua studio). 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 = josh@segrestfarms.com Sent: Tuesday, August 09, 2005 8:37 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] SQL Server 2000 to PostgreSQL 8.0.3 Greetings. I am having difficulty moving a SQL Server 2000 database over to=20 PostgreSQL 8.0.3. In SQL Server, I am performing a backup of the database I want to move. = I save that backup on my Desktop. I am then opening up PGAdminIII and attempting to perform a Restore of=20 the database saved on my Desktop. The first step I take is to create a=20 new database, MyDB. Next, I highlight my new database and then select=20 Restore from the Tools menu. The Restore Database window pops up and I=20 Browse to the database backup I've saved on my Desktop. After selecting = the backup, the 'OK' button stays grayed and I am unable to proceed. Any ideas as to how I can work around this? Thanks in advance. Josh in Tampa ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings