I designed a prototype database to simulate an online application that I was designing for my client. both the offline demo and the online applications are now working fine. but since the offline is obviously faster to work with, especially with a lot of data, I am wondering if there is a way of working with offline system, then only once in a while make bulk post/update of data from the offline system to the online database. I am imagining that I can write an SQL statement that will pick the data from say Ms SQL and insert/update it to the online SQL database fields in an instance! Thanks. Mambo
Hi, I'd give local DTS a shot. You can add your local and remote servers then any data pump, which will be performed locally. It's pretty fast. Salute, Mark