Attempting to perform Reverse Engineering on a SQL Server 2005 server, the following error occurs:
"Source CS3: Internal Error
Script: REDataMigatorDBMS08
Description: Invalid column name 'data compression'
Callstack: REDataMigatorDBMS08 from package 'Object RE Database for Microsoft SQL Server 2008"
May also get another error like:
"Source CS3: Internal Error
Script: REDataMigatorDBMS08
Description: Invalid object name 'sys.fulltext_stoplists'
Callstack: REDataMigatorDBMS08 from package 'Object RE Database for Microsoft SQL Server 2008"
Toad is attempting to connect to a SQL Server 2005, however, the setting in Toad was selected to connect to SQL Server 2008.
Restart Reverse Engineering Wizard and select “MS SQL Server 2005” from list of Data Sources.
