I'm not sure what you'd gain by scripting the databases.  If you do full backups of the databases regularly, when you do a restore, the act of restoring will create...

What data on the Publisher do you want to get updated from the Subscriber ??

I think that if you want the subscriber to update the publisher, (updating in both directions)...

You'd should just be able to "un-click" a table to remove it from replication, but you can't.

What I do is:

1) Right click on the publication that you want to remove...

I'm confused ....  You want something to go from the subscriber to the publisher ??  

You're sure duplicates are not allowed at the publisher ?

No, you need to set up you snapshot articles in a snapshot publication, and your transaction articles in a transaction publication. 

BTW, When you create transaction publication, and get to the screen where...

I'm pretty sure it's not possible, using Transactional replication.  How can it perform an update if it can't use a key to find the record to be updated ??   How...

Phil's reply looks good.  I'd advise setting up some sample data in test tables before trying it on the live tables.

Here's what I run to build replication info into a table, and verify the counts between publisher & subscriber.

I use the "replication_stats" table for reference whenever I want to see...

We use replication to copy data to another database, and then users can query that other database instead of production. They only have read access, so they can select whatever...

I couldn't find anything abnormal.

I detached NEWDB1 & 2, and got login errors when I tried to reconnect with my own loging & another one.  I logged on as "SA"...

When NEWDB1 & 2 were added via the software install, I created a new global group for it and put 1 new windows login in that group, and gave that...

These are all windows accounts with SQL permissions via Active directory and Global groups.

No, the guest account is not enabled for NEWDB1 & NEWDB2

Yes, a Windows Group does have access to NEWDB1 & 2,  and separate Windows groups have access to our other...

I created a few utilities for my own use to list what tables are being replicated, including filter data, and also to verify that the record counts on the publisher...