Lengkap

Windows Application as a Service

Windows Application as a Service that monitors a folder and executes scripts that arrive in folder

Objective:

1. Create small application that can encrypt SQL scripts (for SQL Server) hosted on a local machine.

2. Create Agent application as a service on a remote machine that monitors folder for arrival of files and executes when found.

Please see attached word document for more details.

Please feel free to make notes that that document and I will respond accordingly.

Process Flow:

User creates SQL script file(s) (a .sql MS Sql Server File) and place them in a folder on local machine.

The user opens the encryption application in (1) above and encrypts the SQL files in the folder above.

Then once these encrypted files have been copied to the remote site (not part of this solution), an Agent program that runs as a Windows Service (created in C#?) (see (2) above) will be monitoring a specified folder location real time for the arrival of the encrypted SQL scripts.

The Agent will also monitor the folder for the arrival of a DLL assembly, a SQL CLR Stored Procedure Class Library with a specified Digital Signature.

If this Assembly is valid, i.e. the name matches the expected DLL file name and the Assembly’s Digital Signature matches what the Agent expects, then it needs to drop and re-register the CLR Assembly in SQL Server first before the execution of the SQL scripts.

NOTE: the Agent needs to know and store the settings that tell it which SQL Server Instance, database, and SQL Account credentials to use in order to establish a connection to the SQL Server.

Of course these settings also need to be stored in an encrypted configuration file.

The encryption key that is used to encrypt the SQL scripts is the same key that will be used by the Agent to decrypt the scripts.

Before SQL scripts are executed, they need to be validated -- .i.e. checked for SQL errors.

Also as an added security feature, a simple key needs to be present at the first line of each script as a comment line. This key is also hard coded inside the Agent, and must match the SQL key.

After the DLL is registered in SQL Server, it gets deleted from the folder.

After the SQL scripts have been executed, they also get deleted.

It would be nice if there was a simple log file that could trace the events.

It would be even better if this log file is encrypted so that it can only be viewed through a special viewer. Perhaps the same utility on the local machine that was used to encrypt the SQL scripts in the beginning?

Kemahiran: Pengaturcaraan C, Pengaturcaraan C#, Pengaturcaraan C++, Memasang Skrip, SQL

Lihat lagi: service application, windows c programming, what is a library in programming, what is a class in programming, sql programming course, sql assembly, signature database, signature assembly, service first, server assembly, remote key programming, programming what is a class, programming scripts, programming monitor, programming in assembly, programming events, programming errors, programming a remote, objective programming, local programming

Tentang Majikan:
( 91 ulasan ) Cairo, Egypt

ID Projek: #1385047

Dianugerahkan kepada:

Divya3011

Hi, I have 7 years of experience in DOTNET ,C#, web and windows application development using VS 2008 and VS 2010. I am place a bid here because i really appreciate the clarity of requirement details you have placed Lagi

$250 USD dalam 20 hari
(5 Ulasan)
3.7

11 pekerja bebas membida secara purata $218 untuk pekerjaan ini

specialist77

I have experience with a similar application that is monitoring a folder for a new plugin (dll) and installs it automatically. Of course it works as windows service. On the other hand I have 4 years of experince in Cry Lagi

$195 USD dalam 5 hari
(11 Ulasan)
5.6
aptecpymefree

Hi. I can work in your Windows Application as a Service. I have 14 Years of experience in Software development Windows and Web. Expert in Sql Server and .NET. Microsoft Certified as MCP, MCTS, MCPD, MCT. Please contact Lagi

$250 USD dalam 15 hari
(4 Ulasan)
5.4
momo2619

Dear Sir, Please read my PM. Thanks Meena

$200 USD dalam 4 hari
(18 Ulasan)
4.2
PriyankaKale

I can do this project looking for a chance. Pay me if you are satisfied with output.

$200 USD dalam 10 hari
(1 Ulasan)
3.4
Fransj

30+ years in Information Technology using numerous programming languages on different platforms. A lot of experience in writing services using C#.

$200 USD dalam 5 hari
(0 Ulasan)
0.0
AngloThai

Hi, Please see my PM with regard to suggestion. I am a native English speaker (British citizen). I am degree educated (Master's degree from a top British university). I have worked in the IT industry for mor Lagi

$250 USD dalam 20 hari
(0 Ulasan)
0.0
adolfogc

I have experience on similar projects and I can provide you a quick and the best solution, so let's get in touch to start to work.

$210 USD dalam 5 hari
(0 Ulasan)
0.0
fzenha

I'm a professional software developer for over 8 years experience. I have all the skills needed for this job. Please contact me.

$200 USD dalam 7 hari
(0 Ulasan)
0.0
Pushpendra2103

We are a group of highly dedicated, self motivated, honest and qualified professionals. Our group is named "PSR Application Studio". We have hands on developed experience in Web Application, Windows Application Lagi

$190 USD dalam 3 hari
(0 Ulasan)
0.0
gauravmani12345

"Please see PMB"

$250 USD dalam 10 hari
(0 Ulasan)
0.0