EM in 7.0--Creation Script for DB

• interclubs

  SSC Enthusiast

  Points: 135

  More actions

  March 18, 2002 at 11:18 am

  #78414

  Is there anyway to generate a SQL script in Enterprise Manager that not only creates the table, but that populates it as well with info from the table? I know I can do it thru DTS but I want to create some text files of tables I commonly use and am trying to simplify the process..(Such as state, country, etc.)

  Thanks!

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 18, 2002 at 11:23 am

  #425563

  To my knowledge not directly. You might want to check for a third party app that does this. Or if someone knows a way I would be interested myself.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)