Besides Replication, What Other Alternatives To Sync Data?
Dec 23, 2004
I have 3 SQL databases: A, B and C. A and B are branch databases while C is the central (HQ) database. A & B will be constantly updated while C will updated occasionally and usually will be used for reporting/data browsing. Even though A & B are from different branch, they do have share some data records.
Every day, I will have to sync A & B's new/updated data to C and C to A/B. I know I can use Replication but I can't. You see, A & B are located in our own branch server while C was hosted on a third-party server. The webserver provider for C would not allow me to do any Replication on C.
What other alternatives that I can use to synchronise all 3?
DTS? XML transfer? It looks as if I have no choice but to write my own sync scripts? :((
Anyone has encountered similar situations? Any recommended SQL Tool programs?
Please help. I'm at a loss of what Im going to do.
thanks 4 ur rpl..well i have a simple doubt if u can guide me it will b gr8 help..well i am developing an application of location based services, in which i am going to store my data on SQLserver 2005 and will fetch the data from it when the user logs in to the user's PDA device so that a user can work offline on the data when there is no connection and when he gets the connection he can synchronize the data with SQLserver 2005. so now i m confuse whether i should use the merge replication or ado.net synchronization framework or RDA?what is the difference between merge replication and synchronization and which is better?
I have the merge replication (Push)Â for SQL Server 2008.The right-click option for Start and Stop Synchronizing in subscriptions has been disabled. How can I stop the merge replication and start again ?
This error happened 1 week after I created the merge replication. The merge data cannot sync to subscriber and only solution I can use is drop and re-create the merge replication again but error would be re-occur a week later. The merge replication work fine before and start from middle on May 2015, but it keep happen right now.
I would like to know what alternatives are avaliable to SQL Server Merge Replication. I am also looking for Third Party Tools. Can anyone name a few for me.
I have tried backing up the replication from Primary Server (Publisher) A and copying over to Subscriber B. When I sync. I am missing the data. I don't know what step I am missing or it is bug on SQL 2K SP3.
I don't know what i am doing wrong.
Can anybody give me a step by step detail how to backup the publisher database and copy to a subscriber and sync by saying the schema and data already available. As we have WAN problem all the times, and when I try the full snapshot of 20 gig it was taking more than 24 hrs and also if the connection fails my snapshot also fails
On windows XP there is a Synchronize program in Accessories. When I run our replication scripts on a SQL Server Express on the XP machine and start the Synchronize program there are items there that allow me to replicate as well as set a schedule, etc.
On Windows Vista there is a Sync Center, but replication doesn't show up here.
I've searched high and low on Google and am not coming up with anything useful, which leads me to believe this is something very simple that I'm overlooking...
Does anyone know how to make your replication show up on the Sync Center in vista, or is there another application that I should download?
I am trying to configure merge replication to a SQL CE database using web synchronization.
It works if IIS is on the same box as the SQL Server publisher but when I attempt this using separate boxes I get the following message.
Getting this message Error messages: · The schema script 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLReplDatauncPUBSERVER_TESTGOLFTEST_TESTGOLFTESTPUBFILTER20070601105864TESTTransType_2.sch' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147024893) Get help: http://help/MSSQL_REPL-2147024893 · The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001) Get help: http://help/MSSQL_REPL-2147201001
I have followed every bit of advice I can find in the MSDN forums, ensuring that the distributor is writing to a UNC and that the perms for the process are correct.
The 2 test servers are not in a domain and I wonder if this is the issue but connectivity between the 2 servers does not appear to be an issue as I am using administrative ids for connectivity for this test.
BOL is all over the place regarding this subject and I am linked out (perhaps the info I need is in there but who can find it?)
We are running merge replication. My identity value was out of sync and the inserts stopped working. I Reseeded the identity value to 1500000 and ran "sp_adjustpublisheridentity" which set that to the new range (and table constraint)Â in the MSMerge file and table. I discovered my error and Reseeded the table back to 150000. How to I get the new range to be created when it is LESS than 1500000 in the MsMerge file???? Can I use the sp_restoreidentity....???
On windows XP there is a Synchronize program in Accessories. When I run our replication scripts on a SQL Server Express on the XP machine and start the Synchronize program there are items there that allow me to replicate as well as set a schedule, etc.
On Windows Vista there is a Sync Center, but replication doesn't show up here.
I've searched high and low on Google and am not coming up with anything useful, which leads me to believe this is something very simple that I'm overlooking...
Does anyone know how to make your replication show up on the Sync Center in vista, or is there another application that I should download?
I am using a merge publication set to synchronize schema changes. Why am I getting the following message when I try to sync after having added columns in the publication database using ALTER TABLE statements?
The schema definition of the destination table ... 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.
Also, why doesn't reinitializing the subscription with @upload_first = false not fix the problem?
Replication is failing while applying the snapshot as the stored procs are out of sync ( the objects referenced in the stored procedures are no more exists in the database) . Is there any easy way to identify the out of sync procedures so that I can exclude these stored procedures from the articles list. I am having around 1000 procs and is not possible to test them by executing.
I am trying to setup merge replication using web sync. I keep on getting the message: The Proxy Auto-configuration URL was not found. Yes I have read all the postings telling me to check my internet explorer settings concerning proxy server and auto-detection - I am not using a proxy - auto detection is unchecked.
Does anyone have another clue?
Thanks
Alex
2006-08-16 15:31:09.375 Connecting to Subscriber 'CRAW' 2006-08-16 15:31:09.437 Connecting to Subscriber 'CRAW' 2006-08-16 15:31:09.453 The upload message to be sent to Publisher 'CRAW' is being generated 2006-08-16 15:31:09.453 The merge process is using Exchange ID '20E2BF4F-8812-431F-8BF8-94A44B80C16E' for this web synchronization session. 2006-08-16 15:31:09.500 The Proxy Auto-configuration URL was not found.
We are performing merge replication between SQL Server 2005 and SQL Server Mobile with more than 1100 handheld, and recently replications are terminating with eror code 80040E19. We can only avoid the problem by deleting the related user's partition directory and reruning the related user's dynamic snapshot.
How to check if web merge sync is working between a subscriber and publisher thru HTTPS ? SQL port 1433 at subscriber is blocked so no direct connection to subscriber.
I have two databases data1(Express 2005) and data2( Enterprise 2005). Data1 is a subset of Data2. Now beginning from that state any changes to either database should be reflected on both of them. Now what's my best solution to accomplish this considering one is the subset of other??
SQL Server 2000 SP4 to multiple SQL Server 2005 Mobile Edition on PDAs. My DB on SQL2k is published with a single dynamic row filter using host_name() on my 'parent' table and also join filters from parent to child tables. The row filter uses joins to other tables elsewhere that are not published to evaluate what data is allowed through the filter.
E.g. Published parent table that contains suppliers names, etc. while child table is suppliers' products. The filter queries host_name(s) linked to suppliers in unpublished table elsewhere.
First initial sync with snapshot is correct and as I expected - PDA receives only the data from parent (and thus child tables) that matches the row filter for the host_name provided.
However - in my scenario host_name <--> suppliers may later be updated E.g. more suppliers assigned to a PDA for use or vice versa. But when I merge the mobile DB, the new data is not downloaded? Tried re-running snapshot, etc., no change.
Question: I thought the filters would remain dynamic and be applied on each sync?
I run a 'harmless' update on parent table using TSQL e.g. "update table set 'X' = 'X'" and re-sync. Now the new parent records are downloaded - but the child records are not!
Question: I wonder why if parent records are supplied, why not child records?
If I delete existing DB and sync new, I get the updated snapshot and all is well - until more data added back at server...
Any help would be greatly appreciated. Is it possible (or not) to have dynamic filters run during second or subsequent merge?
I need to keep the data in my development server and production server in sync.....What is the best way to do this?Remember for example development data may have some addition columns in a table which may not exist in production.....Pls let me know how can i achieve this.
I cannot apply backups because i will loose the ongoing development ....
Hi,We are going to be running two SQL Server 2000's from the samephysical server, with Windows Server 2003, and I need to have certaintables between them syncronized. Database A is a backend to a website anddatabase B is going to be used by a different department. Both thedatabases have certain data in common but it isn't stored in the sameformat. I can't just auto sync one with the other, the data (records) hasto be manipulated before updates between them can take place.So, what I need to do is convert certain data when A is updated and tranferthat to B and vice-versa, in real-time. I've looked at Snapshot, thatisn't an option. I imagine some kind of Event Driven API is needed, wheredo i being?TIA
Ok..here is my problem. I have two SQL servers that I need to haveidentical, at least semi-real time data on. One is in a public DMZwith full access to and from the internet, and one is behind acorporate firewall and the box can get out to the internet but cannotbe hit directly from the internet in. The two are on seperatenetworks and cannot be connected via lan. Is there a way for me tohave semi-real time data transfers between the two to keep bothservers identical? I have thought that the server behind the firewallcould initiate an XML session with my dmz sql server and processupdates, but I am unfamiliar with how it would know what has changedon the remote server and how the remote server would know what haschanged on the server behind the corporate firewall. Any good ideas?ThanksDan Hirsch
I'm working on an application that will be running on two or more machines. Each machine is logging data to a local SQL Compact database. I would like to make these two computers sync the data with eachother, but I am unsure what the best method is to transfer data between machines in a table format. I think XML would work well, but there may be something easier, so I thought I'd ask. Do I want to use sockets to do this, or is there another type of connection that would work better?
All PCs will know the IP addresses of their peers. I forsee each PC having a server thread that is listening all the time. Each PC also has a client that checks to see if it can connect to the server on the other side. It then requests certain data, which the server part sends. Does this sound right?
The rest of the app is in Visual Basic 2008 Express.
Iam receiving an error message when trying to complete the subscription. Please find the below given error report that I get from SQL server. Synchronizing Data (100%) (Error) Messages · A call to SQL Server Reconciler failed. Try to resynchronize. HRESULT 0x80004005 (29006)
The schema script '\MAINsnapshotuncMAIN_SQLMOBILE_TEST20060926133385MembershipData_2.sch' could not be propagated to the subscriber. HRESULT 0x800704CF (0)
The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. HRESULT 0x80045017 (0)
hello everyone, i am developing a application using C#and .NEt compact framework. for that i need to sync pda data (in xml format) with the remote database server(SQL) and vice versa. please help me out thanks in advance.
I've stepped into a new environment and have never dealt with multiple data files on user databases only with Temp db.What would be the best way to get all my data files in sync. I have done this on databases that aren't that big in size or off in size by a lot. Here is what I have
I have SQL Server 2000 and 2005 running on the same server. My current system is in SQL Server 2000 and the new system is in SQL Server 2005. My users will be using SQL Server 2000 for the most part, But for the part the processes that have been migrated to 2005, they will be using SQL Server 2005 as well. The database schema is different on both servers eventhough the data will be similar in most respects.
Is there is a way through which any data that is inserted/updated in SQL Server 2000 via content Management System/ manually/ via a batch job, the data is automatically populated in SQL Server 2005 tables or vice versa?
I need some assistence here.I have two servers. One with MS SQL 2000 Standard edition and MSDE(MSdesktop engine).I need to sync my databases nightly, as a backup.Is there a cheap software that will do this? I don't want to justbackup the entire databases files b/c they are large and I'mtransfering them over DSL.I was thinking transaction logging, but I'm not sure. Is there a easyway to do this?I don't know how to accomplish this task.PLEASE HELP.
I have tried the Sync the data from sql server mobile (.SDF) to Sql server 2005 (.mdf).In push command, i am getting the error "Sql Server Everywhere encountered problems when opening the database". string rdaOleDbConnectString = @"Provider=SQLOLEDB.1;User ID=sa;Initial Catalog=master;Data Source=PRASSANAPRASANNA;Password=master"; qlCeRemoteDataAccess rda = null; try { rda = new SqlCeRemoteDataAccess(); rda.LocalConnectionString = "Data Source=D:/DATABASE/test.sdf"; rda.InternetUrl = http://localhost/Dataset/sqlcesa30.dll; rda.Push("company", rdaOleDbConnectString, RdaBatchOption.BatchingOn); MessageBox.Show("Completed");
}
catch (SqlCeException)
{
}
finally
{
rda.Dispose();
}
please guide me any one ours guys to solve this problem .
I have set up a merge replication with 4 subscribers and a publisher on SS05 sp2 on 5 window servers. After running my application on the replication with big data for a while, the data in some of tables of subscriber are out of sync from the publisher. I tried to run sp_resyncmergesubscription to fix the problem according to http://doc.ddart.net/mssql/sql2000/html/replsql/replmon_9pwh.htm. The procedure run successfully. However, the problem is still exist.
Hi,I have an SQL assignment to do and at my school we use SQL *Plus therehowever I don't have Oracle at home, where I would like to do the work ,so Iwas wondering whats the easiest way to get an SQL environment up so I cancode in that then just paste it into SQL *Plus later.I don't really want to install Oracle on my home pc and I was wondering ifthere are other IDE's for SQl that would fit my need for this.I discovered an instant SQL *Plus client that sounded really promising butwhen i unpacked it, it was just a load of dll's so I think it wasn't what Ithought it was.So does anyone know of anything that might be able to help me out here?Any advice much appreciated!Thanks--Ant
