1. Add [Command line] Step to Pipeline and name it "Upgrade LocalDB"
2. Add this commands to the new step:
SqlLocalDB stop
SqlLocalDB delete
choco upgrade sqllocaldb
SqlLocalDB create
SqlLocalDB start
SqlLocalDB share MSSQLLocalDB MSSQLLocalDB
SqlLocalDB info MSSQLLocalDB
SQLCMD.EXE -S (localdb)\MSSQLLocalDB -Q "SELECT @@VERSION;"
Known issues:
In some cases the .NET Code cannot connect the LocalDB.
If LocalDB is used in .NET Core Services, then add EnableRetryOnFailure to UseSqlServer call
No comments:
Post a Comment
Note: only a member of this blog may post a comment.