Generate .SQL file

[Locusta]

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

 

[Nicholas Paldino [.NET/C# MVP]]

Locusta,

If you have an oracle OLE-DB provider installed on your machine, you
could easily use Data Transformation Services in SQL Server to just do this
for you. You won't have to write any code at all.

Hope this helps.

 

[Guest]

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

 

[Locusta]

Hello all,

I'm using the Google reply function, this is not my pc.

Thank you for the feedback, I'm currently running my database on
MSDE2000, so I don't have a lot of tools

Any suggestions on how I can do this under this free database?

Cheers,
D.

 

[Guest]

Some time ago, I used the SqlAdmin .NET assembly from the MS Web Data
Administrator Web app (a very nice web-based Enterprise manager clone) to
build a winforms - based SQL Database export utility.

Here's the link to that article, with source code download:

http://www.eggheadcafe.com/articles/20040913.asp

Peter