I need to make a sync between 3 or more SQL Servers. We have 3 Small Business server with sql server 2000. In all the 3 locations, branch and headquarters we've the same databate data.
For sync with 2 there's no problem. I need to make it with three and then at the end of the year with four.
Can anyone help me?
Cheers
João Almeida
I am just beginning development of a new app and I need a little advice onthe best way to go about doing something.The app is a project management tool for a construction company. Users inthe field will need to do remote updates both receiving and submitting databack to the main office. I can't just make it a live web app because theusers will have to be able to work off line and sync data later (presumablywith a VPN connection).What is the best way to go about this? I planned on using MSDE 2000 w/Accessfront end. I will install MSDE on each laptop but what is the safest/mostreliable way to sync only that information which pertains to a specific useralong with other general information.Any books that helpful with this specific issue? Any one have reusablemodules/code they'd be willing to send me?TIA,--Jake
View 1 Replies View RelatedHi all,
I have a module in power builder with Sybase database as its backend. The other modules related to the same application are running on Delphi with SQL server as backend.
My requirement is to sync between the Sybase database and SQL server (2000) in order to update the SQL server with all the transactions ( online ) done in the Sybase database.
Thanks in advance ,
Hari Haran Arulmozhi
Hello,
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?
Please advice at the earliest.
Thanks.
HI ,
I Created one database named login.sdf in sql Ce ,i created one table login having two fields (username and password).it is working well.I trying to synchronise these with SQL2000 using Active sync.it is not working ..And one more things ,i tried to connect the default pocket PC 2002 emulator with Active sync.it is also not working.can anybody give some solution for these problem
Thanks in Advance
Regards
Ihsan
Hi Forum, Ive been unsuccessfully trying to copy data from one table to another, very simple scenerio!
Table1 ID(PK), FirstName, Mobile, Date.
Table2 FirstName, Mobile.
The first question I have is should I fill Table2 at the insert stage OR should/do I update Table2 from Table1 as the users details are entered. ie create some kind of relationship.
Really appreciate good advice! cheers P
I have two db instances on different SQL Servers. One is my test db and the other the prod. db. Each has two tables that hold lookUp values for the entire application. I would like to keep these tables in sync. in both dbs. The prod. db would be the master. I was trying to design a trigger to insert, update, or delete the appropriate records in the test db as they were added or deleted from the prod db.
I'm getting too many prefixes errors on the script when trying to reference the table on the test db using four part naming convention.
Any ideas on how to resolve this issue? Do I need to set up a linked server to accomplish this functionality? If so, how do I setup security for a linked server?
Thanks in advance.
Oscar
I have a SQL 7 backup file that I restored onto a new server. All the objects within the database are not owned by dbo, instead they are owned by a db user. When I tried to login to the db it said that it wasn't a valid user. So I added the login to the system. Now when I login it says it is not a valid db user. I have attempted to sync the id's but don't know how. In 6.5 I could run an ad-hoc query to match the SUID's for the system and the database. In 7.0 I can not because the suid for the db is computed. Any ideas on how to sync the user ID's so that I can login to the server using the target db as my default and can query the table with prefacing the owner(I can get in if I give my login SA privelages but then I have to preface all the objects with the owners name)?
Thanks in advance for any help that you can offer.
hi,
we currently have a web server/db on-site and a similar backup machine across the country. we're using a pretty bad backup strategy. we zip up a backup file, thats done on the main server every night, then ftp over to the back up server then run a restore.
lately ive been having problems with the main server. i would like to have the machines sync'd up as close as possible.
ive searched the threads and noticed replication and log shipping to be the most practical, but im assuming most of the machines are on the same domain.
what would be my best bet for machines connected over the internet, no vpn?
also the db on the main machine get queried/inserts all day from 7am - 6:30pm
thoughts?
thx
I need to syncronize two separate databases. One is SQL Server the other is MySql. I don't have a lot of experience with MSSQL and need a little advice on how best (in terms of speed especially) to gather records that have been added since the last sync and any that have been modified. The table in question has datetime fields for both, the time each record was created (CreatedTime) and the time that the record was last modified (ModifiedTime). Sync will happen daily.
I have worked out a few ways I might do this with DATEADD or DATEDIFF, but my question is, what is the most effecient way? Currently I'm just looking for a way to get inserted and updated records from SQL Server to MySQL. I may have to do a two way sync of some sort later.
how do i write a sync procedure that syncs both tables and ensures that Table_2 keeps all services that are listed in Table_1
how do i write a procedure for the sync between both tables, and put this procedure into the package
so basically there have to be two sync parts: First is INSERT of what is not yet existing, second one is UPDATE on the appropriate attributes.
How would i write this sync procedure?
how do i write a sync procedure that syncs both tables and ensures that Table_2 keeps all services that are listed in Table_1
how do i write a procedure for the sync between both tables, and put this procedure into the package
so basically there have to be two sync parts: First is INSERT of what is not yet existing, second one is UPDATE on the appropriate attributes.
How would i write this sync procedure?
Hi all,
I have three tables and i want to bring all tables into sync.
My problem is that the difference in the amount of records is huge.
CORE -- 85659 This table doesnt have a PK
CRF -- 59895 This table has a composite key (MIN,MAX)
DS -- 58595 This table also has a the same composite key (MIN,MAX)
All the tables have their own UIDs. Additionally CRF has a column which stores the UID of CORE table and DS has a column which stores UID of the CRF table.
CORE --> CRF --> DS
UID --> UID,CORE_UID --> UID,CRF_UID
I have only 3 columns (UID, MIN, MAX) that can be used to sync all the tables. Can anybody help me...?
Thanks in advance....
I want to synchronize two databases. Is there a query or a tool to synchronize them?
View 3 Replies View RelatedHello,I've got 2 databases (both on MS-SQL Sever2k). One of them (remote)contains table which is often updated. For various reasons I'd like tomaintain a copy on local MSSQLServer. Is there any built-in mechanism whichallows to do such things?! I can do this manually, by examining the remotetable contents, and downloading new stuff (local table cannot be modified inany other way), but I guess that there is a smarter way. Any ideas?!ThanksPiotrek
View 1 Replies View RelatedI have tried to set up log shipping for one of our databases - firsttime. Using EM I was able to create the job and maintenance plansucessfully. I wasn't able to find any errors in any logs. In themonitor server, when I look at job history, everything is gettingcopied and loaded sucessfully, yet the STATUS in the log shippingmonitor states it is out of sync.How do I get this into sync? I have set the out of sync threshold to45 minutes. I have made changes in our production database and thosechanges are showing up in the standby database, so it all appears tobe working.Thanks.
View 1 Replies View Related
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??
Thanks
What is the best solution to run a disconnected database on a tablet pc and then sync wirelessly to a SQl Server database?
Thanks
I set up log shipping,
after a while the log shipping pair in LogShip Monitor is out of sync.
what cause this & how to solve this problems.
thx
I have set up a database with log shipping to the backup server. I have actually set it up multiple times because it continues to get out of sync, and I do not know another way to get it back in sync (despite much effort to learn how). I have not found much documentation in BOL, nor in the on-line areas that I can find. I have not been able to discover why it keeps getting out of sync.
If there is anyone who may shed some light on this, I would be very greatful.
Particulars (both servers):
Windows ADV Server 2003
SQL 2000 (Enterprise Ed.)
Servers on a work group (not domain)
There is a separate database on the same servers that continues to have successful log shipping.
Thank you very much (in advance).
what is the work around for Out of Sync error?
What cause this problems ?
thx
I have (finally) successfully gotten through the maze and 'published' my database to a folder:
Physical path: I:SqlReplication
unc: WarrenassocSQLReplication
Since I'm running XP pro, I don't have the options of assigning specific read/write permissions to a folder.
However it appears the problem is with accessing the snapshot and the logon's there.
When I run the IIS Web Configure wizard I error out at the snapshot share permissions step (see report below)
Wizard Settings:
Click Finish to perform the following actions:
Modify a virtual directory immediately.
Copy the ISAPI dll 'sqlcesa30.dll" to 'I:SqlReplication" immediately.
Set NTFS permissions immediately.
The virtual directory 'SqlReplication' will be configured with the following options:
On server 'WARRENASSOC'.
Use 'SqlReplication' as the alias.
Use 'I:SqlReplication' as the physical path for the virtual directory.
Use 'Anonymous' as the authentication method(s).
Do not require secure channel.
Set user permissions to 'Execute'.
Clients can use 'http://WARRENASSOC/SqlReplication/sqlcesa30.dll' as the Internet URL.
'sqlcesa30.dll' will be copied from 'C:Program FilesMicrosoft SQL Server 2005 Mobile Editionserver' to 'I:SqlReplication'.
'WARRENASSOCEd Warren' will get the following NTFS permission:
'Read & Write' on physical path 'I:SqlReplication'.
'Read & Execute' on the ISAPI DLL 'I:SqlReplicationsqlcesa30.dll'.
'Read' on share physical path '\WarrenassocI$SqlReplication'.
'Read' on the share '\WarrenassocI$SqlReplication'.
- Modifying the virtual directory (Rolled back)
- Copying the ISAPI DLL (Rolled back)
- Setting the directory permissions (Rolled back)
- Setting the server agent permissions (Rolled back)
- Setting the snapshot directory permissions (Rolled back)
- Setting the snapshot share permissions (Error)
Messages
The operation completed successfully. (Exception from HRESULT: 0x80070000) (mscorlib)
- Modifying the Virtual Directory configuration file. (Stopped)
When I created the snapshot I used my personal logon (admin rights) at each step
I've tried all combinations of setting the permissions in the wizard from requiring a login and providing my personal login to no requirements and I get the same error.
I'm trying to set up to copy a database from my SQL Server 2005 --> SQl Server CE 31 RC1
to see it it meet my development needs.
I'm at a loss as to how to navigate the security maze!!
Thanks Edward Warren.
Hello everyone:
I wanted to ask a question about log shipping going out of sync. We have a remote server in the UK that is our production server, and we are trying to set up log shipping with another server in the US. Our Log shipping monitor goes "out-of-sync" after about 8-10 hours. We changed the US server to have the same time as the server in the UK, but there still seems to be an out of syn error after 8 hours.
We are using Windows server 2000 and SQL server 2000.
SQL server will restore logs then after a few hours it stops restoring and goes out of sync. Was just wondering if someone knew the possibilities of why.
Thank you.
Hi guys
Is there anyway to sync a sdf database on a device with a mdb database on a desktop
Thanks
I'm using SQL'05, VS'08 SQLCE 3.5 building VB.NET applications.
I'm using LocalDataCache to sync SQLCE and SQL'05
When I write a new record to SQLCE the corresoponding record in SQL'05 shows both LastEditDate and CreationDate values.
When I update the recored in SQLCE the LastEditDate gets updated, but CreationDate gets set to NULL.
Ideas?
David L.
hello all,
I am having an intersting problem using sql replication.
I have a staging database inside my firewall that I am replicating out to my sales force over gprs. The web synchronziation server is in the dmz and the dbin in the firewall.
When I initiate the sync from the mobile devices, I am monitoring the replication monitor. The replication takes about 5-30 seconds to complete on the server but the operation can take up to 15 minutes to complete on the mobile device. The time delay happens over gprs, wi-fi or even activesync'ed so it is not the connection speed. I have tried tweaking settings on my IIS box but to no avail. To make things even more interesting the problem is intermittant. Anyone ever see anything like this?
Is my understanding of the Sync process correct?
I would like to write a Windows Forms applications that communicates to a SQL 2005 database when the client computer is on the server network. The client syncs a CE database with the host version. When the client is not connected to the network, I would like the Forms application to fail over to the CE database.
I have written an application that builds the databases. I can use server explorer to verify that the same data is in both version (CE & 2005). When I do a fill from VB with the computer not connected to the network, I get a connection exception from the Fill statement.
Is there something else that I need to do to fail over to the CE database or am I off base on my understanding of the Sync concept?
Thanks.
Larry
Dear friends
I read about 'NoSync' initialization.I tried out in my system.That time after executing Sp_Scriptpublicationcustomprocs,Stored procedures are propagated to subscriber.Replication was working fine.But afterwards I got some problem.So I reinstall my SQL Server I agin tried 'NoSync' initialization.This time Stored procedure is getting created on Publisher database not in subscriber.Can you tell me what may be the reason
I have two other doubts also
1)Sometimes I am getting error in subscriber.'The process couldn't connect to Distributor'.How to configure distributor in this case?
in configure publishing,distributor wizard I won't able to do anything like that change distributor login or something
2)How to delete Distributor database from a server.once it's get created if wan't also I won't able to delete it
3)If I am using SQL Server 2005 Peer to peer Replication whether it will be reliable for load balancing.My All servers will be in one office only.Or clustering may be better technology for load balancing.if it is like that can you tell me why it is?
Expecting reply
Filson
Hi guys!
I'm facing the following Problem.
My c# .net Application consists of a Desktop Part - and a Mobile Part (Win CE 5.0)
The Desktop uses a Ms Access Database, the Mobile a SQL Server Compact 3.0 Database.
The mobile Database is a kind of "light" version of the desktop
e.g
Desktop DB,...
Table Component
Attribute
Component ID
ComponentName
Quantity
Info1
Info2
Text1
Text2 ...
Mobile Database
Table Component
ComponentID
ComponentName
Quantity
changeflage
So as you see there are less information on the mobile Database.
But anyway, somehow i need to sync these tables...in both directions.
My first idea was to create an OleDB Connection to the Desktop Database, and Fill a OleDbDataadapter with the table Content.
Then run throuh the dataset.tables[0] row by row... and insert or update the Content in *.sdf database.
and vice versa
I also thought about to add an Attribute named "changeflag" to the mobile database, and if i change the Contant of a row i set the changeflag to 1, so i know i have to update this line in the Desktop Database
My question is now, is there a better or easier way to do a synchronisation, without running through a Dataset und inserting or updating the Mobile Database row by row?
with kind regards
Thomas
Is it possible to get the date of last synchronization from the sdf file?
View 1 Replies View Related
I have a very simple application that is desktop and windows mobile. I am just starting work on it so the options are wide open for now. My goal is a simple database that will sync columns on both sides.
The SQL Compact Edition database seems like the perfect database to use for this application.
The only way I currently know of to sync a PDA database to the desktop, however, is to use IIS and SQL server on the desktop side and then use the ADO.NET sync stuff.
I don't want to have to set up IIS and SQL server on my client's computers. It will be a mass market product and that is just inviting a ton of support that I don't want to have to deal with. The application is too simple and cheap for that.
I know I can go the old fasion ActiveSync component route, but that is such a pain. I could also use a 3rd party solution, but again, too expensive for this application.
My question is whether anyone knows of a simple solution.
Is there any way in SQLCE to query a remote database and do updates to it? Could the desktop application get access to the PDA SQLCE database or the other way around?
Any help would be great. I have the experience to write an ActiveSync component myself. That is not the problem. It is just such a pain and it seems like in today's day and age I shouldn't have to.
Our backend database is Oracle 9i, and now I need to write an application for PDA, which is SQL Server Compact Edition powered. Here is my question: Is there any way I can sync data between PDA and backend database? Can Sql server compact edition do this? Any resource?
Thanks in advacne.
I developed a Sql 2005/Sql Mob merge application for a Dell Axim x51. After making the initial connection from PDA to Desktop (Activesync), the first attempt to sync/rep the database generates an HRESULT error. All subsequent attempts work just fine. As a short term fix I put my sync routine in the error handler so it makes the initial and second attempt. Any idea why first attempt fails. SQL 2005 and IIS are on same machine running XP Pro.
View 1 Replies View Related