A typical publishing configuration

Hi,
Can anyone tell me the best way to configure sql server to allow
publication of data from a pre to a production environment.
I'm thinking along the lines of a typical content mgmt app where users
can work in pre and publish to prod when ready, how would this normally
be configured?
Thanks
Kieran
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Probably by creating a publication that filters the articles by a column
which has a status value in it indicating whether the content is ready for
publication.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Kieran" <anonymous@.devdex.com> wrote in message
news:OP3KYH6qEHA.3172@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anyone tell me the best way to configure sql server to allow
> publication of data from a pre to a production environment.
> I'm thinking along the lines of a typical content mgmt app where users
> can work in pre and publish to prod when ready, how would this normally
> be configured?
> Thanks
> Kieran
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Thanks Hilary, is a replication something that can be set up on the sql
server?
Thanks
Kieran
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||it sure is, go to tools, replication and go from there.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Kieran" <anonymous@.devdex.com> wrote in message
news:%23kQdFl6qEHA.2724@.TK2MSFTNGP14.phx.gbl...
> Thanks Hilary, is a replication something that can be set up on the sql
> server?
> Thanks
> Kieran
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
sql