Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    1

    Unanswered: Scripting question

    Is there a way to have a use_database command added to and object that is being scripted through enterprise manager?

    I am trying to automate our scripting process for pushes to our production environment and we have several databases. I wan't to make sure that an object that is scripted in our QA environment can't accidently get pushed to the incorrect database in our prod environment.

    Thanks in advance.

  2. #2
    Join Date
    Jan 2003
    Location
    México City
    Posts
    31

    Re: Scripting question

    You may stablish a standard use of full identifiers (dbname.owner.obj_name) in your developing environment, but it only works if your database structures are different.
    Our case is the opposite: several instances of same structure, so we decided to create a post-processor (VB6) to integrate all changes in a single script, adding "USE db_name" at the very beginning that will be released to production environment.

Posting Permissions

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