Kbase 21909: Invalid column name 'suid' With Microsoft SQL Server 2000
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/03/2002 |
|
SUMMARY:
This Solution explains why the error below occurs when migrating a Progress database to a Microsoft SQL Server 2000 database.
Invalid column name 'suid'
EXPLANATION:
This only occurs when using the "Progress Db to ODBC" Schema Migration Tool from the ODBC Utilities.
The SUID column was present in the Sysusers table in SQL Server 6.
In SQL Server 7, it was replaced by the SID (Security Identification Number) column. It was only preserved for backward compatibility.
However in SQL Server 2000, the SUID column does not exist anymore.
Since the ODBC Utilities only support MS SQL Server 6, the Migration Tool referred to this SUID column.
SOLUTION:
Use the "Progress Db to MS SQL Server" Migration Tool from the MS SQL Server Utilities instead.