Find Jobs
Hire Freelancers

Transfer data from AS400 database to SQL Server database

€250-750 EUR

Cancelado
Publicado há mais de 7 anos

€250-750 EUR

Pago na entrega
I need an ASP.net application (language vb.net) to transfer data from AS400 database to SQL Server database. At the moment this application is done in MS Access, I need to convert it in a web application. In Access database the AS400 tables are linked by ODBC, several queries get data from these "linked tables" and create "local tables". In the future, in MS SQL Server, there will be a Linked Server to AS400 (already created), hense the queries that today are executed on "linked tables" must be executed on "AS400 Linked Server". I need a web page similar to the present Access Form to launch the execution of the queries. I need also a log file to trace all queries execution with the result (positive or not). Other buttons in the Access Form are disabled because I will need it in a second moment (it will be the scope of a second project). Attached in the zip file: MS Access database "[login to view URL]" to transfer data MS Access database "[login to view URL]" to see linked tables structure (AS400 tables)
ID do Projeto: 11526248

Sobre o projeto

41 propostas
Projeto remoto
Ativo há 8 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
41 freelancers estão ofertando em média €524 EUR for esse trabalho
Avatar do Usuário
Hello, I am very much interested to do this work as i have strong knowledge in all the required skills for this project. Looking forward to have a positive response from you. Thanks
€480 EUR em 10 dias
5,0 (416 avaliações)
8,2
8,2
Avatar do Usuário
Any fees associated with an AS/400 will not "nominal." Unless you work for the US government. So you are really suffering, I can understand. Please do not award now just wait few more days. I just want to make sure what is there in the project to take care of this project. I know you shared me the application but it seems hebrew to me as there is so many databases and the main pain is language. Nonetheless, I can not connect to DB so this is useless in this moment to me. I can only see some data, that's all. Sorry, I like to be straight forward because it helps to reduce future mis-understandings. I would recommend to port this databases (Not the application) manually, why? See below the reason: - You will need to export the data from the database, you need to do an EBCDIC -> ascii translation, process the export so that it will import into SQL server. This is not at all easy work around - You can use any third party tools but it would kill your project budget. - You can go for a script which will connect to the AS database and will import data to sql server, it would costyou too. So, better to start the application from scratch and build the DB in Sql server, shat is your thought on this? Can you please give me a brief what exactly are you looking for in the log file? I can understand it needs to log the execution but should need to write any intermediate state as well? I need your highly co-operation to understand it properly, so waiting for your message.
€736 EUR em 10 dias
5,0 (73 avaliações)
8,3
8,3
Avatar do Usuário
Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and doing the project. Regards, Eyad
€789 EUR em 15 dias
5,0 (62 avaliações)
8,0
8,0
Avatar do Usuário
Salve, mi contatti in privato per discutere dei dettagli. Nella form di Access vedo diverse funzionalità, magari possiamo chiarirci subito, anche per farle una stima più accurata del lavoro. Saluti Armando
€736 EUR em 10 dias
5,0 (73 avaliações)
7,9
7,9
Avatar do Usuário
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
€526 EUR em 10 dias
4,8 (91 avaliações)
7,4
7,4
Avatar do Usuário
I am VB, VB.NET, MVC, XML & MS SQL programmer. I have experience about 10 years in programming complex database application as well as Windows Desktop and Server/Client application. you will get yearly service and support as well as update of this software to avail new version from me. I am professional to provide corporate custom complex software which is not available in the recent market. So you may turn your desired application dream to real. Long term support.
€555 EUR em 20 dias
5,0 (30 avaliações)
6,6
6,6
Avatar do Usuário
Hello Sir, I have gone through your requirements regarding Transfer data from AS400 database to SQL Server database. we brief and understand your idea and preference for job as you are looking for. I have more than 6+ years of experience in .NET, c#.net, vb.net, asp.net, MVC, Odoo, sql, mysql, Oracle, Azure, Entity Framework, Linq, Umbraco, Telerik, Devexpress, JQuery, Angularjs, CSS, HTML, Kendo UI, RDLC Report, Crystal Report, BioMetric Integration. I have developed more than 20 projects. Please send me message for further conversation. Thanks, Arity Infoway
€536 EUR em 10 dias
4,9 (60 avaliações)
6,6
6,6
Avatar do Usuário
Hi there, I’m an Access/VBA coder, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
€555 EUR em 10 dias
4,8 (79 avaliações)
6,5
6,5
Avatar do Usuário
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 will prepare following things for you - Technical Project Proposal - Flow chart for this Project - Execution plan (Step by step procedure with explanation how and at what that we are going to execute a particular task)
€773 EUR em 18 dias
4,7 (16 avaliações)
6,2
6,2
Avatar do Usuário
Hello My proposal is this. I will write a VB.NET application (is the asp mandatory ?) which will update the Tables. All the sql code will be on Stored Procedures in MSSQL Server. i will create a form in VB in which you will select the SP you want to execute. If the sp has parameters the form will ask for these parameters and then pass to the SP. The sp will log every step in a table and you will be able to see the results per sp / date. Of cource it is a must you have created the linked server. Kind Regards George
€500 EUR em 20 dias
4,9 (66 avaliações)
6,0
6,0
Avatar do Usuário
Dear hiring manager, I have +5 years experience in .Net skills specially in ASP.NET, MVC, C#,L AND SQL SERVET for open source have 1 year experience with angularJS and MongoDB my best happits is honest and clear I provide support for my projects for free
€250 EUR em 3 dias
4,9 (27 avaliações)
5,8
5,8
Avatar do Usuário
Having 10 + years experience in ASP.net and willing to start the work immediately .
€666 EUR em 10 dias
4,6 (213 avaliações)
6,3
6,3
Avatar do Usuário
I have more than 7 years of experience in IT industry.I have worked on .net(c#,asp.net,mvc) with SQLSERVER 2005/2008/2012 and ORACLE(pl/sql).I can provide you best solution. Awaiting for you to describe your problem so I can give you best solution right away :).
€583 EUR em 10 dias
4,9 (32 avaliações)
5,4
5,4
Avatar do Usuário
Good morning, I have read your project description and understand what your trying to achieve. I have current experience of working with asp.net and both db2 on the AS400 as well as SQL Server. I have written a number of ASP.NET web applications that interface directly with the AS400 to read and write data - so I beleive that I have the relevant skills to complete your task. You have mentioned linked servers, can I suggest that for performance you abandon this idea and instead interface directly with your AS400 using the IBM provider for .NET and of course the SQL server providers are included as part of .NET. I would be more than happy to discuss my proposal with you in greater detail should you want to contact me. Look forward to hearing from you. Kind regards Damian
€555 EUR em 10 dias
5,0 (12 avaliações)
5,2
5,2
Avatar do Usuário
Dear Sir/Madam, From your project declaration, its the kind of job I have been experienced very well. I have been experienced in programming including MS Access and .NET since 2000 and gained valuable huge experience and knowledge in programming and databases. I developed several featured web applications using .NET (codebehind VB.NET) with MSSQL server such as: Human resource management system, time attendance system, hospital information system, Statistical database for Ministry of Transport, Mongolia, Flight information system, Financial order system..etc. Also, I had been working as a senior developer for Financial system developed in MS Access over 6 years. During that period, I had working in systems integrating MS Access to MS SQL and one of them is Financial Order management and Reporting system which reads/collects data from MS Access databases (there were about 20 databases for each company of Group company), importing and processing collected data and display Reports about companies' performances and other things. To display reports on pages, I used Crystal reports with .NET and Reporting services of MS SQL. I strongly believe I can provide you best solution after you provide me your detail requirements. You can see from my profile page about my past performances and customers' feedback gave to my performances. Hope to hear from you back, soon. Kindly Regards, Alta
€400 EUR em 10 dias
5,0 (22 avaliações)
5,2
5,2
Avatar do Usuário
Professional Experience - Highlights • 8+ years of experience in MS SQL Server development • 6+ years of experience in C# asp.net application development • 2+ years of experience in vb 6.0 Application development • 4+ years of experience in SSIS development • Health Care, Financial, Renewable Energy and E-Commerce domain • 3 projects experience webscraping • Worked on web applications and windows applications using C#, asp.net, MS SQL server and SSIS technologies. • Developed more than 10 web applications, more than 3 windows applications using c#, asp.net and MS SQL server in Financial, Renewable Energy and E-Commerce domain. • Expert in developing complex store procedures, SQL scripts, efficient triggers, required functions, creating indexes and indexed views for performance. Experience in writing complex SQL queries involving multiple tables inner and outer joins • Experience in monitoring SQL Server Performance tuning, identifying dead locks and resolving them in SQL Server 2008 using SQL Profiler • Expert in designing ETL data flows using SSIS; Worked extensively on ETL process using SSIS package from Excel, Flat Files to SQL Server databases • Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging
€600 EUR em 10 dias
5,0 (7 avaliações)
4,8
4,8
Avatar do Usuário
Hi,I have gone through your project description. I could be confident if we can proceed towards more discussion. I am an individual developer and you will be working directly with me if we proceed work on this project. My key skills are - 1)Ruby 2)Ruby On Rail 3)Angular JS 4)Node JS 5)PHP with codeigniter and Laravel Framework. Let's initiate our chat so we can proceed towards conclusion of this project scope and give it a start as soon as possible. Thank & Regards Prashant Shinde
€833 EUR em 18 dias
5,0 (9 avaliações)
4,9
4,9
Avatar do Usuário
Dear Buyer, I work as a programmer since 1985. I went through your two databases and it seems a rather straightforward task. I wold like to confirm a couple of things : the SQL server is set and running, so you will provide connection string credentials for the Web application ? the "local tables" will be in the local Access database you provided ? And, finally, you want your queries to remain in Access, or you want them to become stored procedures in SQL server ? Many thanks in advance for considering my bid. Looking forward to hearing from you. With best regards, Solon ...
€250 EUR em 10 dias
4,9 (30 avaliações)
5,0
5,0
Avatar do Usuário
hi sir I can do this within 4 hours.
€277 EUR em 1 dia
5,0 (9 avaliações)
4,6
4,6
Avatar do Usuário
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
€250 EUR em 7 dias
4,9 (34 avaliações)
4,5
4,5

Sobre o cliente

Bandeira do(a) ITALY
Bergamo, Italy
5,0
61
Método de pagamento verificado
Membro desde out. 20, 2014

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.