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("", 'mypassword'), AES_ENCRYPT("USER", '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


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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)