SQL Server 2005 AdventureWorks Database BAK file

Question

I need an AdventureWorks.sdf file for compact 3.5 or 4.0 ... but I cannot find one.

So, I'm willing to convert a SQL Server 2005 backup of AdventureWorks into SQL Server Compact ... but I cannot find one.

Why is this so difficult?

The AdventureWorks.msi (http://msftdbprodsamples.codeplex.com/releases/view/4004) download provides a locked-up set of database files, which cannot be attached in my instance of SQL Server 2005.

All that is needed is a simple AdventureWorks.BAK file that can be easily restored to SQL Server.  Why has this been made to be so Byzantine and impossibly time-consuming?  Why?

 

 

Answer 1

The following blog post contains some sample code including the AdventureWorks.sdf database

http://geekswithblogs.net/Vishal/archive/2008/09/17/introduction-to-ado-.net-sync-services.aspx 

---

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID: Microsoft Transcript

Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

Answer 2

Did you end up finding an answer to your question? If so, could you please provide the solution.

---

When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript