I have more of a general problem that I need some advice on. In the app I am writing, I am pulling data from a backend Sql Server 2k to a PDA using PocketPC2002. (after long hours and lots of blood, sweat and tears my app is working and almost finished.) Tthe problem I and my team is facing is the fact that because I have to create a merge publication to enable data transfere, the tables used are locked up and no one can make any changes to those tables, unless the publication is deleted, changes made and the publication is recreated again.
Does anyone know of any other way of accessing data from a sql server 2000 db other than the merge replication or RDA methods that will not lock up the tables used? Or, is there a way that I am overlooking in using RDA that will not lock the tables in the database.
Any comments or suggestions?
I'm sorry, perhaps I am being thick. If I may, can I try to restate your situation?
You have an App written for PocketPC. You are using the PocketPC version of SQL Server (dunno the actual product name). To enable data to then transfer to your main SQL server (on a network), you use Merge Replication.
The problem is that because it's Merge Replication, to make any schema changes to any of the articles included in the publication, you must delete and re-initialize the replication.
Have I correctly re-stated the problem, or did I miss something?
You're not being thick my friend. Yes the problem as you stated it is correct. Forgive me as I am not a DBA, just an ordinary programmer who is dealing with databases right now. (Though I am learning).
So far the best solution we (I) have come up with is that I have created a Sql Script to delete the publication, then make the changes, and then recreate the publication. But, is this the only(or best) way to make any changes to the schema? The tables(articles) used in the publication are constantly locked up and the only other way I have been able to figure out to make changes is to do it through the properties form of the publication (for each individual article effected).
Is there another way I am missing?