Doorgaan naar hoofdcontent
Synchronize databases

When you want to synchronize master data between SQL databases in different environments, you can easily generate a script for this with SSMS 2017. Just select the database, right mouse click and choose: Tasks => Generate script => Set scripting options => Advanced Scripting options: and change a setting from Types of data to "Schema AND data". A T-SQL script will be generated with both the table structure and the INSERT INTO statements.

Reacties

Een reactie posten

Populaire posts van deze blog

How to keep track of your continuous learning? I try it with a scrum board:  https://trello.com/b/OIuiA3Ql/study
Een reactie posten
Meer lezen

Settings for CodedUI in Visual Studio 2017

When working with CodedUI and SpecFlow, it can be important to have it run as a 32-bits process. I spend quite some time finding the correct setting in Visual Studio for a project that was not running the tests. It appeared I needed to change the following test setting: from the Menu in Visual Studio, choose Test\Test settings\Default Processor Architecture: X86 (so not: X64!). The same can be said for all other test types run from the Test Explorer, like unit tests.
Een reactie posten
Meer lezen