|
Home > Archive > MS SQLCE > March 2006 > how to sync sql server CE x sql server 2000?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
how to sync sql server CE x sql server 2000?
|
|
| bruceshark 2006-03-06, 7:23 am |
| hi.. sorry if i'm using broken english..
i'm developing application using PDA with sql server ce.. my problem is.. how
can i sync data from sql server 2000 x sql server ce or vice versa? is anyone
can tell me what to do? what step or any idea? thank you..
| |
| Lonifasiko 2006-03-06, 7:17 pm |
| I think you nowadays have got three possibilities to do
synchronization:
1.- RDA
2.- Merge Replication
3. Web services
Take also a look at these articles:
http://msdn2.microsoft.com/en-us/library/ms172916.aspx
http://www.devx.com/Intel/Article/17264/0/page/1
And don't forget to dive into MSDN2. There are plenty of articles
talking about synchronizing data between clients and server. Well, the
Microsoft's article is related to SQL Mobile 2005 and SQL Server 2005,
but I think I've also read it for SQL Server 2000 and SQL Server CE 2.0
somewhere in MSDN.
I particularly use Merge Rplication but id depends on you scenario.
Regards.
| |
| bruceshark via SQLMonster.com 2006-03-07, 3:23 am |
| hello Lonifasiko,
thanks 4 u'r reply..
if I want to use merge replication, can u instruct me how to do that or do u
have any example that i can learn? i've already read n try exercise at
microsoft but i have error subscribing to database.
Lonifasiko wrote:
>I think you nowadays have got three possibilities to do
>synchronization:
>
>1.- RDA
>
>2.- Merge Replication
>
>3. Web services
>
>Take also a look at these articles:
>
>http://msdn2.microsoft.com/en-us/library/ms172916.aspx
>
>http://www.devx.com/Intel/Article/17264/0/page/1
>
>And don't forget to dive into MSDN2. There are plenty of articles
>talking about synchronizing data between clients and server. Well, the
>Microsoft's article is related to SQL Mobile 2005 and SQL Server 2005,
>but I think I've also read it for SQL Server 2000 and SQL Server CE 2.0
>somewhere in MSDN.
>
>I particularly use Merge Rplication but id depends on you scenario.
>
>Regards.
--
Message posted via http://www.webservertalk.com
| |
|
|
|
|
| Lonifasiko 2006-03-08, 3:23 am |
| Have you correctly configured IIS, IUSR_Login and permissions for
snapshot folder?
Are you running latest service pack for Windows 2000 and also latest
version of SQL Server CE 2.0 Server Tools?
Make sure you fit these conditions first.
Try if you can access from PPC Explorer to the DLL published in the IIS
of your computer:
http://PC-name/PublicatedDirectory/sqlcesa20.dll
If you are not able to view SQL Server CE Agent 2.0 text, you've got
permissions problems. Else........don't know.
Make also sure your firewall is not blocking calls to SQL Server. I
deactivated Windows Firewall because I experienced same problem.
You are running SQL Server 2000 and SQL Server CE 2.0 version, aren't
you? I remember having to enable IP1 and IP2 parameters for TCP/IP
protocol on the configuration of SQL Server. Check Books on Line for
more concrete information because I know how to do it with SQL Server
2005 (SQL Server Configuration Manager), but not for SQL Server 2000.
And also check this article out:
http://www.sqljunkies.com/How%20To/...485DFA439B.scuk
Good luck!
| |
| bruceshark via SQLMonster.com 2006-03-08, 7:23 am |
| install IIS at add remove program right?
i've follow all step at the exercise for Installing SQL Server CE on an IIS
System
i'm using windows XP. i'm running server tools 3..
i've already off my firewall..
i've try access but it give "The page cannot displayed"
Lonifasiko wrote:
>Have you correctly configured IIS, IUSR_Login and permissions for
>snapshot folder?
>
>Are you running latest service pack for Windows 2000 and also latest
>version of SQL Server CE 2.0 Server Tools?
>
>Make sure you fit these conditions first.
>
>Try if you can access from PPC Explorer to the DLL published in the IIS
>of your computer:
>
>http://PC-name/PublicatedDirectory/sqlcesa20.dll
>
>If you are not able to view SQL Server CE Agent 2.0 text, you've got
>permissions problems. Else........don't know.
>
>Make also sure your firewall is not blocking calls to SQL Server. I
>deactivated Windows Firewall because I experienced same problem.
>
>You are running SQL Server 2000 and SQL Server CE 2.0 version, aren't
>you? I remember having to enable IP1 and IP2 parameters for TCP/IP
>protocol on the configuration of SQL Server. Check Books on Line for
>more concrete information because I know how to do it with SQL Server
>2005 (SQL Server Configuration Manager), but not for SQL Server 2000.
>
>And also check this article out:
>
>http://www.sqljunkies.com/How%20To/...485DFA439B.scuk
>
>Good luck!
--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...ver-ce/200603/1
| |
| Lonifasiko 2006-03-10, 7:25 am |
| Sorry for answering so late, but I really don't know what problem you
are having. Seems like permissions problem, maybe IIS or that you have
to enable TCP/IP protocol in SQL Server. Have you tried enabling TCP/IP
protocol in SQL Server? It is disabled by default, so in my case, SQL
Server Developer Edition, it's necessary to enable it. The problem is
that I don't remember where to enable that parameter.
You've tried accessing from the browser of the PPC. Have you tried from
the browser of your PC. If you still cannot see the message I told you,
bad news guy.
Keep me informed, but as you see, I don't really know what is happening
with your replication.
Regards.
| |
| bruceshark via SQLMonster.com 2006-03-14, 3:23 am |
| :-) hmm..
when install SQL server 2K, at Service Account, i select local acccount..
but at the exercise ask to select use domain user account. Is that okie?
then when i want to create new publication, at Select Distributor, it give
this error "SQL Server Agent on 'MAIZATULAKMAL' currently uses system account,
which causes replication between servers to fail. In the following dialog box,
specify another account for the Service Startup Account" then.. at SQL Server
Agent properties.. what I must do?
Lonifasiko wrote:
>Sorry for answering so late, but I really don't know what problem you
>are having. Seems like permissions problem, maybe IIS or that you have
>to enable TCP/IP protocol in SQL Server. Have you tried enabling TCP/IP
>protocol in SQL Server? It is disabled by default, so in my case, SQL
>Server Developer Edition, it's necessary to enable it. The problem is
>that I don't remember where to enable that parameter.
>
>You've tried accessing from the browser of the PPC. Have you tried from
>the browser of your PC. If you still cannot see the message I told you,
>bad news guy.
>
>Keep me informed, but as you see, I don't really know what is happening
>with your replication.
>
>Regards.
--
Message posted via http://www.webservertalk.com
| |
| bruceshark via SQLMonster.com 2006-03-16, 7:29 am |
| okie.. my setup installation for SQL Server 2K was successfully.. :D
I can't do at my PC.. my IIS got problem..
I've done it to another computer.. but I've got another error.. :((
"Initializing SQL Server Reconciler has failed"
why?????
bruceshark wrote:[color=darkred
]
>:-) hmm..
>when install SQL server 2K, at Service Account, i select local acccount..
>but at the exercise ask to select use domain user account. Is that okie?
>
>then when i want to create new publication, at Select Distributor, it give
>this error "SQL Server Agent on 'MAIZATULAKMAL' currently uses system account,
>which causes replication between servers to fail. In the following dialog box,
>specify another account for the Service Startup Account" then.. at SQL Server
>Agent properties.. what I must do?
>
>[quoted text clipped - 11 lines]
--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...ver-ce/200603/1
| |
| Lonifasiko 2006-03-16, 7:29 am |
| Congratulations! You've almost have it!
That's the typical error thrown by SQL Server when using merge
replication.
Once you have created correctly the publication, you have to run the
Merge Agent: You have to select "View snapshot agent status" and then
click "Start".
After the agent has been run (100% should be shown), you have to enter
publication's properties and add IUSR_XXX user to the publication
access list and select that publication will never expire. Then
publication should be ready to use.
I understand now you can access the DLL via your web browser, both from
the PC and the PPC.
As for the accounts, I nowadays use SQL Server Agent account. It is not
a good security practice but works. I had problems in the past when
using local accounts so I finally switched to using SQL Server Agent
account.
If you still have problems, send me the code you're using to replicate
and see after the error is thrown, if the database has been created in
the specified folder of your PPC.
Good luck! The solution is near ;-)
| |
| bruceshark via SQLMonster.com 2006-03-17, 3:25 am |
| ;-) TQ.. u give me spirit to try n try n try until success!!!..
>Once you have created correctly the publication, you have to run the
>Merge Agent: You have to select "View snapshot agent status" and then
>click "Start".
n then I've got this error also.. "Publication NorthwindProducts does not
exist"
I look at SQL Server again.. I already have NorthwindProducts at
Replication>Publication
TQ..
Lonifasiko wrote:[color=darkred
]
>Congratulations! You've almost have it!
>
>That's the typical error thrown by SQL Server when using merge
>replication.
>
>Once you have created correctly the publication, you have to run the
>Merge Agent: You have to select "View snapshot agent status" and then
>click "Start".
>After the agent has been run (100% should be shown), you have to enter
>publication's properties and add IUSR_XXX user to the publication
>access list and select that publication will never expire. Then
>publication should be ready to use.
>
>I understand now you can access the DLL via your web browser, both from
>the PC and the PPC.
>
>As for the accounts, I nowadays use SQL Server Agent account. It is not
>a good security practice but works. I had problems in the past when
>using local accounts so I finally switched to using SQL Server Agent
>account.
>
>If you still have problems, send me the code you're using to replicate
>and see after the error is thrown, if the database has been created in
>the specified folder of your PPC.
>
>Good luck! The solution is near ;-)
--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...ver-ce/200603/1
| |
| Lonifasiko 2006-03-21, 3:30 am |
| Really glad to have helped you keeping that spirit ;-)
Happy replication!
| |
| bruceshark via SQLMonster.com 2006-03-23, 3:30 am |
| hi Lonifasiko..
Thankss a lot helping me.. Now I'be done my merge replication successfully..
Thank GOD..(Alhamdulillah).. Thanks again.. Nice n i'm glad knowing u..
Lonifasiko wrote:
>Really glad to have helped you keeping that spirit ;-)
>
>Happy replication!
--
Message posted via http://www.webservertalk.com
| |
| bruceshark via SQLMonster.com 2006-03-23, 3:30 am |
| another question.. hehehe
do u have any link that I can follow how to deploy my application? i'm using
VBNet 2003, compact framework 1.0 SP3 and windows mobile 2003
TQ
bruceshark wrote:[color=darkred
]
>hi Lonifasiko..
>
>Thankss a lot helping me.. Now I'be done my merge replication successfully..
>Thank GOD..(Alhamdulillah).. Thanks again.. Nice n i'm glad knowing u..
>
--
Message posted via http://www.webservertalk.com
| |
|
|
|
|
|
|
|