Updating SQL databases

Results 1 to 2 of 2

Thread: Updating SQL databases

  1. #1
    Join Date
    Dec 1969

    Default Updating SQL databases

    Being relatively new to the SQL side of Web Development, I was wondering if there is a method or software that will allow me to automatically update SQL elements from one database to another. Example: I make a change to a table in a development database, add a stored procedure, modify another. Instead of manually making the changes on the production database, is there something out there that will do this for me? I&#039;ve looked into doing it wil scripts, but I would still need to modify them in order to specify which elements will be updated. Am I expecting too much, or is there a solution to my problem?<BR><BR>Any help/suggestions would be greatly appreciated.<BR><BR>Thanks,<BR><BR>Mark<BR>SQL newbie

  2. #2
    Join Date
    Dec 1969

    Default RE: Updating SQL databases

    Use the import/export utility (DTS Wizard) that installs with SQL Server.

Posting Permissions

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