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 5694F52A1F for ; Tue, 9 Aug 2005 10:13:47 -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 90955-02 for ; Tue, 9 Aug 2005 13:13:41 +0000 (GMT) Received: from mail.herbers.ca (unknown [64.56.146.199]) by svr1.postgresql.org (Postfix) with ESMTP id 37BA452936 for ; Tue, 9 Aug 2005 10:13:40 -0300 (ADT) Received: from localhost (unknown [127.0.0.1]) by mail.herbers.ca (herbers) with ESMTP id 0B4A91EE1A5; Tue, 9 Aug 2005 07:13:43 -0600 (MDT) Received: from mail.herbers.ca ([127.0.0.1]) by localhost (trusty.herbers.ca [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02480-01; Tue, 9 Aug 2005 07:13:40 -0600 (MDT) Received: from [10.1.2.51] (unknown [10.1.2.51]) by mail.herbers.ca (herbers) with ESMTP id 133CA1EE191; Tue, 9 Aug 2005 07:13:40 -0600 (MDT) Message-ID: <42F8AC04.2060403@herbers.ca> Date: Tue, 09 Aug 2005 07:13:40 -0600 From: James Herbers User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "josh@segrestfarms.com" , pgsql-admin@postgresql.org Subject: Re: SQL Server 2000 to PostgreSQL 8.0.3 References: <42F8A369.60402@segrestfarms.com> In-Reply-To: <42F8A369.60402@segrestfarms.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at herbers.ca X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.037 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200508/102 X-Sequence-Number: 18421 josh@segrestfarms.com wrote: > 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. > That backup is in Microsofts own format, PostgreSQL will not be able to read this. > 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. Use a program such as Aqua Data Studio (http://www.aquafold.com) to connect to the MSSQL db and export the data as INSERT statements. Then run the sql in PGAdmin. > > > Josh in Tampa > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings