Em Andamento

Check database tables and fields exist and create if missing

We require a web based database compare and merge tool suitable for SQL server and Access databases which will use compare a target database against a known? master looking for changes.

We have no end of issues with keeping different databases in sync. This will often mean more than a simple compare to solve schema mismatch issues. Often it will require manual creation of tables, fields or even data type changes to the target database. This is a time consuming issue that we frequently come across.

We would like to have an automated method of comparing a database to a known master? database and ensuring the database schema matches the master database. The master database may be MS Access but is more likely to be SQL Server. The target database will be either MS Access or SQL Server.

To ensure compatability, the create and alter tables generated by the application must cater for the differences. This will include memo type fields in Access mapping nvarchar(max) in sql, indentity fields in SQL mapping to autonumber in Access to name a few.

The application will be web based and portable so we can copy it as required to different servers. The user will enter a connection string to the master database and the target database.

The target database will be compared to the master database and a list of differences displayed. The user can then accept the recommended changes the target database will be modified to comply with the master database.

At no time will the target database drop tables as all changes will be either create or alter tables.

Habilidades: .NET, ASP, Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Ver mais: sql server max, max sql server, check for connection, access database sql web application, asp sql connection, compare exist, sql database sync, drop list database, database connection php, connection string access, create simple access database, SQL Data Sync, sync sql server, copy tables, sync time server, php sync database, simple database web based, database connection, create database tables application, check compare, sql server merge data, simple web based tool, create alter, web manual creation, create access end

Acerca do Empregador:
( 5 comentários ) Australia

ID do Projeto: #3052629

Premiar a:

farhanshahid

See private message.

$17 USD em 14 dias
(1 Comentário)
0.5

15 freelancers estão ofertando em média $522 para este trabalho

RaiseSolutions

See private message.

$2499 USD in 14 dias
(31 Comentários)
7.4
orientconsultanc

See private message.

$637.5 USD in 14 dias
(28 Comentários)
6.0
f1mei0

See private message.

$340 USD in 14 dias
(53 Comentários)
5.1
Ignytek

See private message.

$1275 USD in 14 dias
(23 Comentários)
5.3
techwavelx

See private message.

$1700 USD in 14 dias
(3 Comentários)
5.5
vw7425922vw

See private message.

$340 USD in 14 dias
(8 Comentários)
4.4
yesican100

See private message.

$85 USD in 14 dias
(14 Comentários)
4.0
tabwebcoder

See private message.

$85 USD in 14 dias
(20 Comentários)
4.0
northskysoft

See private message.

$297.5 USD in 14 dias
(6 Comentários)
3.3
g3infotech

See private message.

$127.5 USD in 14 dias
(1 Comentário)
2.9
vw7288407vw

See private message.

$85 USD in 14 dias
(3 Comentários)
2.9
nerminemavw

See private message.

$51 USD in 14 dias
(3 Comentários)
1.5
micahh

See private message.

$127.5 USD in 14 dias
(0 Comentários)
0.0
emanProDev

See private message.

$170 USD in 14 dias
(0 Comentários)
0.0