Find Jobs
Hire Freelancers

Convert Microsoft SQL Database to Online Server based MySQL Database with interface -- 2

$30-250 USD

Закрито
Опублікований about 8 years ago

$30-250 USD

Оплачується при отриманні
I have a significant amount of data already stored on a local SQL relational database created by a beginner student in a mix of Microsoft C# and SQL. I currently have a LAMP server with goDaddy that I would like all this information transferred to in a reorganized better way. And to have a secure way of accessing it, querying from it and adding data to it as work commences. The Attached file: "DB [login to view URL]" shows how the current DB is setup. The tables are all messed up. Basically four customer tables "Banks, Agents, Embassys, Companys" need to all be combined into one "Customers" table, and their IDs consolidated properly. The student who did this project designed it poorly, and part of the project is to consolidate the data correctly in the proper (and simpler) db design structure. One clear problem is the student first quires the "kind", then based on the "kind" (Bank, Agent, Embassys, or Company), she then quires the customer table,. This is flawed in principle because customer IDs are now duplicated across "kinds" and are not unique. Part of this project is to remap the customer records to their proper unique IDs and combine all those customer tables into one big one. The "kind" is still important, but it is another categorical field just like any other attribute. Also part of the project is to have "admin" access to create new kinds, customers, zones, etc, and most importantly adding new "operations" into the operations database. Basically the student put a lot of effort entering the data into the DB in its current structure and application, and I need both the data, application, and platform fixed and transferred online to be used properly. BTW I'm open to other suggestions. The programmer/designer that will work on this will have to ask me more questions to get all the requirements correctly and help me simplify this as much as possible. In the end it's just a customer database, and a transactions database solution.... straight forward stuff. P.S. see attachments
ID проекту: 9719354

Про проект

19 пропозицій(-ї)
Дистанційний проект
Активність 8 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
19 фрілансерів(-и) готові виконати цю роботу у середньому за $232 USD
Аватарка користувача
Hi, I’ve had a good look at your project description and I’m very interested in providing a solution. I have 4+ hands on experience on developing quality web solutions as well as desktop standalone solutions. I used to develop systems using latest adaptive technology such as 1. .NET/ASP.NET - MVC4,MVC5 - Entity Framework - SQL - C# (for .NET solutions) 2. JQuery/Javascript/HTML5 - Angular.js/Bootstrap etc (for designing and front end implementations) I want to start work immediately and awaiting for your positive response on skp id "agilepksolutions" so I can show you some of my Quality Development Work as well as we can discuss project in details. Thank you.
$147 USD за 3 дні(-в)
5,0 (71 відгуки(-ів))
7,6
7,6
Аватарка користувача
Hello, You actually explained the current situation, what needs to be done to make the database better and the UI to access the database. I agree that the "kinds" should be another categorical field. Regarding the additional project description you posted: #s 6 and 7 would be populated by values in the database with #7 appearing based on the selection on #6. The rest are pretty much self explanatory. Looking forward to getting some feedback from you soon. darkwind
$250 USD за 5 дні(-в)
4,8 (269 відгуки(-ів))
7,6
7,6
Аватарка користувача
Hi, I can do your job but need to make a short chat discussion with you. let me know if possible for you. please let me know. You can check my profile and feedbacks of clients which itself I got from them. Hope they make some small help trust on me for your job. Regards Rina
$1 094 USD за 7 дні(-в)
5,0 (74 відгуки(-ів))
7,2
7,2
Аватарка користувача
Hello. I agree that the tables should be combined. We can discuss further. Thanks. Eugene.
$222 USD за 3 дні(-в)
4,9 (274 відгуки(-ів))
6,8
6,8
Аватарка користувача
Dear Sir/Madam, I have over 8 years of work experience in PHP, MySQL, SQL, HTML, CSS, Javascript, jQuery, .NET, Bootstrap, C, C++, C# and so on... Please visit the links below to see some of my skills and to see few of my works: https://www.freelancer.com/u/TechnoVilla.html I can ensure you that you will be fully satisfied with my work. You will be realized that I have a wonderful skills and strong abilities while I am working on your project. If I cannot complete your task with my skills, I will refund all funds to you based on 'Money Back Guarantee' Rule. But I can confirm you that it will never happen! Looking forward to working with you soon. Thank you! Kind Regards, TechnoVilla!
$200 USD за 3 дні(-в)
5,0 (78 відгуки(-ів))
6,3
6,3
Аватарка користувача
Dear Sir, This is Sikander. I have read you job specification and came across your requirements about this project. I have 14+ years of experience in software development and I am ready to start this job. Please discuss in detail. So I can give you exact time frame and budget for this project. I will provide you best services in development. Please have a look at my Profile, Ratings and feedback. Please let me know, if you want to see the samples of my work. I am working in Microsoft technologies and you can find the details below. My Skills includes: 1) .Net (Web/Windows) asp.net 2) MVC 3) Entity Framework 4) WPF/WinForms 5) MSSQL Server 6) SQL Server Reporting Services 7) Javascript/JQuery 8) WebServices/WCF Services 9) MySQL 10) Hosting Sites 11) Mailchimp 12) AngularJS 13) Recently Worked on Vending Machine solution with Monetary apparatus and Shipping Goods motor also worked on Kisok applicaiton. many more...... I have no fancy talks, no false promises and nothing to hide but honesty and a great will to expand our work experience. I am willing to expand my work experience to different clients and in this order I apply for this job in the hope to hear some positive response from you. I hope you will take us positively and will give us a chance to work with you. Many Thanks & Regards Sikander
$333 USD за 5 дні(-в)
4,9 (43 відгуки(-ів))
6,5
6,5
Аватарка користувача
Hi; I'm an expert PHP programmer with some necessary skills to build complex webapps like MySQL, SQL Server and Sqlite databases with SQL query language; various Linux server administration skills like installing, modifying and optimizing servers like Apache, Nginx, Varnish, PHP accelerators. I have great interest in your project. To assure my customers about my work ethic, I do not ask upfront payments. Normally, unless there are many milestones for bigger projects, you test then pay. Please check my bio, testimonials and exams I took to show my skills. Please feel free to ask questions, and I'll happily answer them. Best Regards
$155 USD за 3 дні(-в)
4,9 (36 відгуки(-ів))
5,4
5,4
Аватарка користувача
HI ! i am a professional c# developer and i have very good experience in Database & Software development. i want to work on your project. I want to work on your project. i have not read the full specs now but i will do it once you PM me and show me that you are interested in work. I am a professional developer and as you have a system built up already but you are not satisfied what i can do for you is that i can work for you in advance and in the end if you like the work you can pay me in the end :)
$150 USD за 3 дні(-в)
5,0 (38 відгуки(-ів))
5,0
5,0
Аватарка користувача
Hello, Please feel free to discuss the project with us by sending us a message or adding us on skype. We assure you the best services. Thanks
$133 USD за 5 дні(-в)
4,9 (24 відгуки(-ів))
4,4
4,4
Аватарка користувача
Hi, Please feel free to discuss the project with me...................................................................................................... Thanks, Murtaza
$350 USD за 5 дні(-в)
5,0 (9 відгуки(-ів))
4,4
4,4
Аватарка користувача
Hi, I have 13 years of experience in software development. I can do what you require easily but first let me remind you that, what that student did was 90% correct. This is the ideal structure of a database to handle the data when it gets bigger. The 10% wrong part is caused by the lack of communication I think. If you want to have multiple kinds of a same customer, than there should be 2 more tables (one for Customers, and one for Customer_Company relation) with the fields Customer_ID, Company_ID and this way you can store multiple company rows with the same customer_id, but different company_id's (which has different kind values) So I can convert your data and modify your search and admin forms, but I advise you not to convert it all to PHP and MySQL for running it in LAMP, which means you have to start from beginning. If you can host this ASP.NET page in your GoDaddy account with MS Sql as it currently is, I can do what you described in a very quick way...
$250 USD за 2 дні(-в)
5,0 (9 відгуки(-ів))
3,9
3,9
Аватарка користувача
Hello, I hope you doing very well! I have gone through the description and would like to provide a quality solution using my 5+ years of professional experience in required skills. (.NET/ASP.NET - MVC, EF, SQL, C#). Awaiting for your positive response so we can have final talk and start project immediately :)
$140 USD за 3 дні(-в)
5,0 (10 відгуки(-ів))
3,4
3,4
Аватарка користувача
Hello my name is Kostas and I am a c++ developer with an extensive knowledge of data structures, algorithms and databases. All of my clients were very satisfied with my job you can take a quick look at my page here. Please send me a message to discuss the details. Thank you in advance, Kostas.
$100 USD за 3 дні(-в)
4,9 (3 відгуки(-ів))
2,0
2,0
Аватарка користувача
Hi, I will redesign the RDBMS and transfer all records from old database into new database (mysql) without primary key duplicated. My goal is the application running properly in new database. I'm expert in RDBMS and PL-SQL common query
$166 USD за 5 дні(-в)
5,0 (1 відгук)
1,4
1,4
Аватарка користувача
Hi! That could be done in to stages: 1) Update code to refer to new Customer table (id, kind_id, name), run sql script to create and fill Customer table from Banks, Agents, etc. and update Operations with new customer id. 2) Add administrator's pages
$100 USD за 7 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Hi, i have also that same problem before. There's a function in Mysql that reads the file and automatically upload it to your database.
$111 USD за 7 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Hello Sir, Myself Charandeep Singh having 4 years of Bachelor's Degree in Computer Science and Engineering and more than 14 years of experience as a Software Programmer. My Skype ID is deep_singh78. ####AREAS OF EXPERTISE##### Desktop applications (****14+ Years Experience****) Web Applications (****12+ Years Experience****) Windows Services (****7+ Years Experience****) C#, VB.NET (****10+ Years Experience****) ASP.NET/MVC/ Entity Framework (****5+ Years Experience****) XML (****5+ Years Experience****) JQuery (****5+ Years Experience****) MSSQL SERVER (****10+ Years Experience****) MySQL (****4+ Years Experience****) I have worked with mid to large scale projects including government and private in Sacramento, California for 12 years. My latest projects on includes technologies like MVC, Entity framework using Azure platform. Creating web jobs and anything related to creating databases , queues on azure platform. From the last 14 years I have been developing applications including Web, Desktop, Web, Mobile and Windows Services . I have been doing programming in C++, C ,C# , Visual Basic, VB.net. I have worked on 3 different relation database, SQL SERVER, DB2, MS ACCESS. I am proficient in writing SQL Queries, Stored Procedures, indexes, joins, triggers, views. I am also Microsoft Certified Professional Developer [MCPD] and Sun Certified Java Programmer [SCJP]. Looking forward to hear from you. Regards Charandeep Singh
$238 USD за 5 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор EGYPT
Nasr City, Egypt
5,0
4
Спосіб оплати верифіковано
На сайті з лист. 23, 2015

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.