Manage Multiple SQL Server Installations and Databases with OSQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Randy Dyess » Manage Multiple SQL Server Installations and...

Manage Multiple SQL Server Installations and Databases with OSQL

Rate Topic

Display Mode

Topic Options

Author

Message

Randy_Dyess

Posted Wednesday, October 23, 2002 12:00 AM

SSC 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

SALIM ALI

Posted Thursday, October 24, 2002 3:04 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 6:40 AM
Points: 351, Visits: 158

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

maveriq

Posted Friday, October 25, 2002 9:34 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, April 09, 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 »

Permissions