Posted by Benzine on 01/05/07 22:08

Thanks again.

Damien wrote:
> Benzine wrote:
>
> > Hi Damien,
> >
> > You wouldnt by chance have a script that can update the
> > status_for_replication to Not_For_Replication for all FK's?
> >
> > Ben
> >
> I'm afraid not. I believe that the first time I encountered this
> problem for a project, what I ended up doing was scripting out all of
> the foreign keys to a script file. Then using an editor with support
> for regular expressions in find and replace (in my case, Visual
> Studio), I edited the file to include the "NOT FOR REPLICATION" at the
> appropriate places in the file (see Books On Line for ALTER TABLE to
> find the right syntax). Then I wrote another script which just tore
> down all existing foreign keys in the database. Applying these scripts
> in the correct order produced the necessary changes.
>
> On the second project, I had it included from the start, so I've never
> had to do this again.
>
> Damien

• Next in forum: Re: Script to combine multiple rows into 1 single row
• Prev in forum: Re: How do I reference a table in one database from a SQL script running in another database?
• Thread view: Re: Merge Replication and Trigger Problem

[Reply to this message]