This explains how to use the new integration between Redgate Data Modeler (RGDM) and SQL Compare. Follow these steps to compare your physical SQL Server data model with a database and synchronize the changes. 

Step 1: Access Redgate Data Modeler 

Go to https://datamodeler.redgate-platform.com/login and log in with your credentials. If you don’t have an account, click Sign up to create a trial account. 

Step 2: Create or Select a Physical SQL Server Model 

After logging in, create a new physical SQL Server model in RGDM. Refer to the documentation for getting started with physical models. 

Step 3: Obtain Your API Token 

In RGDM, click your profile icon and go to Settings. Under Integration, copy your API Token. 

Step 4: Start a New Project in SQL Compare 

Open SQL Compare and start a new project. In the Data sources tab, select Redgate Data Modeler Model as your source.  

Paste your API Token and select your model. 

Step 5: Choose Your Target Database 

On the right side, select your target SQL Server database. Enter server details and authentication method. 

Step 6: Run the Comparison 

Click Compare now. SQL Compare will register the source and target, then begin the comparison process. 

Step 7: Filter File and review differences 

Please note: The new project filter file has been configured to only include objects supported by RGDM which includes sequences, tables, and views. Review the differences between the data model and the target.  

Step 8: Synchronize Changes (Optional) 

After reviewing the differences, you can generate a deployment script to synchronize your database with the model. 

Please note that it is only possible to synchronize one way i.e. you cannot deploy to a Redgate Data Model.