FTP snapshot folder for merge replication
-
Hi, I am trying to configure replication between 2 SQL Server 2005 databases located on seperate Windows servers, but because the subscriber cannot see the shared snapshot folder at the publisher, I want to use an FTP folder instead. I have read Microsoft's documentation on this but have gotten a bit stuck! Microsoft say to specify the default snapshot folder in the distributer properties, but it won't let me enter an FTP url, only a UNC path. Can someone tell me how do I specify a UNC path to a FTP folder in the distributor properties? This is what I have been reading from Microsoft http://msdn.microsoft.com/en-us/library/ms151844(SQL.90).aspx[^] Thanks in advance :)
-
Hi, I am trying to configure replication between 2 SQL Server 2005 databases located on seperate Windows servers, but because the subscriber cannot see the shared snapshot folder at the publisher, I want to use an FTP folder instead. I have read Microsoft's documentation on this but have gotten a bit stuck! Microsoft say to specify the default snapshot folder in the distributer properties, but it won't let me enter an FTP url, only a UNC path. Can someone tell me how do I specify a UNC path to a FTP folder in the distributor properties? This is what I have been reading from Microsoft http://msdn.microsoft.com/en-us/library/ms151844(SQL.90).aspx[^] Thanks in advance :)
Nevermind people, got it sorted thanks :)