| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| Attachment | Content-Type | Size |
|---|---|---|
| frmWizard.frm.diff | text/plain | 2.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2003-01-24 11:52:43 | Re: Data migration plugin and mssql6 |
| Previous Message | Dave Page | 2003-01-23 14:28:22 | Re: list all parm for connection odbc |