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

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 (view raw or flat)
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

pgadmin-hackers by date

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

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