vbscript or perl

Dear all,

I have to port a moderately complicated unix shell script written for
Solaris to Windows. I've never done Windows scripting before. Should I

(a) learn VBScript and implement it in that;
(b) install Active Perl on the target Windows box and rewrite the script in
perl (which I am familiar with).

The script in question most does database stuff e.g. calls stored procs,
parses text files then loads new records with bcp.

Cheers,

David

McKirahan
Fri Dec 03 05:14:45 CST 2004

"David" <gyruss@hushmail.com> wrote in message
news:41b01b06_1@news.iprimus.com.au...
> Dear all,
>
> I have to port a moderately complicated unix shell script written for
> Solaris to Windows. I've never done Windows scripting before. Should I
>
> (a) learn VBScript and implement it in that;
> (b) install Active Perl on the target Windows box and rewrite the script
in
> perl (which I am familiar with).
>
> The script in question most does database stuff e.g. calls stored procs,
> parses text files then loads new records with bcp.
>
> Cheers,
>
> David

It probably depends on the complexity of the script, the time constraints of
the project, the requirements of management, etc.

Regarding the database: what is it and will it be converted to a Microsoft
supported one?
Does Perl support access to Microsoft databases? VBScript does via ADO.

Torgeir
Fri Dec 03 05:31:53 CST 2004

David wrote:

> I have to port a moderately complicated unix shell script written for
> Solaris to Windows. I've never done Windows scripting before. Should I
>
> (a) learn VBScript and implement it in that;
> (b) install Active Perl on the target Windows box and rewrite the script in
> perl (which I am familiar with).
>
> The script in question most does database stuff e.g. calls stored procs,
> parses text files then loads new records with bcp.
Hi

As this is only for one computer if I have understood you correctly,
and you are familiar with Perl, definitively install Active Perl and
use that. E.g. you have much stronger text parsing functions in Perl
than in VBScript.


--
torgeir, Microsoft MVP Scripting and WMI, Porsgrunn Norway
Administration scripting examples and an ONLINE version of
the 1328 page Scripting Guide:
http://www.microsoft.com/technet/scriptcenter/default.mspx

Torgeir
Fri Dec 03 05:33:15 CST 2004

McKirahan wrote:

> Does Perl support access to Microsoft databases? VBScript
> does via ADO.
Hi

ADO access from VBScript is through COM, so Active Perl should
have no problem with this.


--
torgeir, Microsoft MVP Scripting and WMI, Porsgrunn Norway
Administration scripting examples and an ONLINE version of
the 1328 page Scripting Guide:
http://www.microsoft.com/technet/scriptcenter/default.mspx

Jason
Fri Dec 03 06:43:20 CST 2004

to add to this, yes, I can confirm ActivePerl can use Access and SQL Server
using ADO via the Win32::OLE module bundled with ActivePerl


--
Jason Brown
Microsoft GTSC, IIS

This posting is provided "AS IS" with no warranties, and confers no
rights.

"Torgeir Bakken (MVP)" <Torgeir.Bakken-spam@hydro.com> wrote in message
news:OmJVkvS2EHA.4028@TK2MSFTNGP15.phx.gbl...
> McKirahan wrote:
>
>> Does Perl support access to Microsoft databases? VBScript
>> does via ADO.
> Hi
>
> ADO access from VBScript is through COM, so Active Perl should
> have no problem with this.
>
>
> --
> torgeir, Microsoft MVP Scripting and WMI, Porsgrunn Norway
> Administration scripting examples and an ONLINE version of
> the 1328 page Scripting Guide:
> http://www.microsoft.com/technet/scriptcenter/default.mspx