I will be building an in-house, Occasionally Connected App (OCA). What technologies would you suggest I employ. Here are my parameters: .NET Shop(3.5sp1) C# for code behind (winform,wpf,silverlight) SQL Server Backend (2005 or possibly 2008 pending approval) Solo Developer Solo SQL Administrator Low Tech end users Low bandwidth to 5 B...
mysql> start slave; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> show warnings; +-------+------+--------------------------+ | Level | Code | Message | +-------+------+--------------------------+ | Note | 1254 | Slave is already running | +-------+------+--------------------------+ 1 row in set (0.00 sec) mys...
One server increment 1, 3, 5. The other server increment 2, 4, 6 ...
I have an in house app that has both a Web Interface and a Desktop Interface(is an OCA using Merge Replication). We are still using SQL 2005 and have many 'Archive' tables set up. These are filled by Triggers on there relating Table. tblPersonArchive for tblPerson, etc. To keep the Replication Sets as small as possible I would like t...
I currently have replication setup on MySQL 4.1 (master, named radius) to MySQL 5.0 (slave, named app1). We got a new server and I installed MySQL 5.1 (named app2). I setup app2 to replicate data from app1. If I manually run any queries on app1 they are replicated perfectly to app2, but any data being replicated on app1 coming from rad...
Hi all. This involves data replication, kind of: We have many sites with SQL Express installed, there is an 'audit' database on each site that has one table in 1st normal form (to make life simple :) Now I need to get this table from each site, and copy the contents (say, with a Date Time Value > 1/1/200 00:00, but this will change o...
Has anyone successfully set up Peer-To-Peer replication (not merge)? We have set it up exactly per BOL documentation. All the inserts to a node are replicated to another node with no problems. However, some updates do not get replicated - we can profile that the MS update proc (the proc that gets created when P2P replication is set up...
I'm having a problem on a master MySQL (5.0, Linux) server: I tried to add a comment to a table row, which translates into an ALTER TABLE command. Now the process is stuck on 'copy to tmp table', copying the 100'000'000+ rows. Disk IO usage is uncomfortably high. Since the master is using replication, I'm unsure if I can kill this proce...
Hi, In my organization, we have a SQL Server 2005 database server (DBServer). Users of an application will normally be connected to DBServer, but, occasionally, would like to disconnect and continue their work on a laptop using SQL Server Compact Edition 3.5 (SQLCE). Due to this, we have been looking into using Merge Replication betwe...
I'd like to write a sql script to do a basic smoke test to check that the replication setup on my server is correct. I think a simple set of CRUD operations against the tables that are supposed to be replicated will achieve what I'm after and I imagine the workflow will look something like this: INSERT a row into a replicated table in...
I'm currently trying to build a High-Availability and load-balanced web application with Sql Server Replication technologies. Automatic fail-over is built into the application logic. Basically, there are two groups of app servers running the same, each with its own Sql instance. They are set to use the other instance in case of failure. ...
How to troubleshoot UDB replication if the subscription set status = -1 a) How to check the log and where is it located ? b) How do I troubleshoot ? ...
All servers running SQL 2005 SQL server (NOLA) replicates to 35 remote locations (StoreXX). Earlier this week, one publication started having problems connecting to 30 of the 35 remote locations, with an error of: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Date 2/4/2010 10:00:01 AM Log Job History (NOLA-Closing_B...
We have two situations: We have a database server that contains tables of job titles. Those job titles need to be accessed by a database on another server. We have established a linked server connection and everything works well. Problems: There can be no foreign key referential integrity because the tables are physically stored on...
I'm in the initial phase of designing an application that will have a backend implemented in C# that will provide data for other platforms using WCF web services hosted on IIS. One of the platforms will the the iPhone. Since it's a personal project, I want to use it to learn MongoDB. I already know that there are community developed dri...
I'm building a system which has the potential to require support for 500+ concurrent users, each making dozens of queries (selects, inserts AND updates) each minute. Based on these requirements and tables with many millions of rows I suspect that there will be the need to use database replication in the future to reduce some of the quer...
When I want to force an update of the subscribers to my merge replication publication, I can go into the Replication Monitor, right click on the subscription, and choose Start Synchronizing. I'd like to be able to script this (using vba/vbscript or a command line). I'd also like users to be able to run the script (what permissions woul...
All servers running SQL 2005 SQL server (NOLA) replicates to 35 remote locations (StoreXX). Earlier this week, one publication started having problems connecting to 30 of the 35 remote locations, with an error of: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Date 2/4/2010 10:00:01 AM Log Job History (NOLA-Closing_Balance-CB Defaults to Stores-...
I've looked the web through and through in the search of answer to my problem but with no result so I reckon that's the ultimate place when anybody can have a clue what the solution might be. Long story short: we have a jsf web application running on JBoss 4.2.0 GA server. We are in the process of replicating the application to several ...
What's a good off-the-shelf tool that can be used to perform replication between mysql and oracle in both directions? We're currently looking at DBMoto which is super, but I was hoping there was something less expensive. The requirements are: Easy to configure and maintain through a GUI. Table-level replication selection, with configu...