Re: Data migration plugin and mssql6

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: Brage Førland <brage(at)zoo(dot)uib(dot)no>, <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Data migration plugin and mssql6
Date: 2003-01-24 11:52:43
Message-ID: 03AF4E498C591348A42FC93DEA9661B8259B23@mail.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

> -----Original Message-----
> From: Brage Førland [mailto:brage(at)zoo(dot)uib(dot)no]
> Sent: 23 January 2003 14:50
> To: pgadmin-hackers(at)postgresql(dot)org
> Subject: [pgadmin-hackers] Data migration plugin and mssql6
>
>
> 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).

Thanks, patch applied to CVS.

> 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.

Hmm, odd - it works fine here with a fresh tarball opened by VB6, SP5...

How did you unpack it?

Regards, Dave.

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Vella Carmine 2003-01-24 18:34:00 Unicode problem with Clent-Server Application
Previous Message Brage Førland 2003-01-23 14:50:13 Data migration plugin and mssql6