Hi, I'm a newbie student out here in the big ole' db world and wondered if anyone had any suggestions with my little problem!
I have a sql server db on a server and lots of cut down versions of this db on a load of pdas. My problem is that I need to retrieve the data from the pdas and integrate into my server db, and the update the structure of the db on both the server and the pdas. However I can't determine when the synchronisation of the 2 dbs will occur for each pda, so at some point a pda will try to synchronise with the db and fall down as its structure won't match. Is there a way around this? Or some built in feature of sql server to manipulate the data to match or something?
Thanks for any help you can offer. I hope this makes sense to you!