trigger or stored procedures


  • Hello everyone,

    I am new to SQL Server.

    What kinds of measures should I take before converting MS Access 2010 to SQL Server 2008 R2?

    What is the better way to do it?

    I would like to convert my MS Access 2010 to SQL Server 2008 R2 but I do not know what will be the Ms Access Macro.

    Should I convert the Macro to trigger or Macro to Stored Procedure?

    Thank you for your help!

    Tuesday, October 01, 2013 4:22 PM


All replies

  • The best tool to help in your migration is SSMA for Access.

    Access Macros would typically be ported to Stored Procedures.



    Tuesday, October 01, 2013 4:24 PM
  • Should I convert the Macro to trigger or Macro to Stored Procedure?

    A trigger is a special kind of stored procedure. In a VBA macro you can implement logical, which may can't be migrated to T-SQL.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, October 01, 2013 4:44 PM
  • You need assistance that cannot adequately provided via a forum and its Q&A format.  I suggest you first conduct an internet search for migrating from access to sql server.  You should find many articles that discuss the process and the implications of moving between the 2 enviroments.  In addition, it sounds like you need some basic education in relational databases - a conversion is a good time to review your data model and make the adjustments and corrections to move into a fully relational database engine.  You might also want to read the SSMA msdn blog - a link to a 2 part migration series is below

    ssma blog - migration part 1

    Tuesday, October 01, 2013 5:31 PM
  • Thank you so much! I am ready the links to understand better.

    Tuesday, October 01, 2013 6:54 PM