Move test data to production SQL Server

Hi All,
Could someone point me to a white paper/best practices on how to move/update
data from test sql server to a production sql server?
Both of the server have the same schema.
I would like to know if there is a way to synchronize the two databases.
Would SQL Server Replication be a good idea?
Many thanks,
Setting up replication between test server and production server is a very
bad idea. Don't even think about it.
"Amine" wrote:

> Hi All,
> Could someone point me to a white paper/best practices on how to move/update
> data from test sql server to a production sql server?
> Both of the server have the same schema.
> I would like to know if there is a way to synchronize the two databases.
> Would SQL Server Replication be a good idea?
> Many thanks,
|||I concur with Jack, however if you are going in the opposite direction, it
could be a good idea.
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
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:3AE6B9EF-089F-4D1D-8BEB-967CC32C0004@.microsoft.com...[vbcol=seagreen]
> Setting up replication between test server and production server is a very
> bad idea. Don't even think about it.
> "Amine" wrote:
move/update[vbcol=seagreen]
|||Amine,
like Jack and Hilary I'm struggling to see why you would want replication
from test to proiduction. However, perhaps you are loading (cleansed) data
as part of a build? In this case you could use DTS to transfer the data as a
one-off. If the environments are disconnected, then there are 3rd party
tools to take data and generate insert statements from it.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)