March 2, 2009 at 1:13 pm
What is the best method to push database changes to client.
1. Assuming we do not have access to their server.
2. We need to send them a file (could be exe or a bat file).
2. Installation or upgrade should be just matter of a click.
I know there are several tools available but which one is the simplest and can they convert everything as a single exe/bat file and how about SSIS?
Is there any other way for handling such changes? Is there a method where we can implement changes as PULL rather than PUSH?
Amit Lohia
March 2, 2009 at 1:23 pm
http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/vcspart3/525/
SQLPackager from Red Gate works as well
March 2, 2009 at 3:37 pm
Any way to implement a pull instead of push?
Amit Lohia
March 2, 2009 at 3:44 pm
You'd have to write something. I had friend that built a "check" into the app to look for changes when it starts (or users click something).
The minutiae of how to do this is the same (for deployment). You get into strange rights issues if you have the server do it, potentially.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply