Restore Database from MDF file to SQL Server Database

Question

When creating a website in visual studio and I want to add a database which of the options should I use to create the databaseShould i use Microsoft SQL Server Database File SqlClient or I should have used the Create New SQL Server Database option

dharmendr · Accepted Answer

Hi RichardSaThe MS SQL Server Database File is intended to access local data stored in an instance of MS SQL Server Express on the same machine as the client applicationIt would require that your client ensure that SQL Server Express is installedThis means that client do not share data with anotherIf you need to have a central backend database that all client access it looks like SQL Server Workgroup or Standard editions

dharmendr · Answer

Use generate Scripts and restoreRestore MDF file to Database in SQL Server

Restore Database from MDF file to SQL Server Database

Restore MDF file to Database in SQL Server

Company

Explore

Follow us

Contact Us