• State Verified Answer
  • Replies 9 replies
  • Answers 1 answer
  • Subscribers 8 subscribers
  • Views 4208 views
  • Users 0 members are here
Options
Related

ApexSQL Diff cannot recognize 'forcescan' keywords

kchung
over 3 years ago

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

Parents
  • 0 over 3 years ago

    Another issue, I check "Script USE for database" and Add header but it is no different in the sync script output. i.e. There is no USE statement generate at the start of file. 

  • 0 over 3 years ago in reply to kchung

    Hi Kelvin, we might have an bug here but to handtle this the proper way, please go to support.quest.com and log a Service Request. We will be involving def on this.

  • 0 over 3 years ago in reply to nodier garcia

    I did send the request to support, see  Message ID: [QSE001ENU] in your system. 

    It is obvious whenever my SP has 'forcescan' keywords I will got a parse error.

    However, the support staff return me 2 times and told me it may be a file or database "Permission error" and said he can't reproduce it even though I give him the file.

    Hello, first there is no database involves, I compare file folders with other file folders. Second, if the file has permission will not able to open that file and report parse error for that line at the beginning.

    I am starting to lose confidence for the support.

Reply
  • 0 over 3 years ago in reply to nodier garcia

    I did send the request to support, see  Message ID: [QSE001ENU] in your system. 

    It is obvious whenever my SP has 'forcescan' keywords I will got a parse error.

    However, the support staff return me 2 times and told me it may be a file or database "Permission error" and said he can't reproduce it even though I give him the file.

    Hello, first there is no database involves, I compare file folders with other file folders. Second, if the file has permission will not able to open that file and report parse error for that line at the beginning.

    I am starting to lose confidence for the support.

Children