Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rsegecin
Yak Posting Veteran
82 Posts |
 Posted - 2007-11-10 : 12:36:53
|
| Hi, I was wondering after I had deployed my data base on the internet and made some modifications with her, what is the best approach to recover the data base deployed? Now if I'm changing some stored procedure in the data base deployed I have to make the same change in the original data base, it gives me a lot of work.Thank you very much.Fell free to correct me if I misspeled something. |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-11-10 : 13:30:13
|
| I am not sure how to answer your question, but you misspelled misspelled.It would depend on how you set up the database when you deployed it...did you publish it with version control?Can you simply replicate your post-changes database to the the deployed location?not sure if this will help or not:http://msdn2.microsoft.com/en-us/library/aa833261(VS.80).aspx |
 |
|
|
rsegecin
Yak Posting Veteran
82 Posts |
Posted - 2007-11-10 : 14:02:08
|
| Thank you dataguru1971 for the quick reply.I'm not chore what you mean about "with version control", but I think that didn't do it.Yes I could replace the database to the deployed location, but it would reset the tables as well so it wouldn't be suitable to do. Fell free to correct me if I misspelled something.Ideas are bullet proof.Vendetta. |
|
|
|
rsegecin
Yak Posting Veteran
82 Posts |
Posted - 2007-11-10 : 14:10:09
|
| ok now I understand what you said about version control and the link that you provided to me seems to be what I wanted.Thank you very much dataguru1971.Ideas are bullet proof.V for Vendetta.Fell free to correct me if I misspelled something or a "better way to say it". |
|
|
|
|
|
|
Recover data issue.