Results 1 to 3 of 3

Thread: What is Replication/Subscriptions?

  1. #1

    Thread Starter
    Frenzied Member agmorgan's Avatar
    Join Date
    Dec 2000
    Location
    Lurking
    Posts
    1,383

    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

    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?

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: What is Replication/Subscriptions?

    This is the only kind of Replication that I'm aware of.

  3. #3

    Thread Starter
    Frenzied Member agmorgan's Avatar
    Join Date
    Dec 2000
    Location
    Lurking
    Posts
    1,383

    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width