Powershell script to execute mulitiple sql scripts on designated servers.

Powershell script to execute sql scripts found in a database table and output results to a tab in a XSL spreadsheet

1. first script must set variables to configure connection to sql server

2. run sql script to populate array variables for server scripts and tab target these are all found in a sql table.

3. each row in the variable array will be used to do the following

I. populate the server variable

ii. populate the xlstab variable

iii. populate the sqlscript variable

iv. connect to sql server

v. execute script

vi. save result set to xls sheet

vii. repeat above for each row

vii. script table column 'last run' will be updated at the end of execution with the execution date and time.

4. must loop through values found in the array variable until array has been completed.

5. upon completion of all scripts the xls will be emailed to a recipient or group of recipient.

Habilidades: Powershell, T-SQL (Transact Structures Query Language), Servidor de Microsoft SQL , Excel

Ver más: powershell script to run sql query on multiple servers, run sql script against multiple databases, run a sql script from powershell, powershell run sql query, run sql script on multiple servers, powershell script to check sql service status on multiple servers, powershell script to run sql query on multiple databases, powershell sql server commands, collect data from multiple sql servers, convert oracle sql scripts sql server, script execute query, oracle sql scripts mssql, php sql scripts vacation rental calendar, vbs script import csv sql server, email verification sql scripts, write sql scripts delete entries database, sql statement several servers, database script online booking sql, aspnet execute sql scripts web service, php script create xml sql

Información del empleador:
( 2 comentarios ) Lonoke, United States

Nº del proyecto: #25611343

Adjudicado a:


I am a professional developer with experience in Powershell and SQL as well. We can define a good flow to make script ready for easy amendment and managemnt.

$250 USD en 5 días
(0 comentarios)

27 freelancers están ofertando el promedio de $410 para este trabajo


Hi there! I am a software developer with experience working with Powershell scripts to automate tasks like this project. I am very confident working with Powershell + SQL queries. I have some doubts about what you need Más

$280 USD en 4 días
(26 comentarios)

hey I'm Romain, a French Microsoft certified guy I can help you with that please contact me for more informations best regards, Romain

$300 USD en 1 día
(24 comentarios)

I am good in powershell and MSSQL along with xls, csv automation, please let me know if you are good to award this project t to me

$250 USD en 3 días
(46 comentarios)

Hello, I don't think it's possible to use Powershell to do this. I can create you a .NET application instead if you are interested ? Kindly send me a message to discuss. Thanks & Regards, Everest Technology

$325 USD en 3 días
(19 comentarios)

Hi. I have written many automation PowerShell scripts also database projects including SQL Server. Ready to write your project. Will complete within 7 days

$320 USD en 7 días
(40 comentarios)

Hello there, I am interested in the project. I have expertise in MS SQL server and excel automation through PowerShell and I am sure I can provide you the exact solution you are looking for. Please message me for more Más

$250 USD en 7 días
(17 comentarios)

Hi, I saw that you need help with Microsoft SQL Server, Excel, Powershell and T-SQL (Transact Structures Query Language). I have 9 years of experience working on these frameworks. I believe I can help you with it. I wo Más

$750 USD en 14 días
(8 comentarios)

Hello Sir, Check my profile and my client feedback . I will ill make a good powershell scrip that do all the tasks that's you have mentioned. Pls give me chance. Pay only if u like my work guranteed.

$250 USD en 1 día
(9 comentarios)

Sure. It's just my job. I have done a lot of powershell script. So i can help you if you want. Hope to work wtih you. Thanks.

$250 USD en 2 días
(5 comentarios)

Hey There, Greeting for the day... I am Microsoft Certified Engineer with 12+years of experience. Also I am Powershell Expert. I have worked on many Powershell project. I am very much confident to work this project. Más

$333 USD en 3 días
(9 comentarios)

Hello, We have gone through your post and are interested in creating the Powershell scripts as per your requirements. A brief introduction about us:- We have certified microsoft professionals working with us, who ha Más

$750 USD en 14 días
(2 comentarios)

Hi, I'm a professional and expert in Data works or projects..My skills and services include: - Web scraping - Data entry - Data mining - Data processing - Excel - MySQL - Oracle -Financial Analysis -Advanced Excel -MS Más

$250 USD en 1 día
(3 comentarios)

Hi, I am a c# developer for past 6+ years, Have developed many C# windows and web Application( ,MVC, Enity framework). Also have been worked with fortune companies and received appreciation. Have experience in j Más

$250 USD en 7 días
(3 comentarios)

Hello, Thanks for reviewing my application. I analyze job requirements for a PHP developer and I can definitely assist you to write power shell script.   I have rich experience with PHP/MySql.I am well versed with PHP Más

$600 USD en 7 días
(0 comentarios)

I have implemented this type of requirement before. Get me an opportunity to do this task. Will complete this within 3 days.

$250 USD en 3 días
(0 comentarios)

Hello , I have extensive experience (7 Years) with Powershell and integrating with databases. I have built rather complex tools and scripts including ones with GUI. Some are available as open source on Github. Judging Más

$250 USD en 3 días
(0 comentarios)

More than 8+ years of experience in various technologies. Currently working as Infra Automation Engineer. Primary Skill: Powershell Scripting Secondary Skill: MS SQL, MS Exchange, Windows, MS365, Jenkins, Active Dire Más

$250 USD en 7 días
(0 comentarios)

Hello I have 6+ Year experience in Microsoft Technology. I checked your requirement and I am capable to do this requirement. Bid value is just place holding. Final budget decide after checking all your requir Más

$500 USD en 7 días
(0 comentarios)

Dear Employer, I have seen your Job description. I have good experience in PowerShell scripting and have done similar projects. Kindly message me so that we can discuss more about the work. Regards Lucky

$556 USD en 5 días
(0 comentarios)

Hi, I am a full-stack, front-end engineer with over 12 years of experience. I specialize in Java, Apache, PHP MySql. I emphasize quality over speed, and the bid amount is an honest reflection of that philosophy I hav Más

$700 USD en 7 días
(0 comentarios)