The simple way to get up and running is to use LocalDB, so no install, no worries with Express and a service running, just use LocalDB. If you were working with a project for C# or ASP.NET and wanted to include the database, the idea was to keep things simple. If I connect with those credentials, this will appear in the SSMS Object Explorer as well, the same as any other instance.Īs an early part of the SCA product, when it was in ReadyRoll, there was a desire to not impose burdens on application developers. In fact, if you want, you can connect to this with SSMS. Other than that, it’s a real SQL Server instance that is running. LocalDB is a version of SQL Server that is spun up in process, rather than a service. In my case, I’ve actually got a few different instances since I’ve been working with the SQL Change Automation (SCA) for years, across a few versions.Īs the instance names list, these are LocalDB instances. If you’re wondering, this is what you see in Visual Studio 2017, for the SQL Server Object Explorer. After setting up a new PoC (Proof of Concept), they were confused about why there is a new entry in their list of SQL Servers. I got this question recently from someone that was evaluating the SQL Change Automation client in Visual Studio.
0 kommentar(er)
