Closed

AdvantageDB to MS SQL Server Replication

We're looking for someone familiar with AdvantageDB Server (now owned by Sybase, sold as iAnywhere). In addition to this project, we do a lot of work in both databases (AdvantageDB 8.1 & SQL Server 2005) and there is an option for future projects together.

This initial project is very simple. We query information from a few tables in AdvantageDB and populate SQL Server with the results, also from SQL Server to AdvantageDB.

The app will be a simple VB DotNet 2.0 service that periodically runs queries in both databases using (access to AdvantageDB is straighforward much like SQL Server, using Advantage .NET Data Provider 8.1).

The project will require familiarizing yourself with a thorough data model.

The second component of this project is a SQL Server-based application that is managed by a VB DotNet 2.0 GUI which is a very simple contact management application. There will be a one-to-many with a "contact history" table and a report that is used to print address labels based on simple criteria (days since last contact, etc). I will provide a full table-structure (ER Diagram) and documentation. This is build upon a database in SQL Server, but allows the data to be forwared into the AdvantageDB using identical logic to what is developed in the first component of this project.

There is a third component of this initial project that is not required to be part of the first bid; however, you may choose to bid on this as it's a fairly simple extension of the GUI. This third feature is to utilize a PDF component (we've used [url removed, login to view] in the past) to simply insert data/mail-merge information into a PDF.

This initial project is intended to be fairly straightforward so that we can finish quickly and determine your capabilities to potentially work on several other projects we have in works.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

MS Windows / DotNet v2.0 SDK

Skills: Database Administration, Engineering, MySQL, PHP, Software Architecture, Software Testing, SQL

See more: what is vb net used for, what is data in data structure, what are the application of data structure, vb net feature, third party service provider agreement, tables in data structure, sql coder for hire, sql code pdf, provider service agreement, model service agreement, it service provider agreement, hire a sql coder, what is ms sql, what is ms access, sql server gui, dotnet 2.0, very simple data insert, sybase, SQL Server, sql server c, sql projects, sql database report, report sql, replication, net sql server

About the Employer:
( 0 reviews ) United States

Project ID: #3107143

4 freelancers are bidding on average $177 for this job

phosphorvw

See private message.

$127.5 USD in 20 days
(90 Reviews)
5.9
mabian

See private message.

$85 USD in 20 days
(31 Reviews)
5.6
hunghmvw

See private message.

$178.5 USD in 20 days
(15 Reviews)
3.9
williamxvw

See private message.

$318.75 USD in 20 days
(1 Review)
0.0