Can someone recommend a utility (preferably open-source) to
synchronize changes across servers? I need to bring only data over in
some cases, and only objects in other cases. Any ideas?
Thx!
Hi All,
I will have to setup two windows 2000 servers at separate locations. Each server will host the MS SQL 2000 database. The data on both database will need to be in sync in real time. Is it possible to do? If yes, any suggestions of how do do it?
Thanks
Khen
ISSUE: While synchronizing data between the PDA and MS SQL Server database, using Active Sync connection, the sync process fails at times and displays an empty error message box and occasionally it shows the following exception: Error During Synchronization: A native exception occurred. ExceptionCode:0xc0000005 ExceptionAddress:0x01627b28 Reading: 0x1e000000 OK to terminate CANCEL to debug Moreover the .SDF file on the PDA gets corrupted. The ActiveSync connection drops as soon as the sync process fails. Later when the .SDF file is deleted and restored the synchronization is successful. Note: The replication monitor in the SQL Server indicates that the synchronization was successful even when the above error occurs.
View 3 Replies View RelatedI Create an availibility Group with a primary and a secondary. (For test)
Then run Planed Failover.
Switched to secondary. That's ok.
After that I update some tables on secondary (That now is primary)
I Run Again Planed Failover on server 2.
Switched. OK
But primary database Get (Not synchronizing) Status.
And in primary I don't have that updates.
How to sync these databases and exit from Not synchronizing.
I'm writing a site in ASP.NET 2.0. I have business logic that contains two methods:ModifyUserInDB() // Modifies user data in a SQL 2005 tableandGetUserFromDB() // Gets user data from the SQL 2005 user tableIf the two methods above get executed at the same time by two different users (but on the same record in SQL 2005), how do I prevent the data from being corrupted? Does SQL do this automatically?If I make the methods static, and synchronize them, will it fix the issue? Are static objects the same instance for all users?
View 5 Replies View RelatedHi, I have developed a software which is to run on multiple PCs on a network sharing the same database on an inhouse server. There is another database which has some similar tables that sites on a server where the website is. I need to have the common tables synchronized. How is this possible and what issues will I have in doing this?
Well there be a problem if the synchronization happens when someone is using our software which is making some changes to that table at the same time? Or if someone on the website is entering some information that updates the database?
I am using Visual Studio 2005 with C#. Access Database.
We have a database in an AlwaysOn Availability Group that has gone into a state of Not Synchronizing / Suspect on the secondary.
The reason why this happened is because the secondary ran out of disk space so the log file wasn't able to be written to. The database was set to synchronous mode.
Is the only way to recover from this to do a re-initialization or is there another way to recover?
Hi!
I have some questions about the MSDN article "Step by Step: Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005" (it is msdn2.microsoft.com/en-us/library/Aa454892.aspx).
Everything works good up to Exercise 3: Synchronizing Data Between Any Backend Database and SQL Mobile Database Using a Web Service. It is said that we need a DataService.asmx file to be enetered into "Web reference name". Unfortunately I can't find the HOL302_SQL_Mobile to download and install this file. Where I can find this file?
Can anyone tell me how can I do such a replication(C#)?
How can I synchronise data from mobile device to SQL Server using GPRS connection? (I only know replicating over USB).
Hi,
I have a problem that I have never considered before. I am developing with C#.Net, Visual Studio.Net ans SQL Server on Windows Server 2003.
Recently we have been upgrading our servers and have installed 2 servers (Live and Dev). The live server is Win Server 2003 Standard while the Dev server is 2003 enterprise.
Both servers are running their own versions of SQL Servers (both 2002). What I need to know, is there a way to copy or 'sync' the dev database to the live without over-writing the live data. I need to be able to copy the dev db structure (the tables anf fields) but not over-write the live data with the dev data (the live data changes rapidly and none can be lost). These 'syncs' would happen 2-3 times a month so the 2 db's, at the time of sync, will look very different so a simple copy of the live data to the dev db is not possible.
Does SQL Server have a wizard or utility? I have not been able to find one.
Thanks,
Justin
Hi,Is it possible to make changes to an Access 2000 database on my desktop, andhave it update those changes to SQL Server 2000 on the web?I have to update stock and prices every night. Right now I am using Access2000, and I just make the changes, and then upload the changed db to theserver, and overwrite the old db.But I am going to be using SQL Server 2000 soon, and I know you don't justoverwrite the db each time.There are about 6 fields that *might* change each night, per record.Is it called replication? How (basically) do I go about it? Are thereprograms out there that will make it easier?Thanks for any advice!J~
View 2 Replies View Related
Hi,
I have a potential client who wants to run three web sites at different locations, each storing data to SQL Server (let's say it will be SQL Server 2005, for the sake of argument). Periodically, but at least once a day, they would like all changes to be made in any server to be reflected in the other two.
As a develeoper, my initial approach would be to write web services that can transmit and recieve changes. Triggers on the database tables would copy data into "shadow" tables and then the web services would periodically wake up and send their changes to the other two servers.
However, before I go down this route, I wondered if any of the standard SQL Server tools (like SSIS) would handle this scenario (maybe with an agent FTPing files between the servers)?
Alternatively, does anyone know of any off-the-shelf partner solutions that can acheive the same result?
Many Thanks,
Chris Boothroyd
Hello,Being a bit of a SQL Server novice, need some advice with the followingsituation.Server A and Server B have SQLServer 2000 based databases. The vendorof the application/system has implemented their own replication processto ensure the 2 databases are in sync. However, there is no clusteringwith virtual IP addresses implemented. So to an external client/db, itis 2 identical databases with the same name on 2 distinct servers.We need to develop an application that will reside on a networkedserver C and with SQLServer 2000 as well. While most of the tables inthis database are self contained, around 10 tables will have to bemirror copies of the same tables from either Server A or Server B.Question, how do we implement subscription based replication on top ofa redundant database, when no clustering is implemented? So, inessence, when Server A is alive, the database on Server C willperiodically (or on change) replicate the 10 tables from Server A. WhenServer A is not alive, it needs to do same from server B. (When bothserver A and B are alive, it is acceptable to get data from either,since they are synchronized internally).Any alternate suggestions on achieving this functionality are welcometoo. If SQL Server 2005 has some capabilities that may address thisproblem, that is a consideration as well.Thanks
View 1 Replies View Relatedhi,
Problem: Synchronize the data between sqlce in pocket pc emulator and sql server 2000 in desktop computer.
Given: i have configured the IIS and while connecting the pocket pc IE to sql ce server agent..evreythings ok.
called the synchronize method.
ERROR: normally two error occurs:
native error 29045
and native error 29006
connecting with sql server reconciler failed..
any bidy can tell me what is sql server reconciler and why these error occurs...
moreover: if someone can tell me how the sql server 2000 interacts with IIS.
Is it possible to use SSIS to synchronize the data between a Foxpro .dbf and a compatible SQL Server table on a near realtime basis?
I have succesfully created an SSIS package that will insert data into the SQL Server Table but this is only useful for migrating data. What I need is a way to insure that the data in the SQL Server table matches that in the .dbf on a near realtime basis.
Or is there a way to link from SQL Server to the .dbf (similar to an Oracle DBLink).
Thanks for any and all assistance.....
Dave
how best to approach a problem involving two tables across two different servers.
Table 1: Contains IP Address along with assessment findings. Lets say the fields are IPADDRESSSTR, FINDING
Table 2: Contains Subnet information stored in integer format. The fields are SITE_ID, LOW, and HIGH
What I'd like to do is load the IP range information into memory and then return the findings from table 1 where the IPADDRESSSTR is between the LOW and HIGH integer value.
1) Is there a way to load all of the ranges from table 2 into an array and then compare all the IP addresses (IPADDRESSSTR) from table 1?
2) How do I convert IPADDRESSSTR (a string) to an integer to perform the comparison.
We have a Customized share point application with Very minimal data usage and we have used only 5 to 6 lists and libraries only in the share point.
Configuration is
Clients -- fire wall --- Load Balancer ---- WF1 and WF2 --- SQL DB
ROUTING IS VIA FIRE WALL.
SUDDENLY THE SITE GOT DEAD SLOW AND UNABLE TO TRACE THE PROBLEM AS EVERY THING LOOKS FINE.
Checked with the firewall Team and they stated its fine from their end & even we have verified the counters, CPU, Memory & Page life expectancy, buffer counters all looks good and even we do not have huge data in the database. We have only 50 concurrent users are working...
Hi,I have 2 tables (let's call them tableOld and tableNew) that I'm trying to synchronize. The tables may or may not be on the same server (I'm not sure - let's assume they're on different servers).Given below is the table structures:******************************************************************************* tableOld ------------- tableOld uses a View to access name information.View name = vwUserDetailsColumns in View = Firstname, Lastname, Fullname tableNew--------------- ProjectManagerID (PK, int, not null) <-- autogeneratedFName (varchar(50), null)LName (varchar(50), null)Inactive (int, null) *********************************************************************** Basically, I'm trying to write a script so that when a user runs the script that will do something like this: 1) it will add all the names in tableOld to tableNew (only if they don't already exist in tableNew)2) if there is a name in tableNew that does not exist in tableOld (because the name was deleted from tableOld), tableNew will set Inactive = 1 for that name. Any help is appreciated. Thanks.P.S. Is there a way the script can run automatically any time a user adds or deletes a name from tableOld?
View 10 Replies View Relatedwhat's the best way to synchronize to mssql databases
(one is 2005 express and one 2005)
what's the best way to synchronize 2 databases(mssql 2005) on 2 different servers.
View 3 Replies View Related
Hi
I am trying to synchronize two tables on different servers, the one with me with the one is australia.
I have a table called MeriesHBMem on both databases and the one with me gets updated everyday, and then i have to use a program called SQL Delta to synchronize all the new rows. How can i go about doing this using SSIS?
Any help would be greatly appreciated! I though about using a trigger for this, but i don't know how to go about connecting the two servers in the trigger's SQL statement, and besides i also think that a trigger will be a huge performance issue.
Data gets inserted into the table, all i want is a SSIS package to execute every 30min or so and take the new data and insert it into the other database's table
Kind Regards
Carel Greaves
Hi
I have two servers, on one i have SQL Server 2000 ( root ) and on the second SQL Server 2005. I need synchronize some data ( not the whole database ) on 2005 but i can't use Analysis Services . What i can do in this situation ?
Dest wishes
Scenario regarding SQL 2000.
I have the same table on 2 different servers, Server R and Server L.
This table schema is:
ID int not null
Name varchar(50) not null
Password varchar(50) not null
IsUpdate int not null default (0)
People has an application that enables them to change their passwords in the table on Server L.
There is a for update trigger in the table on server L that sets IsUpdate column to 1 when any password has been modified.
The required scenario:
- Synchronizing passwords in the table on server R with passwords in the table on server L.
- Then setting the IsUpdate column in the table on server L to 0 again.
What is the best technology for that?
Please send me a code proposal.
Many Thanks and Best Regards,
Bishoy
I have a SQL Server 2005 web database and a local SQL Server 2005 database. I want a tool that can synchronize both the database from the source (web) to the target (local).
View 3 Replies View Related coycoy wrote:you wanted to join some columns coming from two different tables...right? if that so, use an SQL query. Try using the "inner join" statement.
i wanted to combine the data from two tables. these two tables belong to different servers: table1 is from sql server found in cerebrum station and table2 is from mysql server found in copernicus station. i have this code but the problem is i can only use this code if the two tables belong in the same database server.
</P>
<P>string limitReghrsvalue = "select statuslog.ActId as STATUS_ID,DalsDataNew.ID as MANHOUR_ID,statuslog.ActDate as DATE,statuslog.PrjCode as PROJECT_CODE,statuslog.MapNumber as MAP_NUMBER,statuslog.Activity_Code as ACTIVITY_CODE,DalsDataNew.ActivityMedium as MEDIUM_CODE,statuslog.RegHrs AS REGHOURS,statuslog.OTHrs AS OTHOURS,statuslog.Status AS STATUS,DalsDataNew.Flag,DalsDataNew.Approvedby from statuslog,DalsDataNew where statuslog.PrjCode = DalsDataNew.ProjectCode and statuslog.PIN = DalsDataNew.PIN and statuslog.ActDate = DalsDataNew.Date and statuslog.Activity_Code = DalsDataNew.ActivityCode and statuslog.RegHrs = DalsDataNew.RegHours and statuslog.OTHrs = DalsDataNew.OTHours and statuslog.PIN = 'P120' and statuslog.ActDate >= '"+this.firstdate.Text+"' and statuslog.ActDate <= '"+this.lastdate.Text+"'";</P>
<P>
Sql Server in Cerebrum: database dals
DalsData
ID | Date | PIN | ProjectCode | ActivityCode | ActivityMedium | RegHrs | OTHrs | Approvedby | Flag
123 |9/17/2005| P120| 1234 | B | W(P) | 5.50 | 0.00 | P083 | 1
124 |9/17/2005| P120| 1234 | I | W(PC) | 1.50 | 2.25 | |
MySqlServer in Copernicus: database stat
Statuslog
ActID | ActDate | PIN | ProjectCode | MapNumber | ActivityCode | RegHrs | OTHrs | Status(%)
1 | 2005-9-17 | P120 | 1234 | map01 | B | 5.50 | 0.00 | 100
2 | 2005-9-17 | P120 | 1234 | map01 | I | 1.50 | 2.25 | 75
the output in datagrid should be:
ID | ActID | Date | ProjectCode | ActivityCode | MediumCode | MapNumber | RegHrs | OTHrs | Status | Approvedby | Flag
123| 1 |9/17/2005| 1234 | B | W(P) | map01 | 5.50 | 0.00 | 100 | P083 | 1
124| 2 |9/17/2005| 1234 | I | W(PC) | map01 | 1.50 | 2.25 | 75 | | could someone help me how would i do this?
Dear All,
I am trying to create a trigger on table A existing in Database A on Server A which on insert,update,delete would reflect these changes on table B in DatabaseB on Server B. I wrote the following syntax but it doesnt work
CREATE trigger trg_upd_tableA
On dbo.tableA
for UPDATE
as
--update the fields
declare @cust_no varchar
SELECT @cust_no = cust_no FROM inserted
update ServerB.DatabaseB.dbo.tableB
set
entity_type_cd = 'MFG',
cust_no = 6699,
name_en = 'NOVARTIS',
status ='A',
create_date=getdate()
,modify_date=getdate()
where cust_no= @cust_no
I get the error below
Another user has modified the contents of this table or view ; the database row you are modifying no longer exists in the database
Database Error: '[Microsoft][ODBC SQL Server Driver][SQL Server] MSDTC on server 'DatabaseB' is unavailable'
I would like anyone to reply to me as soon as possible please because i need the solution urgently
Thanks alot in advance,
Noha
How to backup database on the other servers in the LANS.
View 8 Replies View RelatedI am attempting to move a User Database from the Production Server to a Training Server. What is the best/most simplistic way for me to accomplish this task and place this copying action on a schedule of say "every saturday morning @ 7am"
I tried the "Copy Database Wizard" within Enterprise Manager and it successfully copies the database, however when I try to schedule it to happen at a different time...it does not copy the database. It seems to only work when I tell it to perform this action now.
Please help.
Thanks,
JC
Hello All,
I need some help with a web application we are running. Is it possible to have 2 seperate instances of SQL 2005 running and each one pointing to the same DB. We want to load balance our users on the different DB servers. They are performing read and write transactions.
Any suggestions.
Hi,
I've got two servers with sql 2005 express on, the first is a shared server at our isp, we rent one database from them. The other server is our own and we have full sa access.
Is there an easy way to copy the database from the shared server onto our own server. We're unable to use the backup.
Thanks
Hi,
I read the following article related to "Federated Database Servers" But i am not getting what is this "Federated Database Servers", May be the language of this article i think little bit difficult. So, can anyone please explain me this.
Wht are thse servers and when, why and where we use these servers?????
http://msdn2.microsoft.com/en-us/library/aa213244(SQL.80).aspx
Thanks,
hello friends,
I need to transfer my database from one server to database on another server every 24 hours. I can create windows application but it will be cumbersome to write bulk of code . So can u suggest me some service or any other way through query or stored procedure by job scheduling which can run every 24 hours and move my data from one database on one server to another sql database. Both databases are sql server 2000 but servers are diffeerent so how to connect them while transferring dbs. ? plz help me , its urgent.
regards,
max
Hi,
Currently developping a c# database based application, which will be used in different establishments worldwide. I'm currently a bit confused by the ms sql features offered. Because the huge data amount which will be fetched during application use from the database, the best option is probably to put a ms sql server in each establishment to realise quick data fething. Problem is that the servers, which are all running on the same database design have to be synchronised real-time. I read about datareplication with the merge option which I thought was a nice solution. The subscribers can only have read-only rights on these subscriber databases, because the merging doesn't work appropriate i heard, so this is no good solution. Then I read about distributing transaction coordination. Seems a good solution as well, but what happens if a server system crashes for one day and then comes back online? It won't be up to date anymore... Right now I think about a combination of these 2 features. DTC in combination with merge replication, but there must be a better solution. Fact is that a lot of users will be editing data worldwide non stop, and everyone has to be up to date. Because of huge data fetching I don't think it's a good solution to let everyone work worldwide with one single database. Is there a possibility to realise this with ms sql server? Because I'm getting more and more confused... Thx in advance.
I'm writing a VB6 app which calls several stored procedures on my SQLServer DB.The first stored procedure must complete its inserts before the secondstored procedure can query the modified table for its results. Myproblem is thatthe second stored procedure occasionally returns a different resultset, acting as if the first stored procedure didn't complete (ordidn't run).So how do I ensure (or test/poll?) that the first stored procedureruns to completion before returning control back to my VB app?Thanks in advance,Ralph
View 9 Replies View Related