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 08F405293D for ; Tue, 9 Aug 2005 09:37:15 -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 10716-06 for ; Tue, 9 Aug 2005 12:37:09 +0000 (GMT) Received: from mail.segrestfarms.com (unknown [65.124.195.241]) by svr1.postgresql.org (Postfix) with SMTP id 8583A52AEF for ; Tue, 9 Aug 2005 09:37:07 -0300 (ADT) Received: (qmail 11646 invoked by uid 399); 9 Aug 2005 12:35:13 -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 12:35:13 -0000 Received: from [192.100.100.176] (unknown [192.100.100.176]) by njord.segrestfarms.com (Postfix) with ESMTP id 4C1D580AE1E for ; Tue, 9 Aug 2005 12:42:26 -0400 (EDT) Message-ID: <42F8A369.60402@segrestfarms.com> Date: Tue, 09 Aug 2005 08:36:57 -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: pgsql-admin@postgresql.org Subject: SQL Server 2000 to PostgreSQL 8.0.3 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.815 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, RCVD_IN_DSBL X-Spam-Level: ** X-Archive-Number: 200508/100 X-Sequence-Number: 18419 Greetings. I am having difficulty moving a SQL Server 2000 database over to 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 the database saved on my Desktop. The first step I take is to create a new database, MyDB. Next, I highlight my new database and then select Restore from the Tools menu. The Restore Database window pops up and I 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