In SQL Enterprise Manager, right - click the node for the database you want
to "export", choose "All Tasks" from the context menu, then "export data" and
follow the wizard for the options you need. Be advised that the Transact Sql
it generates may not be 100% Oracle PL/SQL compatible, it may need to be
"tweaked". This assumes SQL Server 2000.
Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com
"Locusta" wrote:
Hello,
I'm a junior in c# development, and would like to know how to generate
the .SQL files from my development system (database), so that I can
execute them on another system (from MSSQL to Oracle database)
I'm looking for a way to extract and create the 'CREATE TABLE... and
INSERT INTO...' statements, and how to process the created .sql file.
Thank you for your feedback!
Dirk