Post reply

Upsizing Wizard from Access 2k3 to SQL 2005 SP1 (Product 8.0.760 SP3)

  • August 8, 2008 at 9:09 am

    #855289

    Scott MacCready (5/6/2008)

    Also, you should look at the Sql Server Reporting Services (SSRS) for reports.

    Scott, excellent choice. I've been successful thus far in converting all the tables and queries, and even converting 1 into a web page using Reporting Services. No issues. the SSMA has been working as expected.

    1 observation, to you or anyone. I converted the following query using SSMA:

    SELECT [Library Information Table].Library, [Library Information Table].Branch

    the result it came back with was:

    SELECT TOP 9223372036854775807 WITH TIES [Library Information Table].Library, [Library Information Table].Branch

    Why did it convert to:

    SELECT TOP 9223372036854775807 WITH TIES ????

    :unsure:

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply