Re: SQL Server 2000 to PostgreSQL 8.0.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



josh@xxxxxxxxxxxxxxxx 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




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux