I am constantly manually taking down replication and putting it back up to back/restore databases. I've read a few articles around and I'm sure it's possible to automate the replication configuration.

I've seen some examples that are done at the command line and others that are done in SQL. Another twist is that I'm using SQL Server 7 and will be upgrading to SQL server 2000 soon.

If anyone can point me in the right direction that would be very helpful.