How to Change Publication on Local Network to Publish on Internet

Please Help me with this problem , I am working with merge replication , i
have got publication for local network and i want to chage it to publish the
articles on internet without creating new publication.
Please Reply
Thanks
Abulla Fatiya
drop all subscriptions
run the below script - change the name of pubs5 to your publication name
sp_changemergepublication 'pubs5','allow_pull','true'
go
sp_changemergepublication 'pubs5','allow_anonymous','true'
go
sp_changemergepublication 'pubs5','alt_snapshot_folder','c:\inetpub\ftproot'
go
sp_changemergepublication 'pubs5','compress_snapshot','true'
go
declare @.str varchar(200)
set @.str='sp_changemergepublication
''pubs5'',''ftp_address'',''ftp://'+@.@.ServerName+''''
print @.str
exec (@.str)
go
sp_changemergepublication 'pubs5','ftp_port','21'
go
sp_changemergepublication 'pubs5','ftp_subdirectory','ftp'
go
sp_changemergepublication 'pubs5','ftp_login','anonymous'
go
sp_changemergepublication 'pubs5','ftp_password','password'
go
sp_changemergepublication 'pubs5','enabled_for_internet','true'
go
sp_changemergepublication 'pubs5','snapshot_ready','true'
go
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Fatiya" <Fatiya@.discussions.microsoft.com> wrote in message
news:7464DC4B-3760-4DD2-95E3-280ACB8E898C@.microsoft.com...
> Please Help me with this problem , I am working with merge replication , i
> have got publication for local network and i want to chage it to publish
the
> articles on internet without creating new publication.
> Please Reply
> Thanks
> Abulla Fatiya
>
>
|||Fatiya,
my comments re VPN are OK, but Hilary's change script is
extremely neat and avoids the need for reinitialization,
so please disregard my later comments.
Rgds,
Paul Ibison

>--Original Message--
>drop all subscriptions
>run the below script - change the name of pubs5 to your
publication name
>sp_changemergepublication 'pubs5','allow_pull','true'
>go
>sp_changemergepublication 'pubs5','allow_anonymous','true
'
>go
>sp_changemergepublication 'pubs5','alt_snapshot_folder','
c:\inetpub\ftproot'
>go
>sp_changemergepublication 'pubs5','compress_snapshot','tr
ue'
>go
>declare @.str varchar(200)
>set @.str='sp_changemergepublication
>''pubs5'',''ftp_address'',''ftp://'+@.@.ServerName+''''
>print @.str
>exec (@.str)
>go
>sp_changemergepublication 'pubs5','ftp_port','21'
>go
>sp_changemergepublication 'pubs5','ftp_subdirectory','ftp
'
>go
>sp_changemergepublication 'pubs5','ftp_login','anonymous'
>go
>sp_changemergepublication 'pubs5','ftp_password','passwor
d'
>go
>sp_changemergepublication 'pubs5','enabled_for_internet',
'true'
>go
>sp_changemergepublication 'pubs5','snapshot_ready','true'
>go
>--
>Hilary Cotter
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>Looking for a FAQ on Indexing Services/SQL FTS
>http://www.indexserverfaq.com
>"Fatiya" <Fatiya@.discussions.microsoft.com> wrote in
message
>news:7464DC4B-3760-4DD2-95E3-
280ACB8E898C@.microsoft.com...[vbcol=seagreen]
merge replication , i[vbcol=seagreen]
chage it to publish
>the
>
>.
>

how to build a sql server instance in the network using sql express?

Hi,

how to build a sql server instance in the network using sql express?

thank you.

Have a look at the install documentation and books only for the setup command line switches, you should be able to get the data there to set up the instance, Then just do the install using the net setup config, you may have to add a setup.ini file to the same directory as the installer. (At least that is how we did it with MSDE).

|||Thank you very much. However, Where can I find those documents you said?|||

The SQL Books online is installed with the sql products and can also be downloaded from the Microsoft Downloads Site. You can also find information on the installer options in the readme files for the express package.

|||I am sorry I still cannot find the information in the SQL Books Online. Could you give a link where the location of the information is? Thank you very much.|||

hi,

please have a look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx

regards

|||oops, I think I asked a wrong question. I will open a new thread with the correct question. Sorry!

how to build a sql server instance in the network using sql express?

Hi,

how to build a sql server instance in the network using sql express?

thank you.

Have a look at the install documentation and books only for the setup command line switches, you should be able to get the data there to set up the instance, Then just do the install using the net setup config, you may have to add a setup.ini file to the same directory as the installer. (At least that is how we did it with MSDE).

|||Thank you very much. However, Where can I find those documents you said?|||

The SQL Books online is installed with the sql products and can also be downloaded from the Microsoft Downloads Site. You can also find information on the installer options in the readme files for the express package.

|||I am sorry I still cannot find the information in the SQL Books Online. Could you give a link where the location of the information is? Thank you very much.|||

hi,

please have a look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx

regards

|||oops, I think I asked a wrong question. I will open a new thread with the correct question. Sorry!