Replication ( Local to Hosting Company )

Hi,
I wanna replicate two SQL Server 2000 DB, On is in my Company behind a DSL
Router, the other is in a Machine on somewhere which I purchase as a Hosting
package..
Configuration of Local SQL Server is already Done by Me and Publication is
Created, I chose Snapshot one...
The problem is, How My remote SQL Server subscribe to the publisher, How can
I Subscribe and, If I can, How my Remote Server See my local Snapshot files
in order to get them in Remote DB, Should I send Snapshot files to Remote or
We have another solution ?
( Note that on Remote, I only can make a subscription, others are disabled )
What kind of solution do you propose ?
Have a look at this article: http://support.microsoft.com/?id=321822
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Configure your publication for an anoymous pull. Configure your ftp site for
anonymous access, and configure your publication to create the snapshot
within the ftp site.
Configure the subscriber for replication and then pull the subscription from
the subscriber.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"BonGee" <Bongee@.bonbon.n.e.t> wrote in message
news:ufJsvNI3EHA.3336@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I wanna replicate two SQL Server 2000 DB, On is in my Company behind a DSL
> Router, the other is in a Machine on somewhere which I purchase as a
> Hosting
> package..
> Configuration of Local SQL Server is already Done by Me and Publication is
> Created, I chose Snapshot one...
> The problem is, How My remote SQL Server subscribe to the publisher, How
> can
> I Subscribe and, If I can, How my Remote Server See my local Snapshot
> files
> in order to get them in Remote DB, Should I send Snapshot files to Remote
> or
> We have another solution ?
> ( Note that on Remote, I only can make a subscription, others are
> disabled )
> What kind of solution do you propose ?
>

Replication - Alter Column Data Type (How)

I've looked everywhere on this one and not found one jot of info

All I wanna do is alter a Char(40) Column to a Char(80)

SQL 2k sp3 - Merge Replication

Can anyone tell me how to do this without having to Halt Production in a Live environment ?

Looks like either a Drop Subscription

or

Adding a Temp Column - Copy Data Over to it - Drop Original Column - recreate as Char(80) - Copy Data Back.

Both methods involve taking the system offline even though it's not for long.

This Column has no Constraints or anything

If this type of Schema Change is possible then this Column is the simplest.

Any help appreciated

thx

GW

PS. I hope someone posts on this one - I don't seem to have much response with Replication Q'sIn general you can use sp_repladdcolumn sp_repldropcolumn to add or drop columns to a previously replicated table. You can also modify this via the UI on the article properties page. In some cases, other schema changes must include to reinitialize the publication.

As its a production database and you're looking for major change in column size then obviously you need to have outage to make sure it affected without any issues. (suggested)

In any case you have to define the outage if not do it in less traffic hour.

The other option of adding temp. column and export data and again re-define the alterations on previous columns is fine though it will not cause outage..|||thx Satya

did'nt quite get what U meant by

In general you can use sp_repladdcolumn sp_repldropcolumn to add or drop columns to a previously replicated table. You can also modify this via the UI on the article properties page

Is this the same as adding - dropping - recreating the field as in my second option ?

Anyway I'll try
Adding a Temp Column - Copy Data Over to it - Drop Original Column - recreate as Char(80) - Copy Data Back.

I'll post back if it fails

thx

GW|||Yes, after a thorough look up I suggest to use sp_repladdcolumn sp_repldropcolumn SPs as its a schema change.|||I used Enterprise Manager (Publication Properties) GUI to achieve same thing (sp_repladdcolumn etc) cos it's quicker & I'm Idle

It would of worked as well if it was'nt for the fact that the statement

Update my_Table SET NewCol = OldColumn

Left me with different Values in some of the records in the NewCol

dunno Why - we are using some kind of Binary Data in each Char Value.

The Extended Charachter set that displays with a select certainly looks different in about 5% of the records

O well - Onwards Forever Onwards

GW|||Glad it worked, but always remember to use SPs and functions provided which will give you a chance to get to know the system functionality rather depending on EM, it helps.