Tuesday, February 21, 2012

Running Some script files

Hello, I have some script FILES (.SQL FILES) on a folder, and I want to run them using command line, or a kind of utility or tool.

Sorry for the example but I used to do @.c:\myFile.sql in Oracle, that's exactly what I need for SQL SERVER 2000

Thank you so much !!

You can use ISQL or OSQL in this case, refer to the SQL books online and following links for further information:

http://www.databasejournal.com/features/mssql/article.php/10894_3313201_2

http://www.idevelopment.info/data/MSSQL/DBA_tips/Database_Administration/DBA_1.shtml

|||

Satya SKJ wrote:

You can use ISQL or OSQL in this case, refer to the SQL books online and following links for further information:

http://www.databasejournal.com/features/mssql/article.php/10894_3313201_2

http://www.idevelopment.info/data/MSSQL/DBA_tips/Database_Administration/DBA_1.shtml

Your Answer was so useful,

Thanks a lot !!!

No comments:

Post a Comment