Skip site navigation (1) Skip section navigation (2)

Data migration plugin and mssql6

From: Brage Førland <brage(at)zoo(dot)uib(dot)no>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Data migration plugin and mssql6
Date: 2003-01-23 14:50:13
Message-ID: 20030123155013.A5152@sisyfos.zoo.uib.no (view raw or flat)
Thread:
Lists: pgadmin-hackers
The Database Migration Wizard does not work for MS SQL Server < 7 because of
the query used to identify autoincrement columns. 

The problem is the dependence on the 'sysindexes' relation to indentify
indexes, which do not exists in versions prior to 7.0. The join to
sysindexes is AFAIK superfluous and can be removed. The attaced patch is
works with MSSQL 6.5, but have not been tested on MSSQL 7.0 (but should
work).

BTW, you might want to add a note to the CVS web interface that the tarball
is not directy usable by Visal Studio, because it chokes on the unix text
format in the checked out files.

   -Brage
   
   

pgadmin-hackers by date

Next:From: Dave PageDate: 2003-01-24 11:52:43
Subject: Re: Data migration plugin and mssql6
Previous:From: Dave PageDate: 2003-01-23 14:28:22
Subject: Re: list all parm for connection odbc

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group