Deployment Strategies

[faust13]

I am currently developing on a workstation. My ASP.Net app resides on a separate server. I can copy over my application and have it work easy enough. However I'm concerned about overwriting data in the ASPNETDB.MDF. I have live data on the production server, but I'm constantly updating and adding to the DB.

What is a good strategy to keep the production and development database in synch without overwriting the live data on the production server?


Thanks,

faust13
Because Han Shoots First

http://www.hanshootsfirst.org

 

[ca8msm]

You could use a replication tool. A good third part one is:

http://www.red-gate.com/products/SQL_Compare/index.htm

Alternatively, ask in the SQL Server forum for other replication methods.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.