1. Open Visual Studio
2. Create a new project and select SQL Server and select "SQL Server Database Project".
3. Right Click Solution and select Schema Compare.
4. Select the Source and Destination Database.
5. Click compare. and see the changes between the source and destination database.
6. Click update to update the destination database. you will see the generated .sql files in the project dbo folder.
7. If you want to load data with that .sql files then right-click the Solution Explorer and click publish.
8. You can also import Database and .sql script to project.
9. Right-click solution and click publish export .sql script to database.
2. Create a new project and select SQL Server and select "SQL Server Database Project".
3. Right Click Solution and select Schema Compare.
4. Select the Source and Destination Database.
5. Click compare. and see the changes between the source and destination database.
6. Click update to update the destination database. you will see the generated .sql files in the project dbo folder.
7. If you want to load data with that .sql files then right-click the Solution Explorer and click publish.
8. You can also import Database and .sql script to project.
9. Right-click solution and click publish export .sql script to database.
