<paul.higgs@nrgi.com> wrote in message
news:1158835390.210313.121440@b28g2000cwb.googlegroups.com...
> Hi,
>
> I'm trying to transfer data from an SQL 2000 box to a new SQL 2005
> server. On the old server the database is setup for replication and has
> a publication.
>
> The new SQL 2005 is set-up for replication. I restore the database and
> in the SQL Magement console I can see the various publications.
> However, it is not working correctly. If I try and delete the
> publication, I get the error that a subscription exists on it. But
> under the publication no subscriptions are listed.
>
> Also if I go to view the Publication Access List on the Publication
> properties I get the error 'Publication does not exists'.
>
> Any ideas who I can transfer the data from the SQL 2000 to the SQL 2005
> server, and not screw up the replication settings. I do not want to
> disable replication before I transfer it as this is the live server at
> the moment. I'm testing the transfer process at the moment.
>
> Thanks
> Paul
>

<paul.higgs@nrgi.com> wrote in message
news:1158917735.792649.262510@e3g2000cwe.googlegroups.com...
> Hi,
>
> No this is not an option during testing. When we are switching that
> would be ok, all systems will be done over the weekend), but I would
> like to be able to test the data migration process in advance... catch
> 22?
>
> I'm not worried about loosing details of the subscriptions or
> publication on the new server, they will need to be recreated from
> scrath anyway - we are moving to a new domain setup.
>
> I have tried restoring the backups, then removing replication from the
> SQL 2005 server, hopefully this will clear out the 'bad' replication
> metadata that gets restored. So I can create the publications again, do
> you think this will work?
>
> Thanks
> Paul
>