Thanks for the video!! Is it possible to publish into another database, AdventureWorksTesting and copy AdventureWorks structure but empty? Thanks in advance ;)
@mariromero8133 What it seems like you're proposing is inverting the deployment. Sure, that would work. The main project right now deploys empty and is recreated locally, created from the project only and then the testing project is deployed into the main, clean, empty database. The point it to test your code, ensure the default data is in place, but also isolate concerns. Thanks for watching and commenting,.. please stay tuned and I'll reverse the deployment and you'll see there's really no change.
@@DBDesignArts It's a good solution. Thank you for your quick response. I was proposing deploying AdventureWorks project to an existing database and the testing project to a new empty database. However, I'm not sure if it is possible to create AdventureWorks objects, tsqlt objects and the tests in a new database. I'm new with VS, just thinking changing from SSMS to VS and analysing what VS can offer. Thank you for your videos. They really help me!
Great work!
Thanks for the video!! Is it possible to publish into another database, AdventureWorksTesting and copy AdventureWorks structure but empty? Thanks in advance ;)
@mariromero8133 What it seems like you're proposing is inverting the deployment. Sure, that would work. The main project right now deploys empty and is recreated locally, created from the project only and then the testing project is deployed into the main, clean, empty database. The point it to test your code, ensure the default data is in place, but also isolate concerns. Thanks for watching and commenting,.. please stay tuned and I'll reverse the deployment and you'll see there's really no change.
@@DBDesignArts It's a good solution. Thank you for your quick response. I was proposing deploying AdventureWorks project to an existing database and the testing project to a new empty database. However, I'm not sure if it is possible to create AdventureWorks objects, tsqlt objects and the tests in a new database. I'm new with VS, just thinking changing from SSMS to VS and analysing what VS can offer.
Thank you for your videos. They really help me!