Completed

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.

Skills: Powershell, T-SQL (Transact Structures Query Language), Microsoft SQL Server, Excel

See more: 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

About the Employer:
( 2 reviews ) Lonoke, United States

Project ID: #25611343

Awarded to:

subhra04

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 in 5 days
(0 Reviews)
0.0

27 freelancers are bidding on average $410 for this job

diorisaguilar

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 More

$280 USD in 4 days
(26 Reviews)
6.0
romainlopes92

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 in 1 day
(24 Reviews)
5.3
goodwork20k

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 in 3 days
(46 Reviews)
5.5
FreelancerTechX

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 in 3 days
(19 Reviews)
5.0
writingapp

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 in 7 days
(40 Reviews)
5.2
DebasisB

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 More

$250 USD in 7 days
(17 Reviews)
5.2
AwaisChaudhry

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 More

$750 USD in 14 days
(8 Reviews)
4.9
harihut

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 in 1 day
(9 Reviews)
4.0
nemanjadj20

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 in 2 days
(5 Reviews)
4.1
sachinparkhi17

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. More

$333 USD in 3 days
(9 Reviews)
3.3
akhileshgandhi

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 More

$750 USD in 14 days
(2 Reviews)
2.9
hayteekeys

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 More

$250 USD in 1 day
(3 Reviews)
2.6
ibrahim20

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

$250 USD in 7 days
(3 Reviews)
2.3
nikhilgarg96

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 More

$600 USD in 7 days
(0 Reviews)
0.0
Rakshithakrish

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

$250 USD in 3 days
(0 Reviews)
0.0
rohinsidharth

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 More

$250 USD in 3 days
(0 Reviews)
0.0
sakharamshinde

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 More

$250 USD in 7 days
(0 Reviews)
0.0
chirag9700

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 More

$500 USD in 7 days
(0 Reviews)
0.0
Demenntor

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 in 5 days
(0 Reviews)
0.0
sagarkrishna

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 More

$700 USD in 7 days
(0 Reviews)
0.0