Test Database Install
The Test Database 🗗 folder contains the RedGate SQL Source Control. Use this database for creating and testing checks. If you are not going to be developing sp_Develop 🗗 checks you can skip this page.
SQL Server 2008+ is supported. You can script out the test database and downgrade schema features like DATETIME2 that is not supported. SQL Server Developer editions are now free, go download 🗗 and install the latest version for development.
Quick Steps to Setup and Use:
- Create new database ‘spDevelopTest’ and select in Object Browser
- Open Redgate SQL Source Control in SQL Server Management Studio
- Click ‘Setup’ tab
- Select ‘Link to my source control system’ and click ‘Next’
- Browser to ‘..\Test Database’ cloned folder and click ‘Link’
- Click ‘Get latest’ tab
- Pull or refresh if required and click ‘Apply changes’ button
- Develop objects to use when you create a new check
- Click ‘Commit’ tab
- Select objects to be pulled back into the branch, add comment, click the ‘Commit’ button and click the ‘Push’ button
- Note: there are exclude filters setup for invalid objects created in the post script. Do not check these objects back into the branch.