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 AB6F152ADC for ; Tue, 9 Aug 2005 10:39:59 -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 84699-04 for ; Tue, 9 Aug 2005 13:39:54 +0000 (GMT) Received: from mail.udaff.com (unknown [81.176.66.242]) by svr1.postgresql.org (Postfix) with ESMTP id 2B68652936 for ; Tue, 9 Aug 2005 10:39:50 -0300 (ADT) Received: from idbh.ru (localhost [127.0.0.1]) by mail.udaff.com (Postfix) with SMTP id 67260F41137; Tue, 9 Aug 2005 17:38:13 +0400 (MSD) Received: by mail.udaff.com (Postfix, from userid 8145) id 21599F41161; Tue, 9 Aug 2005 17:38:13 +0400 (MSD) Received: from [192.168.1.229] (office.chronopay.com [62.231.31.86]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by mail.udaff.com (Postfix) with ESMTP id 97D00F41137; Tue, 9 Aug 2005 17:38:12 +0400 (MSD) Message-ID: <42F8B1A7.9000105@udaff.com> Date: Tue, 09 Aug 2005 17:37:43 +0400 From: Sergey Moiseev User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Cc: "josh@segrestfarms.com" 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-SpamTest-Info: Profile: Formal (256/050803) X-SpamTest-Info: Profile: Detect Standard No RBL (4/030526) X-SpamTest-Info: Profile: SysLog X-SpamTest-Info: Profile: Marking Spam - Subject (2/030321) X-SpamTest-Status: Not detected X-SpamTest-Version: SMTP-Filter Version 2.1.0 [0143], SpamtestISP/Release X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200508/178 X-Sequence-Number: 18497 josh@segrestfarms.com wrote: > 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. As already mentioned, there is no unified backups for DBMS. You may move structure and data, but not stored procedures and triggers, by installing postgresql-odbc on mssql server machine and using export/import tools from enterprise manager of mssql to export from mssql and import into postgresql-odbc connection. For user types, triggers, storeds you'll need to do rewrite it by hands. -- Wbr, Sergey Moiseev