Server utility Scripting

[greggpb]

I am looking at automating a whole bunch of tasks, including Ftp, Db Access and some file manip and movement, auto zipping.. at the moment its on a windows server but it might move to a linux server for cheaper licensing ?

What scripting language would you guy use .. i have been using C# and building small executable's .. then these small programs don't need to be complied and it would be nice if they were interrupted scripts? what language would you guys used ???

 

[dequadin]

I've heard PowerShell is awesome for that kind of thing.

Cross platform requirements, maybe Python?

 

[guest2013-1]

I use good ol' dos bat files

I use it to backup my sql databases using task scheduler (more reliable than sql server agent sometimes) and then compress them using 7zip and once a night I do a full backup of my domain directories. Copy everything over to my NAS and then delete the compressed versions off my drive after 2 weeks... all wiff da ms-dos yo

 

[Other Pineapple Smurf]

2nd powershell as they alias BASH commands. Makes it easier to migrate between the two platforms.

But without a doubt, LINUX is superior for what you want to do. Scripting is my personal weak point with Windows. But then again there is nothing stopping you from clustering a Windows & LINUX server to get the best of both worlds. (Even this LINUX fan admits Windows server has its advantages).

Personally I would look at Python as you can run it on both platforms. (Actually all my scripts are done in BASH or PHP-CLI).

 

[greggpb]

I use good ol' dos bat files

I use it to backup my sql databases using task scheduler (more reliable than sql server agent sometimes) and then compress them using 7zip and once a night I do a full backup of my domain directories. Copy everything over to my NAS and then delete the compressed versions off my drive after 2 weeks... all wiff da ms-dos yo

Thanks guys looking into powershell, bat it ok but falls down with complex loops and varibles

 

[Nod]

Linux with any of the shells (ksh, bash, csh, etc). They all differ slightly in usage and builtin commands, but would be perfect for that kind of thing.

I've build a dynamic menu in ksh that uses a Oracle backend for the menu items and commands. Works on Linux and Solaris, so pretty portable too.

 

[greggpb]

Just an Update, after mucking around with Powershell and getting most of the stuff working, I found CS-Script (www.csscript.net). I have changed most of the coding into "CS Script" because I can use the vs ide and have worked in C# before.