Can't Merge Replicate To PocketPC
Apr 20, 2006
Hello
I want to merge replicate my mdf to two PocketPCs running Windows Mobile 5.0/SQL Server Mobile and PocketPC 2003 SE/SQL Server CE 2.0. I've got SQL Server 2000 installed on a Windows Server 2003 machine. I've followed this guide: http://www.codeproject.com/database/MergeReplication.asp, but now I don't know how to add SQL Server Mobile/CE to the list of subscribers after creating the publication. I'm really lost. Does anyone know of an easy step by step guide.
Thanks!
Rudi
View 1 Replies
ADVERTISEMENT
Jan 19, 2007
hi all,
Could we configure a merge replication such as replicate the master table and its all related tables (relation deep could be 1.)
We dont want to manually find master table relations and configure replication for the related tables.
please help for that configuration
kinds
View 5 Replies
View Related
Jan 17, 2007
I'm planning a Pocket PC / Windows Mobile application, but I'm a bit confused on which mobile database I should start development with. I've read about SQL CE, SQL Everywhere, and SQL Mobile. Should I be using SQL Server CE 3.1 for my Pocket PC application? The database will be preloaded with data at design time with read-only information, and will be a "private" installation for a single user application.
My main concern is that the solution can be installed on PPC 2002, 2003 and Mobile 2005.
Am I on the right track?
Thanks,
Jordan
View 1 Replies
View Related
Feb 16, 2007
HI,
i have one instalation file of SQL CE 2.0 named setup.exe ,i installed that in my desktop it works well.i could not install the same file inside the pocketPC.Can any one give me some information about how to get the installation file of SQL CE 2.0 and how to install that in real pocketPC.Thanks in advance.
Best Regards
Ihsan
View 1 Replies
View Related
Aug 2, 2006
Hi
I'm developing a pocketpc 2003 application with visual studio 2005. It has a sql server mobile sdf file call datos.sdf.
I need to create a Windows Desktop application and i need to connect it when pocketpc is connected to desktop with activesync.
Any ideas or links with some code samples?
I have installed sql sever everywhere but i don't understand how i can do that connection.
Thanks
View 3 Replies
View Related
Sep 7, 1999
Using SQL 7.0 I'd like to replicate just schema from DB on server A to DB on server B, then be able to replicate data only form DB on server B to DB on server A. I need help!!
Thanks for ANY information you can give me...
~Jepadria
View 2 Replies
View Related
Jul 23, 2005
I have database on SQL Server 2000 set up with a merge publication.This publication is configured with a number of dynamic filters toreduce the amount of data sent to each client. Each client has ananonymous pull subscription. The merge process can be triggered by thewindows sync manager and my application.To improve performance I have created some helper tables to hold themapping between user login and primary keys of selected entities.For the replicated data to be correct the contents of the helper tablesneeds to be up to date.I need to fire off a stored procedure on the publisher beforereplication starts to verify that this data is up to date. I can notsee any documented way of doing this however I have been experimentingwith some unorthodox systems.Firstly has anyone any ideas?I have been considering adding a trigger to some of the tables used bythe Microsoft replication code - yes I know this is very nasty.My problems arise because executing this stored procedure will causesome data to be updated. In updating data we could create a newgeneration in the database. I must therefore run my stored procedurebefore any the Microsoft code makes any generation checks / updates.Anyone done anything similar, Anyone have any better ideas?Any comments would be gratefully received.
View 1 Replies
View Related
Aug 16, 2004
Hi,
I'm using merge replication to maintain a backup copy of my main (publisher)MSDE database. A push subscription periodically (1 per minute) updates the backup DB.
It's intended that if the main db goes down then the backup (subscription) db can be configured as a publisher. This must all be performed via scripting.
The initial configuration of the main publisher and subscription is controlled via scripting, which works fine.
The problems occur when I try to configure the subsciber to become a publisher. A script is executed on the subscriber but fails at the point when it's configuring the publisher detail. The error is something like "unable to configure a publication for a database setup as an anonymous subscription".
I'm guessing that there are subscritpion artifacts added to the database which need to be removed before it can be configured as a new publisher.
Please help,
Jez W
View 1 Replies
View Related
Aug 18, 2000
I am new (very new) to SQL. I 'm trying to set up SQL 7 to replicate a particular table on a daily schedule and then FTP the file out to a remote directory. Sounds easy! I'm sure it is, I just need someone to walk me through the steps.
If anyone can help me out I would really appreciate it.
View 2 Replies
View Related
Jul 9, 2004
Hi my friends,
I'm replicating with SQL Server 2000(updated Service Pack 3) get error:
SQL Server Enterprise Manager could not configure 'BREEZE1' as the Distributor for 'BREEZE1'.
Error 14113: Could not execute "'"C:program filesmicrosoft sql server80 ools\binnosql" -E -l60 -t60 -d"distribution" -b -i"c:MSDESQLBinnMSSQL\installinstdist.sql" -o"c:msdesqlinnmssql\installinstdist.out"'". Check 'instdist.out' in the install directory.
'distribution' is not configured as a distribution database.
Deleting database file 'c:msdesqldatamssqldatadistribution.ldf'.
Deleting database file 'c:msdesqldatamssqldatadistribution.mdf'.
I have a feeling this is failing because I have not C:msdesqlinnmssqlinstall directory at all.
Is there something I'm doing wrong...If the SP3 can affect???
View 1 Replies
View Related
Oct 4, 2007
This code :
declare @filenumber as char
set @filenumber = '65'
declare @filenu2 as char(6)
set @filenu2 = CONVERT(CHAR(6),(replicate('0',(6-len(@filenumber)))+ @filenumber ))
select @filenu2 as x
This should return 000065
but it returns 000006
i have stepped through it the replicate should replicate the 0 4 times
(6 - len of @filenumber) instaed its doing it 5 ??
View 8 Replies
View Related
Jun 6, 2007
Merge replication. We switched a publication over from push to pull and are now initiating everything within an application. We have just encountered a situation where it is now completely impossible to replicate DDL.
When this was a push subscription, we could execute the following and it would fly straight through the engine and hit every subscriber without having to do anything at all:
ALTER TABLE <tablename>
ADD <columnname> <datatype> NULL
Now that it is a pull subscription when I issue an ALTER TABLE and add a nullable column to the end of the table, it does NOT replicate at ALL. We get the following error message:
The schema definition of the destination table 'dbo'.'Player' in the subscription database does not match the schema definition of the source table in the publication database. Reinitialize the subscription without a snapshot after ensuring that the schema definition of the destination table is the same as the source table. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199478)
Get help: http://help/MSSQL_REPL-2147199478
The process was successfully stopped. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199481)
Get help: http://help/MSSQL_REPL-2147199481
It apears that we are now required to either reinitialize every subscriber every time we add a column or we are required to first distribute the DDL change to each subscriber, make sure they all have it, then add it to the publisher before anyone replicates, and then reinit every single one of them without a snapshot. This makes absolutely no sense at all.
The interesting thing is that we can add articles at will and those get applied with absolutely no problems at all to the subscribers without having to do anything other than add the article and generate a new snapshot.
Version 9.00.3042.00
View 8 Replies
View Related
Oct 18, 2006
Hi everyone, I've recently been thrown into a DBA role (I've never done any DBA work except writing a few SQL queries), so please go easy on me if these are stupid questions. My first task is to find the best way to replicate data between two SQL Server production databases. The data is to come from Production DB #1 to Production DB #2 (for access by a different system). The data has to be super-close -- not necessarily real-time, but within a few minutes. So when data is updated in #1, #2 shouldn't be be lagged by more than 45 minutes (5-10 is ideal). There are hundreds of thousands of records.What would be the best way to do this? Are there options in SQL Server 2005 to do "differential" updates from DB1 to DB2? Or is that how "transactional replication" works? If we were to implement a "full recovery model", will this impact any sort of replication? Thanks.
View 2 Replies
View Related
Mar 30, 2001
WE have a production database that we need to sync with about 100
salesman's laptops. These laptops will not always be online and
would need to sync on the fly.
We are thinking of having a separate distribution database to handle
the load and creating either a pull subscription or even just a DTS
package. We would like to have the salesmen just signon and go to an
ASP page and hit an Icon and either the pull subscription or the dts
package would start the sync..
Anyone tried this before and have any other ideas??
Thanks for any help??
SB
View 2 Replies
View Related
Jun 18, 2001
I have set up a simple trans rep from a server in the office to the web. both servers are NT4sp6aSQL 7.0. Tables only.
The publication and distribution db are on the server at the office, and there is a full time connection through the firewall.
The initialization and first replication works perfectly, but after that, there is a message from the snapshot agent that "no subscriptions needed initialization", the logreader says thare are no replicated transactions and the Distribution agent says there are no replicated transactions. What am I missing?
Thanks in advance
View 1 Replies
View Related
Nov 15, 1999
Hi, there
I have a situation here....
I have Production DB and Development DB in the same SQL7.0 box....
I want to update the data and SP from Pro. to Dev at least once a day...
So this is my plan.
1. Back up(Pro.) and restore(Dev.) so I can have the same DB in the same box.
2. Using a Replication (Pulication and Subscription) ro update the data and SP.
3. Because DTS can not update the SP, I use the replication instead of DTS.
I need to update the SP, too..(Front end is ACCESS and backend is SQL7.0 DB)
Is there any other methods or way to make ti happen... Any suggestion can help...
Thanks in advance
Jay
View 2 Replies
View Related
Jul 9, 2004
Can you have a database setup for both replication to server A and log shipping to server B?
Thanks,
Ken Nicholson
View 1 Replies
View Related
Jan 4, 2006
Hi,
I'm new to replication.
I configured Server named TESTER as publisher & distributer. Create new publication for database named TEST ( type : Transactional ), then Create a new push subcriptions for database TESTREPLICATION ( on the same Server : TESTER). Then I open a table in database TEST to input some data but I couldn't see any tables or data in database TESTREPLICATION ( I chose Continuously, not scheduled).
Yet, after the lunch, I could see the tables, no data. I tried to choose Start Synchronizing but not helped.
Please tell me if I configured incorrectly ?
Thanks,
View 7 Replies
View Related
May 27, 2007
Could someone please point me in the direction on where to look for info on how to:
Replicate an MS SQL 6.5 tables on an Oracle 10.2.0 server every 5-10min?
View 4 Replies
View Related
Aug 10, 2001
Hi:
In the publishing server, admin users could change and non-admin user password and also add login and drop login.
How could it happen to not only replicate the application database to subscriber server but also replicate the changes made in master database?
So that the remote subscriber server will have the most current login updates?
thanks
D
View 1 Replies
View Related
Oct 18, 2007
Hi,
When I'm using MS SQL transactional replication and select all the tables to be replicated, some of the tables are marked with the red cross signs and aren't being replicated. How do I include these tables into the MS SQL replication? I tried to build indexes and re-created publications, but it didn't work.
Please help!
Thanks in advance,
-Alla
View 1 Replies
View Related
Dec 3, 2012
Is any tool is available for replicating the Microsoft sql database..
View 1 Replies
View Related
Jan 30, 2007
Hi all, I have done the replication its working good.Now i have created the new table in publisher. but i have created the same table in sub scription too. how can i replcate this new table..?
Thanks
Krishna
View 3 Replies
View Related
Aug 2, 2007
Can changes made to replicated stored procedures (and User-defined Functions) on the Publisher update the Subscriber database?
If I ALTER a SP (or UDF) on Database1 with peer-to-peer Transaction Replication to Database2, will the alter replicate to the Subscriber(s)?
Thomas
ThomBeaux
View 10 Replies
View Related
Oct 2, 2007
how do you design a dev box?
how do you replicate from prod to dev?
Ideas will be appreacited.
do you get a bak file and restore it?
DTS ?
linkservers?
???
=============================
http://www.sqlserverstudy.com
View 19 Replies
View Related
Jul 20, 2005
Hi !Hi !I'm thinking of installing a Microsoft SQL Server 2000 on a database server,to be the db of a webapplication, but the it must be possible for the usersto copy/replicate data from the server db, to a local db on their e.g.laptop to work even if not online. Is there a tool that can handle thisscenario. (it must be possible to update the server db from the laptop whenonline again ).And:What have to be installed on the laptop (apart from my application runningon the replicated data) ?Thanx/Hans
View 2 Replies
View Related
Apr 26, 2006
I have a db and I only really need the table structures and defined functions/procedures from the db. A small sample set would be nice from each table, but not necessary.
What would be the easiest way to accomplish this?
I'm getting the db from a server not connected to the new one so I either need to get the files and reattach or I need to just copy the structure/procedures in.
thx
View 1 Replies
View Related
Feb 21, 2007
Hi,
Trying to build an replication and subscription beteween db in SQL 2000. The db holds our business system (Dynamics NAV, earlier Navision) and several of the tables include $, spaces and even :
We can take some of this away when creating a new db or make scripts for some actions but I wonder if the mirroring in 2005 could handle this?
Thanks,
Mikael
View 3 Replies
View Related
Aug 30, 2007
Hi,
I'm setting up Replication using SQL Server 2000 as a Publisher/Distributor and SQL Server 2005 as subscriber.
The problem I'm facing is when i add a new table in publisher (2K), it is not propagated to Subscriber (2K5).
How do i replicate new tables, or any database object (view, SP,etc) changes to Subscriber (2K5)?
Since I'm novice to Replication, can any one help me?
Thanks in advance.
Bharathi
View 1 Replies
View Related
Sep 1, 2006
I need to know if i can use command REPLICATE in sqlexpress2005
View 1 Replies
View Related
Jan 23, 2008
My environment are Win Vista, Ms sql 2005 express, Ms Sql Server Management studio express. I have a database Mysearchdb.mdf and want to replicate Myseachdb.mdf to another database with exact same features. What is the best way to do it? I don't want to create each tables, functions and store procedures manually. Thanks
View 8 Replies
View Related
Sep 13, 2006
Hi,
I am relatively new to replication. I have a rather dumb question. I have two SQL Server databases, If i make a change in the first database schema, i want it to replicate to the second database. i dont want the data to replicate though. Is this possible?
Thanks,
Raj
View 3 Replies
View Related
Nov 8, 2001
Hi,
How can i replicate data from oracle to sql server 2000?
thanks.
Osmin
View 2 Replies
View Related
