Re: Replicating Data between SQL Server 2000 and SQL Server 2005

OK, ftp into your ftp server and look for
'/ftp/28053-DB_inventory_master_inventory_master_articles/20051130120007/Purchase_Order_Line_Items_1.sch

If it is there make sure your client path is /ftp.

If its not there be sure to configure your publication for ftp to dump to
the ftp root.


--
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

"Scott Hunley" <ScottHunley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:168447D0-C7E5-46B6-B2CF-73FC79A78D1F@xxxxxxxxxxxxxxxx
>I just tried to run the process again, as a pull subscription on the SQL
> Server 2005 database in my domain and I got the following error:
>
> 2005-11-30 17:37:02.699 Snapshot files will be downloaded via ftp
> 2005-11-30 17:37:02.799 Connecting to ftp site '28053-DB'
> 2005-11-30 17:37:04.342 Agent message code 20033. The process could not
> retrieve file
> '28053-DB_inventory_master_inventory_master_articles\20051130120007\Purchase_Order_Line_Items_1.sch'
> from the FTP site '28053-DB'.
>
> This is better than previous attempts. At least it looks like it is
> trying
> to download the files.
>
> Any Ideas?
>
>
> Thanks.
>
> --
> Scott E. Hunley (MCAD)
> Measure Twice, Cut Once...
>
>
> "Hilary Cotter" wrote:
>
>> What errors are you getting?
>>
>> --
>> 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
>>
>> "Scott Hunley" <ScottHunley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:EA172267-E6DB-4686-A9F8-67C074FED590@xxxxxxxxxxxxxxxx
>> >I am currently trying to implement a replication strategy between n-many
>> >SQL
>> > Server 2000 databases, located on our hosting companies machine, and
>> > our
>> > reporting/datawarehouse server, located here in the office. So, I have
>> > 2
>> > versions of SQL, Connection over the internet and 2 different domains
>> > (untrusted connection).
>> >
>> > I have been able to replicate between SQL Server 2005 to SQL Server
>> > 2005
>> > inside of my domain, including using FTP. However, whenever I try to
>> > pull
>> > in
>> > a transactional replication from my 2000 server via the internet and
>> > FTP,
>> > I
>> > am getting various errors. Has anyone done anything similiar to this?
>> > Any
>> > help would be greatly appreciated.
>> >
>> > One last bit of information: Hosting machine runs with Windows 2000
>> > Advanced Server, SQL Server 2000 SP3A and my machines are running
>> > Windows
>> > 2003 Server/XP Pro SP2 and SQL Server 2005.
>> >
>> > Thanks in advance for any information you can give.
>> >
>> >
>> > --
>> > Scott E. Hunley
>> > Sr. Programmer/Analyst & Architect (MCAD)
>> > Robertson Marketing Group
>>
>>
>>


.

Relevant Pages

  • Re: Using PASSIVE FTP mode for transfering initial snapshots
    ... Looking for a SQL Server replication book? ... "Eli Tucker" wrote in message ... Looking in the IIS FTP log, ...
    (microsoft.public.sqlserver.replication)
  • Re: Replicating Data between SQL Server 2000 and SQL Server 2005
    ... I got the FTP issue resolved and replication is working correctly on ... SQL Server could not create a subscription for Subscriber 'MY-SQLSERVER'. ... >>> Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: replication over internet
    ... Paul, I am getting the following error when I attempt to download the ... snapshot files from the Replication FTP Site: ... Advanced Server and the Subscriber is a SQL Server 2005 database running on ...
    (microsoft.public.sqlserver.replication)
  • Small bother with broad band connection on XP
    ... browse the internet as well as read/send emails or FTP files across the ... Until two days ago when I tried to run to install SQL Server ... I can now read and send emails, and using FTP (I actually use Dreamweaver MX ...
    (microsoft.public.windowsxp.basics)
  • Re: master.dbo.xp_cmdshell is failing
    ... Yes, the error is in the FTP command, the s parameter is included twice. ... Wayne Snyder, MCDBA, SQL Server MVP ... > -x:send sockbuf Overrides the default SO_SNDBUF size of 8192. ...
    (microsoft.public.sqlserver.server)
Loading