how to test the process that updates a SQL server table with data from another SQL server?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › how to test the process that updates a SQL server table with data from another SQL server?

Viewing 1 reply thread
  • Author
    Posts
    • May 27, 2010 at 7:16 AM #24820
      community-content

        I am learning BizTalk. 

        1. I have created a generated item from a select query, a generated item from a update stored procedure. 
        2. I have created a map for those two schemas automatically generated from step 1.
        3. I have created a Orchestration with a receive port to receive the select message, a send port to send the update message.
        4. I have built and deployed the project. 
        5. I have configured the application on BizTalk server.

        How do I test it?  I know, with flat file receive message, I copy and paste the flat file to the receive folder.  How should I start this one?

        Your help will be highly appreciated.

        Lynn

      • May 27, 2010 at 12:44 PM #24823
        community-content

          – Copy the SQL Artifacts (tables, stored procs) to a test database

          – populate the table from which you select data w/ sample data (maybe use one record to start)

          – run your biztalk solution (turn on the send/rec ports and orchestrations)

          – verify that your update stored proc worked as expected.

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.