Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Manage Multiple SQL Server Installations and Databases with OSQL Expand / Collapse
Author
Message
Posted Wednesday, October 23, 2002 12:00 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 14, 2007 1:40 PM
Points: 42, Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/RDyess/osql.asp


Post #7636
Posted Thursday, October 24, 2002 3:04 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 3:22 PM
Points: 352, Visits: 173
I've also been using these types of .bat files for a short while for production rather than admin purposes. I've recently had to transfer all my print & file interfaces (written in cobol on our mainframe) to SQLServer and found that I could call these batch files from within ftp scripts. So I'd use one ftp script to move a file from one server to an sqlserver, call in the .bat script to load & process the file and then move the output to another server or printer. not only was it quicker than running the interface jobs on the mainframe (bull dps7000), it also reduced the task of importing/exporting files and issuing console commands down to one double-click of the mouse on the ftp script icon.




Post #44541
Posted Friday, October 25, 2002 9:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 9, 2004 12:09 PM
Points: 2, Visits: 1
I agree with this method 100%. Also to alleviate files on the server you can call stored procedures also, and I love getting my output to a text file and being able to use windows findstr function to look for errors.
Mainly I write database maintenance scripts this way. It saves a lot of time I just implement the files and forget, and I don't have to use a gui and wonder what it is really doing or working!



Post #44542
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse