A client has a MS Access 2000 Database that has about 50 Tables. The Access 2000 database is continuously being updated every minute and often every second. The server is a webserver running Windows 2000. The client has a second Server (SQL 2000 server). We need a method that will take the MS Access database and import continuously into the SQL database using the same table structure. Here are the stipulations: 1. The SQL must have the data as quickly as possible from the Access Database 2. It must conserve resources no matter how it moves the data 3. It must NOT import duplicate data 4. It must be reliable and fully automatic & Manual (if needed) 5. It can not interfere with the data that is being written in real time (meaning you can not lock the database while you do the export/import) 6. Some kind of status screen in either ASP or .NET that we can see the current operating status (Currently importing XXX etc...) How this is done is completely up to the coder however it must be efficient and reliable. If the system ever stops for anything (Either Server) it must be able to catch up and continue working. A copy the the database is provided
## Deliverables
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
## Platform
Windows 2000 Server, SQL 2000 server,