Results 1 to 3 of 3

Thread: Database Updater

  1. Sep 10th, 2012, 10:19 AM #1
    DomDom1
    DomDom1 is offline

    Thread Starter
    Member
    Join Date
    Mar 2012
    Posts
    39

    Database Updater

    Good morning,
    I have a distributed application that uses SQL Express, I've written an auto updater for the application that is working great. My problem is deploying Either, Schema Change or modifying/adding a Stored Proc. I am currently using SMO and this is not very reliable, or maybe I am not using it correctly. If I need to deploy Database change, alter a table, modify stored proc ect, what is the best way to do this? I currently create a SP file that smo consumes, but I am finding it runs on some and not on others. Any help would be greatly appreciated.
    Reply With Quote Reply With Quote
  2. Sep 10th, 2012, 10:27 PM #2
    DomDom1
    DomDom1 is offline

    Thread Starter
    Member
    Join Date
    Mar 2012
    Posts
    39

    Re: Database Updater

    Anyone?

    How about sqlcmd, could one use sqlcmd and consume a sp file? does it support return values so an autoupdater would get confirmation if a script ran? How does everyone else here manage remote SQL Express schema changes, when not on the local network or wan. I have to believe their is a somewhat simple way to accomplish this.
    Reply With Quote Reply With Quote
  3. Sep 13th, 2012, 11:56 PM #3
    DomDom1
    DomDom1 is offline

    Thread Starter
    Member
    Join Date
    Mar 2012
    Posts
    39

    Re: Database Updater

    Is this the correct forum or should I try another?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width