Closed

develop database

Need a database to store big mail server logs. It needs to read POP, SMTP, IMAP & Delivery logs (examples will be provided).

We need a script that runs daily that will read the next generated file for the day. For example at 5Am each day the script will run to match the file format for that day and dump that into SQL DB.

The database needs to be searchable and each of those seperate tables are in the same database.

The name of the file (which is the date) needs to be a column in that database as well so when it pulls the file name it needs to add it to the database in a new column called date.

If you have any questions please fee free to ask or place your bid so we can have further discussion

data needs to be encrypted example INSERT INTO maildata-pop3 VALUES ("2015-05-01 20:40:21", AES_ENCRYPT("8.8.226.8", 'mypassword'), AES_ENCRYPT("USER xxx@domainname.com", 'mypassword'));

For the end result we would need a powershell script or a bat script that we can run in the task scheduler but you can use php or script as long as we can get the task scheduler to run it

Skills: Database Development, MySQL, PHP, Software Architecture, SQL

See more: create oracle database tables using sql ddl, create oracle database tables using sql, asp database website searchable, convert sql dump database, list tables structure sql server 2005, tables images sql 2005, ria database develop, create mssql tables net sql csv file, pda database develop, online game database develop

About the Employer:
( 223 reviews ) Liverpool, Australia

Project ID: #10395204

45 freelancers are bidding on average $1281 for this job

best1

Hello, Greeting From Best1 Family!! We have been through your project description and figured out that you want to develop a database. Seems that you like to create a database to store big mail server logs. Mails c More

$2061 AUD in 30 days
(279 Reviews)
9.9
leadconcept

Dear Sir, I have read Project Description & wanted to know if it would be a client side/admin side Application? What features/functionality you want in this App? Can you explain little bit about the overall flow or More

$1666 AUD in 40 days
(86 Reviews)
8.9
kabirchy

Hi there - My name is Khorshed. I've read your brief and can see that you’d like to develop a custom PHP, MySQL script to read POP, SMTP etc. log and write in database . I can help you get this done. I have several yea More

$1184 AUD in 20 days
(1129 Reviews)
9.0
TenStar718

Hello!!! i have build Bank Management System, Shopping/Order system,Patrol Management System. I have full experience in JSP, JQuery, PHP technologies. also , i have master laravel and codeigniter frameworks and an More

$1184 AUD in 20 days
(176 Reviews)
8.1
nuked24

Hi, We are expert in designing as well in development. We will provide you quality of work. We will provide you our [login to view URL] want long term relationship with you. Please choose us and provide a chance to work wi More

$1546 AUD in 20 days
(155 Reviews)
8.5
KESHAVINFOTECH

Hi Thanks for your valuable time. :-) Please check below points : 1. Need a database to store big mail server logs. It needs to read POP, SMTP, IMAP & Delivery logs (examples will be provided). We need a s More

$1500 AUD in 40 days
(607 Reviews)
8.4
seekdeveloper

Hi, I have read your post and understood your requirement. I have great experience working on Database Development/PHP/SQL/MySQL/HTML5/jQuery/Wordpress/Magento/Joomla/Drupal/AngularJS/node.js/CSS3/Java/Python/Dja More

$1546 AUD in 14 days
(105 Reviews)
8.6
winmaclin

Hi, By reviewing job descriptions, We can definitely help you to develop a database according to your mentioned requirements. As, we have depth experience in creating database with using latest technologies and tool More

$2000 AUD in 30 days
(280 Reviews)
8.1
inzaghi2006

Hi, I'm senior web developer and I'm very interested in your project. I've done many projects. Hope I will have a chance to work for you on this project. Please contact me. Thanks

$1250 AUD in 5 days
(198 Reviews)
7.2
scriptphp87

Hello, I'm a professional programmer for web programming with php language to build the system website, Besides, I'm also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer [login to view URL] More

$1263 AUD in 30 days
(240 Reviews)
7.9
eperfections

I have done similar work for telecom billing operators. Please send me details about the input file. I have 10+ years experience. I have completed more than 600 projects on this platform. Very interested in this projec More

$1500 AUD in 20 days
(321 Reviews)
7.4
extreamcode

Hi there, I’d like to be considered for your Project. I’m a designer and developer with expertise and experience in Web designing, HTML, CSS, PHP, AJAX, JQuery, Wordpress, MySql, magento, joomla,etc. For 6 years I’v More

$1250 AUD in 20 days
(57 Reviews)
7.3
londonlance

We are a London based Fullstack dev studio, WE BUILT SILICON VALLEY LEAGUE PRODUCTS FOR A FRACTION OF THE COST. All our projects are version controlled with GIT (Github or Bitbucket). Following are some of our rece More

$1425 AUD in 30 days
(35 Reviews)
7.5
prashushinde9

Hello, I understood the initial scope of this project. Although i want to discuss further this job in order to prepare the final concept for this project. After Complete discussion over the call or in chat, i More

$1546 AUD in 40 days
(52 Reviews)
6.9
pytho

Hi, Please tell me what is your deadline for this project? I am managing a Web Design Agency located in Romania and I am really interested to help you complete your PHP website. Based on your response I will be able t More

$1778 AUD in 30 days
(39 Reviews)
6.9
rkmomin

Hi, Ok, we will do it. Please contact for more discussion. Please see our profile for our recent reviews and feedback. Websites URL: [login to view URL] [login to view URL] http://www.1800jobq More

$1000 AUD in 20 days
(144 Reviews)
7.0
guoxinliu917

Hello, I have the experience to read text file into Microsoft SQL database using .NET. I can develop the exe and you can schedule it to run at your expected time. I have had the code to read text file line and line and More

$750 AUD in 3 days
(47 Reviews)
6.8
Shopify

I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably More

$1546 AUD in 40 days
(19 Reviews)
6.8
mobileappdevin

Hi, I am a top notch designer cum developer who has a great deals of experiences with the latest know-how to complete your project in your line in the stipulated time. I am expert in css html5 jquery, js, node js, More

$1053 AUD in 20 days
(38 Reviews)
6.8
mike199

My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & More

$1250 AUD in 20 days
(48 Reviews)
6.9