CODEWITHSUNDEEP
sql-serverasp.net-mvc-3sql-server-cebackup
Emma
Emma

Reputation: 11

Convert .sdf to .bak

I'm trying to publish a webproject MVC3 .NET with binero.se. The problem is that my database file is .sdf. And binero wants a .bak file.

Does anyone know how to solve this problem?

Upvotes: 1

Views: 2747

Answers (1)

marc_s
marc_s

Reputation: 755411

.sdf is the file format for SQL Server Compact Edition and that's quite a different beast from "real" SQL Server. .bak is the database backup format for a full-blown SQL Server.

The way to get from .sdf to .bak would be:

  • create a temporary database in a "full" SQL Server (Express, Standard, Enterprise) with the name of the .sdf file

  • using a tool like SQL Server Compacst data and schema scripting, export your table structure and data from the SQL Server CE file into "full" SQL Server

  • once you've created all tables and other DB objects and inserted all your data into the "full" SQL Server database, create a backup of that database to get your .bak file

Upvotes: 4

Related Questions