CODEWITHSUNDEEP
sql-server
user1729651
user1729651

Reputation: 19

SQL Server file format

I want to ask that if I create a database in a pc and after that I want to transfer it to another pc then is it necessary that SQL Server is installed on that pc also? or I can make a formate of db that can run on any pc like exe file etc?

Upvotes: 0

Views: 108

Answers (1)

user330315
user330315

Reputation:

No, the files created by Microsoft SQL Server can only be used by another (running) instance of SQL Server. You can however embedd a stripped down version of the SQL Server engine into your .exe

Check out the Microsoft website for "SQL Server Express Edition":
http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/express.aspx

Or the "Compact Edition":
http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/compact.aspx

Upvotes: 3

Related Questions