Hi All,
Is it possible to take Backup of SQL Server Compact database (i.e. *.sdf) and Restore the same.
Regards.
team_ferrari22 0 Newbie Poster
kvprajapati 1,826 Posting Genius Team Colleague
You must have to read - http://www.microsoft.com/Sqlserver/2008/en/us/compact.aspx
SUMMARY:
Top Features
- Free to use and distribute
- Supports desktops and mobile devices
- Small footprint for easy deployment
- Fully embeddable architecture
- No administration required
- Single file, code-free database format
- Support for ClickOnce, XCopy, MSI, CAB, and non-admin embedded installation options
- Supports all Microsoft Windows embedded, mobile, desktop, and server operating systems
- Supports a rich subset of Transact-SQL syntax and SQL Server data types
- Microsoft Visual Studio 2008 integration
- Supports ADO.NET, LINQ to SQL, LINQ to Entities, and the ADO.NET Entity Framework
- Supports multiple concurrent local connections
team_ferrari22 0 Newbie Poster
You must have to read - http://www.microsoft.com/Sqlserver/2008/en/us/compact.aspx
SUMMARY:
Top Features
- Free to use and distribute
- Supports desktops and mobile devices
- Small footprint for easy deployment
- Fully embeddable architecture
- No administration required
- Single file, code-free database format
- Support for ClickOnce, XCopy, MSI, CAB, and non-admin embedded installation options
- Supports all Microsoft Windows embedded, mobile, desktop, and server operating systems
- Supports a rich subset of Transact-SQL syntax and SQL Server data types
- Microsoft Visual Studio 2008 integration
- Supports ADO.NET, LINQ to SQL, LINQ to Entities, and the ADO.NET Entity Framework
- Supports multiple concurrent local connections
Thank you for your reply.
One more doubt we have, that is can we restore backup file taken by SQL Server (i.e.*.bak) to SQL Server Compact database or convert .bak file to .sdf file in any way? or any tools available for such activities?
Regards
kvprajapati 1,826 Posting Genius Team Colleague
>can we restore backup file taken by SQL Server (i.e.*.bak) to SQL Server Compact database or convert .bak file to .sdf file in any way?
No.
>any tools available for such activities?
Take a look at - http://www.johnnycantcode.com/page/SQL-Server-to-SQL-Server-Compact-Edition-Database-Copy.aspx
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.