What is Replication/Subscriptions?
I had a database that I made using SQL Server 2005 Express.
I then realised that the compact edition would make things easier for me in deployment as it is such a small project.
I converted the mdf file to sdf using http://www.primeworks.pt/
I never really paid much attention to the structure of SQL Server db before I converted and now it is deleted :blush:
When I look at the database using VB.NET 2008 it displays a directory tree style view.
It has DB.sdf -> Tables -> All my tables
but it also has DB.sdf -> Replication -> Subscriptions
Replication and Subscriptions are both empty.
What are they? Are they necessary?
Can I remove them?
Re: What is Replication/Subscriptions?
This is the only kind of Replication that I'm aware of.
Re: What is Replication/Subscriptions?
OK.
So it looks like the software I have used to convert the mdf file to sdf has used Replication and the bits left in the db structure (DB.sdf -> Replication -> Subscriptions) are a remnant of this.
If it isn't possible to remove this structure, is there a way to copy the tables to a new db?
Or is there a feature in SQL Server Compact 3.5 that will automatically produce a script to (re)create your tables elsewhere?