We need an ASP Function that "synchronize" 2 SQL SERVER DB. We explain below what we mean by "synchronize".
This function has two parameters : the source DB, and the target DB. The "sync" has to change the target DB so it's "synchronized" with the source DB.
For integration purposes, the following connexion string has to be used to connect to the DBs :
ConnStr = "dsn=" & COM_CUS_Id & ";uid=" & CLI_ID & ";pwd=" & CLI_ID & ";DATABASE=" & CLI_ID & ";APP=ASP Script"
Set MyConn= [login to view URL]("[login to view URL]")
[login to view URL] ConnStr
where CLI_ID is the ID for the source or the ID for the target DB.
We need to have the target table similar to the source table. So to avoid making changes twice, we need this "sync" program, that when launched, will make the necessary changes to the target DB so it becomes like the source DB, with the following points :
1/ Some tables will be altered on the design only. Example, a customer table : source and target have to have the same design but not the same datas. So if we rename the column CustomerMobileTel to CustomerMobile, the column has to be renamed on the target DB but the datas must not be altered (target DB is a production DB with real datas).
2/ Some tables will be altered on the design and the datas. Example configuration table with internal parameters. It this case the design AND the datas have to be the same.
The program has to be able to deal with any kind of modification : adding tables, changing column names, adding / droping columns, adding keys, defautls values, etc. After it has run, no difference should me made between the two DB except the datas of the tables that don't have to be sync on datas.
The system has to connect to some "admin" DB that will have a table of tables, telling which tables have to be sync, and if the sync has to be on design and datas or design only.
## Deliverables
Prerequesites about the coding
- The program has to be written in ASP EXCLUSIVELY.
- The code needs to be clear, well commented, and has to be well split with functions (no 500 continuous lines, but a main program of few dozens line calling functions, etc.)
- Intensive tests have to be made. A set of tests that passed well has to be given to us.
Deliverable
- The ASP source code, given to us as a main function so we can include it in our code
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):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
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
IIS / ASP / SQL SERVER