I'm a Linux/MySQL person - but I have been given an assignment to grab some data off of an IIS environment to migrate some data. I'd like to export a few tables as raw SQL - but since it's off a live/production site I'm cautious about it.
In Enterprise Manager - when I drill down to the database/tables / right-click on the table - I see Generate SQL.
Is that the option I want to use - and how do I use it? Is it in any way destructive to what exists? And if that's *not* the way to do it - how do I export the SQL for the table? :)
Thanks in advance!