VBA to T-SQL via TDD

Tagged

In this series of articles, I go step-by-step explaining how you can re-write VBA functions as SQL Server scalar functions to increase performance without the risk of introducing logic errors during the migration.

VBA to T-SQL via TDD: Step 10

Step 10. Repeat steps 8 & 9 until all tests pass

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 9

Step 9. Execute the test query in SQL Server

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 8

Step 8. Alter the scalar function to address failures

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 7

Step 7. Execute the test query in SQL Server to verify it fails

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 6

Step 6. Build a test query in SQL Server to return failing tests

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 5

Step 5. Create a dummy scalar function in SQL Server

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 4

Step 4. Use the results of your Access query to populate the test table

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 3

Step 3. Create a temporary test table in SQL Server

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 2

Step 2. Build a "test table population query" in Microsoft Access

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 1

Step 1. Identify or create test data in Microsoft Access

VBA to T-SQL via TDD

How to Convert a VBA Function to a SQL Server Scalar Function

MS Access Developers Can Remove All the Risk From This Complex Process With These 3 Words