显示标签为“pulling”的博文。显示所有博文
显示标签为“pulling”的博文。显示所有博文

2012年3月6日星期二

Any other way of data transfere?

Hey everyone,
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?

Thanks in advance,
EricI'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?

Regards,

hmscott|||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?

Thanks,
Eric

2012年2月18日星期六

Any help would be welcomed!

I'm using DMO library.
I'm struggling and pulling out my hair trying to find the XXXX.. property
for the Recovery Model (simple, full,
Server.Databases.Item1....
Does anyone here have
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)Seems to be a Property of the DBOption2 object.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Enric" <vtam13@.terra.es.(donotspam)> wrote in message
news:0E4F63B6-E3F5-4CD0-BC2A-9D71F68B3717@.microsoft.com...
> I'm using DMO library.
> I'm struggling and pulling out my hair trying to find the XXXX.. property
> for the Recovery Model (simple, full,
> Server.Databases.Item1....
> Does anyone here have
> --
> Please post DDL, DCL and DML statements as well as any error message in
> order to understand better your request. It''''s hard to provide informati
on
> without seeing the code. location: Alicante (ES)|||jezz, seeing on dmo I have only:
server.databases.item.dboption...
!!
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)
"Tibor Karaszi" wrote:

> Seems to be a Property of the DBOption2 object.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Enric" <vtam13@.terra.es.(donotspam)> wrote in message
> news:0E4F63B6-E3F5-4CD0-BC2A-9D71F68B3717@.microsoft.com...
>|||I'm sorry...I've got it
Dim oss1 As SQLDMO.DBOption2
?oss1.RecoveryModel
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)
"Tibor Karaszi" wrote:

> Seems to be a Property of the DBOption2 object.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Enric" <vtam13@.terra.es.(donotspam)> wrote in message
> news:0E4F63B6-E3F5-4CD0-BC2A-9D71F68B3717@.microsoft.com...
>