We have 2 SQL Express (2005) servers. As you probably know, database mirroring is not enabled in the Express editions, but replication is. Would it be possible to enable replication between both servers to have some kind of mirroring-like functionality?! What would be the possible drawbacks if it is possible at all? ...
Question: How can we connect a SQL Server CE DB to a SQL Server Express DB? We can't use Merge replication because you can only be a Subscriber in SQL Server Express, not a Publisher. More background information: We have an application structured as follows: 1) Our headquarters, running SQL Server 2008 2) Branches, running SQL Server ...
Hi all! I'm looking for some help/suggestions for backing up two large databases to one server dedicated to reports. The situation is; My company has two databases for its internal website. One for the UK and one for Europe. Both are mirrored for DR. I have a server based in Europe which is dedicated to Microsoft Reporting Services, w...
I am developing an application with Microsoft Sync Services. The server will be running SQL Server Express and there will be multiple clients running SQL Server CE. I'm using SQL Server change tracking. Data to download is set to "New and incremental changes after first synchronization". I have a small demo application that lets me d...
I want to replicate data from a boat offshore to an onshore site. The connection is some times via a sattelite link and can be slow and have a high latency. Latency in our application is important, the people on-shore should have the data as soon as possible. There is one table being replicated, consisting of an id, datetime and some...
Hi All, We are using SQL Sever 2005 replication for out application. Every thing is working fine without any problems. However, recently we ran into a situation to which I have no solution. We use merge replication with the publisher(sql server 2005) in one geography and the subscribers(sql server 2005 express) in multiple other geogra...
I have a bit of an architecture problem here. Say I have two tables, Teacher and Student, both of them on separate servers. Since this tables share a lot of data and functionality, I would like to use this inheritance scheme and create a People table; however, I would need tho keep the Teacher table and the People records relating Teache...
I have a SQL Server 2005 Database which uses merge replication. I have added four new stored procedures on the publisher end, but they haven't replicated. The publication property "Subscription Options" - "Replicate schema changes" is set to True. How can I get easily get these tables replicated without having to send new snapshots to...
What is the difference between Replication and Mirroring in SQL server 2005? ...
Hi, I am trying to insert value for the column of datatype image in sql server. I am getting the following error {"Length of LOB data (70823) to be replicated exceeds configured maximum 65536. The statement has been terminated."} . The data length is less than 2 MB. What is the problem? Thanks, P.Gopalakrishnan. ...
We have an infrastructure set up where in the webservers are clustered and the application servers are not. The webservers route the request to the application servers based on round-robin policy. In this scenario, the session data available in one application server is not available in the other application server. Is there anyway by w...
Let me preface this by saying I now realize how stupid I am and was. I have been developing for 1 year (to the day) and this was the first thing I wrote. I now have come back to it and I can't make heads or tails of it. It worked at one point on a very simple app but that was a while ago. Specifically I am having problems with Local...
Hello, I have a problem defining the best way to replicate and synchronize some information that I have in different mysql servers. Let me explain: Actual Scenario: Server A -Table A1 (read/write) Operations -Table A2 (read/write) Operations Server B -Table B1 (write) Operations Desired Scenario: Server A -Table A1 (read/write) Op...
I have Merge Replication set up and I just noticed that a Aggregate Function is not available on my Subscriber. After further investigation I discovered that is is not even available in the Publication as an option. There are other Functions listed there but not that one. Ideas? Is there something written that doesn't allow Aggregate...
I have an application that currently uses SQL Compact Edition as its database for capturing realtime data. Some of my users would like to write their own applications to query and report against this data while it's being captured by my application. However, SQL Compact edition runs in-process with my application and therefore does not...
Is there any way to get a fault tolerant MySQL replication? I am in an environment that has many networking issues. It appears that replication gets an error and just stops. I need it to continue to work and recover from these faults. There is some wrapper software that checks the state of replication and restarts it in the case of losin...
Is it recommended to add the slave-skip-errors = 1062 option into the my.cnf file? I want to keep my data consistent. Thanks for your opinions. ...
We are in the process of a multi-year project where we're building a new system and a new database to eventually replace the old system and database. The users are using the new and old systems as we're changing them. The problem we keep running into is when an object in one system is dependent on an object in the other system. We've b...
I have added a bounty to this as I have, as yet been able to figure this out and time is out. The below stored procedure will not allow me to add it to Modify it. When attempting to modify it I get the following error --> Msg 213, Level 16, State 1, Procedure spPersonRelationshipAddOpposing, Line 51 Insert Error: Column name or n...
I have a Master File table on a server(A). Data is first replicated to a central server(B) and then to all of our locations(C). Then from C->B->A A = Sql 2005 B = SQL 2005 C = Sql 2000 My issue is that data gets all the way to C but replication is set for updates yet I get a Primary Constraint error from C -> B. I set loopback detect...