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

– 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.