Replication from 2005 to 2000

Question

Post reply

Replication from 2005 to 2000

tcostasouza

Newbie

Points: 5
More actions
February 2, 2009 at 4:09 pm

#204906

Hi,
Is there any way to create a replication from 2005 to 2000 (a pub in 2005 and then a sub at 2000)? I'm trying to create the sub at 2000 but I can't connect to the 2005 instance with SQL Enterprise Manager.
Regards,
Thiago Souza

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

noeld SSC Guru Points: 96590 More actions · Answer 1

You need to use SQL 2005 UI tools.

OR

use stored procedures to set it up.

* Noel

tcostasouza Newbie Points: 5 More actions · Answer 2

Hi,

Thanks for you reply, unfortunately I won't be able to install the 2005 UI Tools, could you please tell me where I can find more information on how to do it through stored procedures?

Regards,

Thiago Souza

noeld SSC Guru Points: 96590 More actions · Answer 3

Depending what kind of subscription you want (pull or push) follow the appropriate link:

http://msdn.microsoft.com/en-us/library/ms147905(SQL.90).aspx

* Noel

tcostasouza Newbie Points: 5 More actions · Answer 4

Hi,

I followed the tutorials, but I'm still having problems. I am currently testing with 2 instances in the same network. I have setup a subscription through FTP since this will happen through the internet. My current error is that every time I start a synchronization the process fails as it cannot find the snapshot files, it's always searching for files inside a numeric folder that never exists, last time it was 20090203134892. Here is the SQL I used to to register the subscription at SQL Server 2000:

DECLARE @publication AS sysname;

DECLARE @publisher AS sysname;

DECLARE @publicationDB AS sysname;

SET @publication = N'TEST';

SET @publisher = N'krypton';

SET @publicationDB = N'dev-cortex-aware-dc';

USE [dev-cortex-aware-dc]

EXEC sp_addpullsubscription

@publisher = @publisher,

@publication = @publication,

@publisher_db = @publicationDB;

EXEC sp_addpullsubscription_agent

@publisher = @publisher,

@publisher_db = @publicationDB,

@publication = @publication,

@distributor = @publisher,

@distributor_login = N'vcortexadmin',

@distributor_password = N'xxxxx',

@use_ftp = N'true',

@publication_type = 1;

GO

Here is the full error message:

Error messages:

200 Type set to I.

200 PORT command successful.

550 KRYPTON_DEV-CORTEX-AWARE-DC_TEST\20090203134892\USER_HOME_CHART_41.pre: The system cannot find the path specified.

550 KRYPTON_DEV-CORTEX-AWARE-DC_TEST\20090203134892\USER_HOME_CHART_41.pre: The syst

The process could not retrieve file 'KRYPTON_DEV-CORTEX-AWARE-DC_TEST\20090203134892\USER_HOME_CHART_41.pre' from the FTP site 'KRYPTON'.

BTW, the FTP root points to repldata, where the directory KRYPTON_DEV-CORTEX-AWARE-DC_TEST exists.

Regards,

Thiago Souza

noeld SSC Guru Points: 96590 More actions · Answer 5

Your publication must have been setup with *all* ftp parameters requiered for that script to work. Did you verify that the publication is correctly set up ?

* Noel

tcostasouza Newbie Points: 5 More actions · Answer 6

Hi,

As far as I know, I have setup all the required ftp parameters (host, port, username, etc).

For the publication setup, I followed the wizard choosing "Snapshot publication" and the default settings for rest.

Regards,

Thiago Souza

noeld SSC Guru Points: 96590 More actions · Answer 7

Can you verify that *after* you run the snapshot agent the Files are visible from the FTP side ?

* Noel

tcostasouza Newbie Points: 5 More actions · Answer 8

Hi,

Yes, the files are there... But this is getting too complicated and taking too much time. I'll develop a script for the synchronization, thanks anyway for your help.

Regards,

Thiago Souza