SQL Server - Access Synchronization

Aug 19, 2005

I have a VB app which stores information in an Access 2000 db. The VB app
handles multiple users (it's a logbook type of application, users share
lookup tables but don't share information among themselves - IOW, I couldn't
see your log entries and you couldn't see mine).

We're adding a web interface to the package - basically a scaled down data
entry interface to allow users to add log entries without being at their
workstations. The web version will be storing data in a SQL Server 2000 db.

I need to be able to synchronize data between the two - if a users
edits/adds a log entry in the desktop version, they need to be able to
synchronize the desktop and web (this is done via a button click, no
"realtime" updates). Same scenario with the web side, but the web interface
won't acutally be able to synch with the desktop - the user would have to
initiate the synch from their workstation. We've pretty much worked out the
synch logic path, and we're working on acutally interfacing with the SQL
Server.

Can this be done reliably using a standard ADO connection between the
desktop and the web site? I would imagine traffic would be somewhat
minimal - on average, no more than 100 records would be added or updated.
I've done some testing on this, and with 20 - 50 records it seems to work
fine both ways.

Suggestions of better/more reliable methods would be most appreciated, and
thanks for your time

View 5 Replies


ADVERTISEMENT

Windows Synchronization Manager And Subscriber Web Synchronization

Dec 7, 2005

Hi,

View 5 Replies View Related

Web Synchronization - Completed Synchronization Starts Again

Sep 6, 2006

Hello everybody,

There is some strange behaviour i've recently noticed while watching synchronization progress in Replication Monitor on SQL 2005 Server Standard with merge replication configured. The merge process seems to repeat several times.

This is the initial synchronizaion (reinitalization at the subsciber). Client is using Microsoft.SQLServer.Replication objects from .net framework assemblies.

The synchronization starts normally (status is "Running"). The last message of selected session box shows (among other messages): "Beginning evaluating partial replication filters" then "Finished evaluating partial replication filters" and finally "Merge completed after processing xxx changes... etc." after a few seconds. Status changes to "Completed" and then... the merge process starts again!! "Beginning evaluating partial replication filters" etc. And this repeats about 15-20 times.

And so whole process takes about 15 minutes instead about 45 seconds to complete initial synchronization. The number of changes is "Merge completed after processing ..." never change since the first such message.

Is this some bug in web synchronization or some invalid configuration setting? Why does merge process repeat itself so many times??

Please help, thanks in advance.

Kuba

View 6 Replies View Related

Sql Server Synchronization

Jun 6, 2002

hi!
all.

i want to create a web application architechture which having multiple web server.
this all web server having sql server database.
now what i want is to Keep all data in all databases.
means i want to synchronize my all sql servers.
it is also possible ki my one webserver can have multiple clusted database.
hope to hear soon from u people.

Regards
Viky

View 1 Replies View Related

Sql-Server Synchronization

May 24, 2007

Dear All,

How to do Sql Server Synchronization.

Say:
Server "A" contains "123" database.
Server "B" contains "123" database.

But changes is made on Server A. I want that every changes made on server A "123" database should reflect on Server B "123" database on real time basis.

whether it is done through replication or any other way, i want practical answer so that i can try it out.

Thanks

View 2 Replies View Related

Sql Server Synchronization

Feb 12, 2006

I want to realize these steps in .net2005 C# programme:

1) Start Sqlserver2005 publication snapshot agent.

2) View Sqlserver2005 snapshot agent status, if it finished then go on.

3) Start Sqlserver2005 Subscription synchronization agent.

4) View Sqlserver2005 synchronization agent status, if it done then continue.

I tried to find some SP, dll, method or script to realize this funtion, but failed.

I really need help.

A thousand thanks for your patience.

View 3 Replies View Related

Synchronization Between Two SQL Server Database

Jun 23, 2005

I have two SQL Server Database, one is at my company and one is at my company's customer. There are two related databases and two related tables in the servers. When I make a change in the table at my database, I want these changes to be done at the other server. I mean the related tables should have the same records all-time. I made a search and found that "Linked-Servers" is a good idea in this scenario. I made a linked server and run the following query in the Query Analyzer;insert into SAMPLE_LINKED_SERVER.SAMPLE_DATABASE.dbo.SAMPLE_TABLE(id,name) Select id,name From MY_SAMPLE_TABLE Where id Not In (Select id From SAMPLE_LINKED_SERVER.SAMPLE_DATABASE.dbo.SAMPLE_TABLE)This query works as I wanted. But I want this process to be done automaticaly without user interaction. Should I use Trigger? Do you suggest using Linked Servers?Or is there any other methods to make synchronization between two SQL Server Database?If I cannot find a good method in SQL Server, then I will be forced to make this synchronization by writing .NET code, but that would be difficult I think. Any suggestion and comment is wellcome.Thanks in advance.

View 2 Replies View Related

2 Sql Server Database Synchronization ....

Oct 29, 2002

hi!all

i want to synchronize 2 sql server database resides at diffrent locations.

i want steps to do synchronization with the help of sql server enterprize manager as well from Sql - Dmo and VB.

:confused:

Thanks all in advance.

View 1 Replies View Related

SQL Server Data Synchronization

Oct 27, 2005

Hi all

I have two SQl Server 2000 in two different location, at one point I wand to Transfer the information in one table (in Sql server 1) to the same table (in SQl server 2) using Stored Procedure.

Can any one through some input on how to write the SP?

Regards

View 1 Replies View Related

Client To Server Synchronization

Sep 10, 2007

We are working on data synchronization application. This application will synchronize data which are stored in flat file on several client machines generated by windows application to central database (Probably My SQL or SQL Server).

This application/agent will continuously monitor all the modifications done by windows application on client machine and then synchronized data with the central database.

Currently we are looking for unidirectional synchronization i.e. from client to server only.

If you have worked on similar kind of project, it would be great help if you share technology/architecture used in your application.


Thanks & Regards,
Jugal Shah

View 1 Replies View Related

Does Sql Server Compact Edition 3.5 Support RDA Synchronization With Sql Server 2000 Database?

Jan 21, 2008

Does Sql Server Compact Edition 3.5 support RDA synchronization with Sql Server 2000 database?

View 4 Replies View Related

Header Information Is Either Corrupted Or Missing. While Synchronization Between SQL Server 2000 && SQL Server CE 2.0

Jun 30, 2007

Hi
I am stuck while doing synchronization between SQL Server 2000 and SQL Server CE 2.0.
getting an Error "Header information is either corrupted or missing."

My Specification is follow :
Windows XP with SP2
Visual Studio 2005 Enterprise edition
SQL Server 2000 (SP3a)
SQL Server CE 2.0
Application is Smart Device application (Pocket PC 2003) using C#.
Microsoft ActiveSync 4.5
IIS 5.1

I followed steps as per given in this URL :
http://msdn2.microsoft.com/en-us/library/ms839425.aspx#sql_serverce_replication_net_topic2I performed eeach steps successfully, My code is as per given below.

private void button1_Click(object sender, EventArgs e)
{
getSyncReady();
}

SqlCeReplication loSqlCeReplication;
private void getSyncReady()
{
try
{
String lsDBFile = "Northwind.sdf";
loSqlCeReplication = new SqlCeReplication();
loSqlCeReplication.InternetUrl = "http://192.168.0.5/Northwind/sscesa20.dll";
loSqlCeReplication.Publisher = "C99";
loSqlCeReplication.PublisherSecurityMode = SecurityType.NTAuthentication;
loSqlCeReplication.Publication = "NorthwindProducts";
loSqlCeReplication.PublisherDatabase = "Northwind";
loSqlCeReplication.Subscriber = Dns.GetHostName();
loSqlCeReplication.SubscriberConnectionString = "Data Source=" + lsDBFile;
if (!System.IO.File.Exists(lsDBFile))
{
MessageBox.Show("The application requires synchronization", "Replicator",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1);
loSqlCeReplication.AddSubscription(AddOption.CreateDatabase);
}
loSqlCeReplication.Synchronize();
}
catch (Exception foException)
{
throw foException;
}
}



I am not getting whats going wrong.
My Firewall is disable and i have not installed any antivirus softwares (including Norton internet Security....in many forums i got this suggestion but i think its not an issue,even though for solving this issue i performed new installation of Windows XP SP-2 )

View 4 Replies View Related

SQL Database Synchronization With Server Mobile

May 8, 2007

Hi there,
I need to create a synchoronization with the Server Mobile (displayed in the Pocket PC emulator)  once the website (SQL server Database) is updated. Is there any coding available? How is it possible? PLSSSSS HELP ME....

View 2 Replies View Related

Table Synchronization Across Databases On The Same Server

Oct 26, 2005

Hello EveryoneWe have a third party tool which maintains its own customdatabase,DB1 on SQL Server 2000 on Server A (Windows 2000). We built aninhouse application which maintains a transactional database, DB2 alsoon Server A derived from DB1. Since the DB1 is frequently updated thesynchronisation between the databases is currently maintained by usingviews in DB2 which pulls in all the required data from across tables inDB1.But we found that the cost of employing views, referencing tablesacross databases has made the inhouse application slower and so as aapparent performance tuning measure we plan to maintain a subset ofdata(for a specific time period) from DB1 in actual tables with sameschema in our transactional database DB2. But since the tables in DB1are frequently updated during the day we are required to thesynchronise the corresponding tables in DB2 with their counterparts inDB1. The only constraint in this synchronization being that the thirdparty custom database,DB1 cannot not be subjected to any changes (likecreation of triggers) as it is maintained by a different group ofpersonnel.I read about Triggers,Maintenance Jobs and Replication but not surewhich would suffice our needs.Are there any recommendations on how thiscould be carried out? Any suggestion would be welcome.Thankschandra

View 1 Replies View Related

Recovery :: Production / DR Server Synchronization

Aug 5, 2015

How can I keep a production SQL server and DR SQL server in sync? I'm not referring to data - I can use SAN replication for that.  I'm referring to the many configuration settings and objects that are external to the databases..Server settings (xp_cmdshell, etc.)LoginsServer- and database-level rolesServer- and database-level permissionsObject level permissionsMaintenance plans/SSIS packagesSQL Agent jobsJob schedulesDatabase mail configurationObjects (proxies, alerts, credentials, operators)Linked serversScheduled tasksODBC connections

I realize that many of these items can be scripted out, and periodically run on the DR server; but not all of them can be.  And some, although they can be scripted, may be problematic to restore on a DR server, such as SQL Agent jobs.  And even with backup scripts, it seems like developing a process to refresh a DR server would be overwhelming given the number of elements and exceptions.  I'm not adverse to doing the work to create a completely scripted solution, but was curious if one already exists that handles all or most of the elements in my list.

View 2 Replies View Related

SQL Server Data Migration And Synchronization

Apr 13, 2007



Hi,



I need to move my database servers from one location to another. The issue is that I have over 200 databases to move and my clients can't afford a downtime. The collective volume of all the databases is over 2.5 TB and growing.



I am thinking to copy these databases in batches over the WAN to the new location and replicate them using Transactional replication till I have all the databases moved and synchronized.



Will it be wise enough to use replication for synchronizing 200 databases or is there a better approach which I can use to move these databases with minimum downtime and compromise on performance of applications.



Note: Migration is from SQL Server 2000 to SQL Server 2005.



Thanks in advance.

Ritesh

View 9 Replies View Related

Synchronization Operation From Server Side

Mar 20, 2007

Hi

I am doing a task for synchronize data between SQL server 2005 and SQL Mobile.

Created a publication in my SQL server 2005

Created a subscription in my device thru coding. The code is below.

SqlCeReplication repl = null;

try

{

repl = new SqlCeReplication();

repl.InternetUrl = @"http://localhost/TestFirst/sqlcesa30.dll";

repl.Publisher = @"zcs6";

repl.PublisherDatabase = @"TestNow72743";

repl.PublisherSecurityMode = SecurityType.DBAuthentication;

repl.PublisherLogin = @"sa";

repl.PublisherPassword = @"Test";

repl.Publication = @"TestFirst";

repl.Subscriber = @"TestNow7274310";

repl.SubscriberConnectionString = @"Data source = 'TestFirst.sdf';";



if (!File.Exists(@"TestFirst.sdf"))

repl.AddSubscription(AddOption.CreateDatabase);

repl.Synchronize();

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

finally

{

repl.Dispose();

}

If I run this code from my device the replication work successfully. Now I am calling synchronize from device.

My question is How can i start synchronization from server side. Is it possible to do that from server side?

View 3 Replies View Related

Bidirectional Synchronization For SQL Server Mobile?

Jul 4, 2007

I create a distributed database for mobile application. I replicate a table that distribute on mobile device. I follow instruction how to create distributor, publication, replication, web synchronization, and subscriber database. I have done fine for synchronization between mobile database into desktop database (in this case SQL Server 2005 Standard Edition). But the problem is how can setup publication so it can bidirectional, not only from mobile database into desktop database, but also from desktop database into mobile database. So in the mobile database can have same data with desktop database even on mobile database lost some old data.

Its like data exchange between both engine. Desktop and mobile have same data. For filtering I can put filter on the desktop server for replicated table, so don't worry how I split the data.

Thanks a lot.

View 1 Replies View Related

Synchronization Of SQL Server 2000 && SQL-Lite Data

Sep 21, 2005

I have a master database containing data from many client databases located in various locations.
I have to synchronize data between the master & client databases. If data in client changes, the master needs to be updated. If the data in Master changes, the client needs to be updated.

Because of the security issue, the client location will initiate this process of Synchronization. It has to be automatic process scheduled once everyday. The Client databases are SQL-Express Databases and the Master is Sql Server 2000 database.

What is the industry standard or the best way to achieve this task ? Are their any tools that easily accomplish this? Can SQl Server Replication achieve this ?

Thanks

View 1 Replies View Related

SQL Server CE Merge Replication Synchronization Question

Mar 9, 2006

I am running SQL Server 2000 and SQL Server CE on the handheld device. I have created the publication on the SQL Server.

I can subscribe to the publication successfully on the handheld and it creates the .sdf file just fine.

When I then attempt to synchronize, the process will run for a long time and eventually error out. (The database has a couple large data tables that are used for value lookups)

The error says the connection was broken.

Any suggestions on correcting this?

I am thinking of breaking the replication database into 2. One with the large lookup files and one with the updated tables. I still need to get the large database with the lookup tables onto the handheld though.

Any thoughts, advice or similar experience handling a situation as this would be appreciated.

thanks,

Dan

View 1 Replies View Related

SQL Server Express Synchronization With Sql 2005 Server

Apr 17, 2008



Hi,

We have a window based application which uses sql server express as a backend...

Currently, We are sending xml files to the users to update their application with data users also sends data in xml format to us.

We receive data from various users and collate it on a central server for analysis..

We prefer having sql server express as a local data store so that user does not depend on live connection to the central server. But we would like to have a on demand syncronization or scheduled snyncronization with central sever ,,,

There are many approaches to it... my question is which is the best for our given scenario. Is it using web service or sql sever broker or sql synnchronization.

If you can direct me to some practical implementation then it will be great help.



Thanks

San

View 1 Replies View Related

Synchronization Between SQL Server Express - SQL Server Mobile

Dec 7, 2006

Hello,

I plan to use :

- SQL Server on server
- SQL Server Express on notebooks
- SQL Mobile on Windows Mobile 5.0 devices.

How can I create a replication between SQL Express and SQL Mobile ? SQL Server express cannot act as a Publisher server.

In this post a Senior Program Manager says It is possible but I don't find how to :
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=55236&SiteID=1

Thanks

JF

View 1 Replies View Related

SQL Server 2014 :: Merge Replication Synchronization In Stored Procedure

Oct 24, 2014

I'm updating some tables in a subscriber database with a stored procedure. After the tables get updated I'd like to sync them with the other subscriber dbs and the publisher db in that same stored procedure.I can do it manually in SSMS with the View Synchronization method. Are my only alternatives a batch job or C#?

View 1 Replies View Related

Pocket Pc 2002 Sqlce Data Synchronization With Sql Server 2000 (SP4)

Mar 11, 2006

i am using C#..net

I am synchronizing the sql server data with sqlce.but i get an
error when i call synchronize function. i am using sqlcereplication
class.

the error is

"a call to sql server reconciler failed"

native error 29006

and sometimes

native error

29045.

View 4 Replies View Related

Where Is Install For SQL Server 2005 Mobile, Cofigure Web Synchronization Wizard???

Dec 21, 2006

I have something called Configure Web Synchronization Wizard under my SQL Server 2005 Mobile Edition on my XP machine. My problem is that I need to install it on a Windows 2000 machine and I can't find the installation package for it. I installed SQL Server 2005, which installed SQL Server 2005 Mobile Edition, but I didnt' get the wizard. I also installed Visual Studio 2005.

Anyone know where it is?

View 1 Replies View Related

Sql Server 2005 Compact Edition 3.1 RDA Synchronization Fails On Table With Index In Sql Server 2005 Database

Jan 21, 2008

We have been using Sql Server 2005 Compact Edition 3.1 RDA synchronization method successfully on Sql Server 2000 database. Recently we moved the database to Sql Server 2005, sync doesn't work anymore, it just hangs on one table. On further investigation, we found out that it's the index on that table that causes this. We removed the index, it works fine. We are wondering the root cause, removing the index is not a solution for us. Any thoughts?. Thanks.

View 1 Replies View Related

Need Help On A Visual Basic.net Pocket Pc App. With SQL Server CE 2005 And SQL Server 2005 Synchronization Problem

Aug 12, 2007



Hi,
I am developing an application for pocket pc 2003 smart device which utilizes synchronization between SQL CE 2005 and SQL server 2005 by means of REMOTE DATA ACCESS method call PULL( ) and PUSH( ) but currently these are the details of the error Im encountering when PULL( ) method is called:


Error code: -2147467259
Descripion: An error occured on the computer running IIS.Restart the IIS server.

Minor error: 28022
Source: SQL server CE
Currently Im developing this application as a final project and due to some limitations I have setup my pc to act as the SQL server and the IIS server both on the same machine.

Any help will be appreciated, thanks.

View 5 Replies View Related

Data Access :: Server Rejected The Connection - Access To Selected Database Has Been Denied

Jun 10, 2015

I have recently upgraded to SQL2014 on Win2012. The Access front end program works fine.

But, previously created Excel reports with built in MS Queries now fail with the above error for users with MS 2013.  The queries still work for users still using MS 2007. 

I also cannot create any new queries and get the same error message. If I log on as myself on the domain to another PC with 2007 installed it works fine, so I don't think it is anything to do with AD groups or permissions.

View 6 Replies View Related

Multi-user Access Through A Data-access Layer/remoting Server

Oct 30, 2007

Hi guys,

I've been developing desktop client-server and web apps and have used Access and SQL Server Standard most of the time.
I'm looking into using SQL CE, and had a few questions that I can't seem to get a clear picture on:

- The documentation for CE says that it supports 256 simultaneous connections and offers the Isolation levels, Transactions, Locking, etc with a 4GB DB. But most people say that CE is strictly a single-user DB and should not be used as a DB Server.
Could CE be extended for use as a multi-user DB Server by creating a custom server such as a .NET Remoting Server hosted through a Windows Service (or any other custom host) on a machine whereby the CE DB would run in-process with this server on the machine which would then be accessed by multiple users from multiple machines??
Clients PCs -> Server PC hosting Remoting Service -> ADO.NET -> SQL CE

- and further more can we use Enterprise Services (Serviced Components) to connect to SQL CE and further extend this model to offer a pure high-quality DB Server?
Clients PCs -> Server PC hosting Remoting Service -> Enterprise Services -> ADO.NET -> SQL CE

Seems quite doable to me, but I may be wrong..please let me know either ways

Thanks,
CP

View 3 Replies View Related

Can I Access MS Access Table In A Select Query Of SQL Server

Nov 29, 2006

Is there a way to specify a MS Access table (or query object) in the select query of SQL Server.

Ex.:

MSAccessTable (in file.mdb)



col1
col2

a1
a2

b1
b2

SQL query in SQL Server:

SELECT col1, col2 into SqlTable from [file.mdb].MSAccessTable;

Thanks,

View 3 Replies View Related

Data Access :: Server Does Not Exist Or Access Denied

Apr 22, 2015

When i am trying to start our hospital software based on SQL server 2000, it shows Following Error.Search Condition is not valid, (DBNETLIB) Connection Open (connect()).  SQL server does not exist or excess denied. Due to Fetch data.I run our software in Windows 8.1, while it smothly runs in previous version of Windows XP and 7.

View 2 Replies View Related

Possible To Keep MS Access Interface And Migrate The MS Access To MS SQL Server?

Oct 31, 2005

Hello allWould it be possible to migrate the MS Access 2000 to MS SQL Server2000?My application is using MS Access 2000 as database and as userinterface such as forms. Now, I want to migrate the backend databasefrom MS Access 2000 to MS SQL Server 2000. However, I want to keep theMS Access 2000 interface. Would it be possible?If I migrate the MS Access to SQL Server, would the queries, back-endVBA, macro, tables and forms be affected? Do I need to change the MSAccess data type to SQL server supported data type?Which tool I can use to do the migration? Upsizing wizard or exportingthe Access database and then importing it to the SQL server?Thanks in advanceCheersBon

View 4 Replies View Related

Trying To Access SQL SERVER 2005 With Access 2003

Dec 18, 2006



I am trying to connect through ODBC connectivity, but it will not allow me to do so. I have investigated this matter. It leads me back to the server, because as I was configuring my client side database. It kept asking for the DSN(datasource name), but I was unable to choose one because there wasn't one to choose. Which is my current dilemma, How can I do this and have it available to choose from the server to satisfy the Access database?

I went to the domain where the software resides but I don't know what steps to take? I also found an interesting piece on microsoft about Kerberos, but I can't follow along according to the instructions it has. I have Access 2003 & SQL SERVER 2005, HELP...!

Basically, this is right off the heels of the install. I setup the server without the connectivity, but it is running the current configuration.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved