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 |
|
Heinz23
Yak Posting Veteran
84 Posts |
 Posted - 2009-05-18 : 09:44:25
|
| Hi all,my SQL DB is already live, and of course on local I'm still developing. I wonder what is the best way to deploy the updates then? For my vb.net applications I've made a command-line where I enter the last update and robocopy copies all files changed after this date to a special directory which I then upload. Is there a similar (or better) way for MS SQL (Express) 2005? |
|
|
jholovacs
Posting Yak Master
163 Posts |
Posted - 2009-05-19 : 11:42:01
|
I like Red Gate's software; it's not free, but it's very useful. We use it for development promotion to QA and from QA to production on a regular basis in my shop. SQL Compare and SQL Data Compare are the two tools I'm referring to.
SELECT TOP 1 w.[name]FROM dbo.women wINNER JOIN dbo.inlaws i ON i.inlaw_id = w.parent_idWHERE i.net_worth > 10000000 AND i.status IN ('dead', 'dying') AND w.husband_id IS NULLORDER BY w.hotness_factor DESC |
 |
|
|
|
|
|
Deployment tips