Finalizat

Powershell Script - Further Changes

For @ibrahim20:

(Read it in the word document attached for better formatting)

Based on what is already done in the previous project, I look for following new requirements:

- Add Server, Database and BasePath in configuration file. Review Sample Configuration file.

- In current design, I can have ONLY ONE StartsWith, ONLY ONE EndsWith and ONLY ONE Contains. This is restrictive. For example I want StartsWith “ABC” or StartsWith “DEF”. So following is proposed:

- Use a list (array) of Tasks. Each Task is a scripting task.

o ObjectType can be Table or View or StoredProcedure or Funciton

o Filter should be Regex expression (always use -match and not -like). (e.g. Expression starting with ABC should be “^ABC”. Expression Ending with ABC should be “ABC$” and contains will become “ABC”.

o Location Filename will be name of the object .txt and it will be stored in $BasePate + $Location.

 If the folder does not exist, then create it.

 If the file already exists, then overwrite it (instead of append).

- I also want to define Scripting Options in the config file. Following Scripting Options are important: (Reference: [login to view URL])

o AnsiFile

o AnsiPadding

o ScriptData

o ScriptSchema

o ScriptForAlter

o ScriptForCreateDrop

o Indexes

o Triggers

I don’t know what is the best way to put Scripting Options in the config file, so that its easy to use. But I want each task to have own set of scripting options.

o For example, I want to have one task to ScriptData (of filtered set of tables).

o I may want to script Alter statements instead of Create Statements.

o I may want to script Drop (if exists) statements before Create options.

o I want to script all constraints and triggers.

(We can discuss on this)

Attached is an example of how a table is scripted by current PS script and how I did it in SQL Server Management Studio, using Options from “Generate Scripts” dialog and selecting the options. I need to script the way its done by “Generate Scripts”.

The Ultimate Goal:

o My goal is to run this script and output files in a specific folder.

o This script should be scheduled to run every night.

o A next piece of script (not included in this task/project) should push the generated code (scripts) into a GIT repository and commit. All changed files should get committed with new version. If script is exactly same as what it was in last script generation, then no GIT will keep the old version.

Aptitudini: Server Microsoft SQL, Powershell

Vezi mai multe: sql script database changes, php script functionality changes freelancer, php script check file read, script router changes, powershell script add users excel file, exchange 2007 powershell script, powershell script users creation, powershell script create multiple users, powershell script create account, hyper wmi powershell script power, powershell script add user excel file, php script detect changes web page, powershell script read excel file, powershell script read excel, i don't like my job but i don't know what else to do, powershell script to read and write csv file, powershell script to read excel file and write-output, powershell script to read csv file and write output

Despre angajator:
( 6 recenzii ) Dubai, United Arab Emirates

ID Proiect: #28920408

Acordat lui:

ibrahim20

Hi, I am a c# developer for past 7+ 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 Mai multe

%selectedBids___i_sum_sub_7%%project_currencyDetails_sign_sub_8% USD în 7 zile
(7 Recenzii)
3.8