Database Deployment in Visual Studio

A software project should have a database. You can use SQL or no-SQL database. You choose SQL when you work with structured data that should have specific constraint and schema. You choose no-SQL if you prefer a simple and high-performance data access. Visual Studio officially support both databases. On this article, we discuss what database option that we have and how to choose the correct option. SQL Database You have a lot of options to deploy SQL-based database. We will focus on two main approaches in this post. SQL database that can be embedded in the application. If you build a desktop software that run on top of Windows. You can use Microsoft Access. If you build a web that run on top of Windows based hosting. You can use SQL Compact Edition. You can install the extension on the visual studio marketplace SQL Database that should deployed separately in the application. If you build a web that build the database from the scratch or existing SQL script, you can use the SQL Database Project If you build a web that use code-first design, you can use Code First to a New Database - EF6 | Microsoft Docs You can deploy both database to Microsoft Azure and your on-premises environment. You can do the deployment process through SQL Server Management Studio or Visual Studio Server explorer or publish profile. medianet_width = "600"; medianet_height = "250"; medianet_crid = "858385152"; medianet_versionId = "3111299"; No SQL Database Unfortunately, there is no built-in support for No SQL Database. This is because the NO SQL database is simple enough to install and to implement by using NuGet package manager. My first choice is to use Mongo DB. You can install the extension of Mongo DB Mongo DB Tools - Visual Studio Marketplace If you want to deploy into the cloud you can use Cosmos DB. You can visit NuGet Gallery | Microsoft.Azure.DocumentDB 2.13.1 medianet_width = "600"; medianet_height = "250"; medianet_crid = "858385152"; medianet_versionId = "3111299";

Not Working Access OLE DB in Visual Studio 2019

Problem If you are working with the Access Database for your desktop application. You might find the Access OLE DB is not working properly. You can't access the file through server explorer. However, you can still open the file through the Microsoft Access Application. Possible Cause This is because the Access OLE DB driver is not registered by Visual Studio and you should register it. Solution If you want to use Access for your desktop application, you can install the driver here  if you want to use Access for your web application, please don't do that just replace the Access with SQL Server or SQL Lire version  //

Topics Highlights

About @ridife

This blog will be dedicated to integrate a knowledge between academic and industry need in the Software Engineering, DevOps, Cloud Computing and Microsoft 365 platform. Enjoy this blog and let's get in touch in any social media.


Month List