Hi,
I just download and evaluate ApexSQL for my company. I export one of our DB to SQL script, modify it and compare with the original script directory
One of our databases got the following parse error.
Parsing errors: Parse error: [Incorrect syntax near 'forcescan'] at [position: 47009, line: 554, column: 56]
...
dbo.sdct_OR_MailClassLookup mcl3 with (forcescan) on mcl3.MailClassID = upl.MailClassID left join
dbo.sdct_OR_TrackingEventMapGlobalPost
mgp with (forceseek) on pu.TrackingName = mgp.OriginalEventName and
...
<DatabaseSettings>
<Collation>SQL_Latin1_General_CP1_CI_AS</Collation>
<ServerVersion>Sql2014</ServerVersion>
<ServerName>xxx</ServerName>
<DatabaseName>ClientSupportServicesDb</DatabaseName>
</DatabaseSettings>
Let me know this keyword is supported or not.
Thanks.
- Kelvin