Hi, Please I'm suppose to write an application to synchronize a local database with data from a remote database with multiple tables.
I'm thinking of using of using a ASP.NET web service that returns a string of T-SQL INSERT and UPDATE statements as one single string output. This will then be executed at the local end as a batch script to update and insert records. Is this approach the best or is there any other way around it? My other problem is how to generate the INSERT and UPDATE scripts dynamically. How can this be done? Thanks, Jupiter ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
