none
delete,update... query not converted with SSMA RRS feed

  • Question

  • I'm green in the SQL2008 world
    I did convert an access 2003 database having Delete, Update, Append.... query. Only the select query  and table were converted.
    SSMA seems not supporting special queries.

    where I need to create these special query in SQL2008. is it in Function, procedure,.... folder
    where can I find manual guide line conversion on the web
    Saturday, August 30, 2008 9:36 AM

Answers

All replies

  • Jean-Marc,

     

    Check out this link about migrating Access to SQL Server.

     

    You can convert special Access queries into stored procedures, views, user-defined functions and more.

     

    These are common DB objects in SQL Server 2000, SQL server 2005 and SQL Server 2008.

     

    Let us know if helpful.

    Saturday, August 30, 2008 12:47 PM
    Answerer
  • Thanks for this useful information.

    Little question

    When I save my store procedure it does not appear in Stored Procedures folder.
    Can you help me.
    I wrote my fist procedure with SQL2008 management studio.
    Thursday, September 4, 2008 10:19 AM
  •  Jean-Marc Flamand dit le_beluet wrote:
    Thanks for this useful information.

    When I save my store procedure it does not appear in Stored Procedures folder.
    Can you help me.
    I wrote my fist procedure with SQL2008 management studio.

     

    You have to compile it after saving it (or at any time) by hitting the EXECUTE button.

     

    Saving it to disk and compiling it into the server database are completely independent of each other.

     

    Compilation will create an execution plan, also stores the entire script in the database.  You can read it back from the database with sp_helptext for example.

     

    Let us know if works.

    Thursday, September 4, 2008 10:23 AM
    Answerer
  • It does works fine, Thanks
    Friday, September 5, 2008 9:56 AM
  • Sorry. That page seems to be removed. Can you please help me with the same issue in SQL Server 2017
    Monday, July 30, 2018 6:03 AM