Hi All
I am trying to sync sql server file on two separate computers running SQL Server 2005 Express. I am writing an application (VB.NET) and I am trying to update the other computers when data is changed. Is it possible?
Thanks
HI
Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS?
Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients?
Regards
I am running a local version of SQL Server 2005 Express and SQL Server Management Studio Express Edition. I have a web app using the database and I need to migrate the app, the database and database objects to my outsourced host. What is the best way to do this, since the replication and packaging capabilities are limited. Is there a standard, simple way to do this?
View 2 Replies View RelatedHello!
Question of such plan, to documentation to Microsoft SQL Server 2005 Express Edition it is written, that the given product supports only PUSH replication, however in his{its} structure there is an agent replmerg.exe which description says:
replication merge. Synchronization means, that the agent of merge transfers changes from the subscriber to the publisher, and then transfers changes from the publisher on the subscriber €¦
And so the question if this agent is present at this edition, whether that is possible to adjust manually his{its} call, or through Windows the agent, for realization PULL replication or it is impossible and for what reasons?
Thanks.
Hello,
I am facing problems trying to replicate SQL Server 2000 table to SQL 2005 Express. The error says:
"login failed for user 'username'. The user is not associated with a trusted SQL server connection"
PS:
The same happens when I try to register the SQL 2005 server in SQL 2000 Enterprise Manager.
Any help?
Thanks
Walid
I want to replicate data from sql server 2000 to a sql server express 2005 box.
I can dts data across..but I want to be able to set up push replication from the Sql Server 2000 box, but the option to push the data to the Sql Express server in the GUI does not come up only Sql Server 2000 boxes are listed. Initially I will be using Snapshot replication but would like to eventually move on to transactional rep if only I can get it to push the data across.
Does anyone know how to acheive this thanks for any help Sammy.
Wondering if anyone has any experience with SQL Server Express Edition (SSEXP). We're looking at a mobile sales force type model, so a local database on a laptop with no real time network connection. So the users would collect data locally, then connect up to the network every few days to replicate the data to a central server.
So questions.. Has anyone tried anything similar? How stable/mature is SSEXP? Any other thoughts, alternatives or gotchas anyone can think of?
Thanks for the input.
Hi,
I need to synchronize the data between two SQL Server 2005 Express.
The database is really simple, just few tables (but data are inserted very often) without any triggers.
Since Express edition could not behave as a Publisher I was thinking about implementing manually a sort of Replication mechanism... It should be a sort of Transactional Replication with queueud updating.
Does it sound a good idea?
Has anyone done this before o there are better solution?
Thanks in advance,
Stefano
Is there any method to setup table replication between you sql server express?
View 3 Replies View RelatedHi,
I have a VB.net app that access a SQL Express database. I have transactional repliaction set up on a SQL 2000 database (the publisher) and a pull subscription from the VB.net app. I use RMO in the VB app to connect to the publisher. My problem is I am getting some strange behaviour as follows
- if I run the app and invoke the pull subscription it works fine. If I then close my app and go back in, I can access my data without any problem
- If I run the app and try to access data in my SQL Express database it works fine. I can then close the app, reopen it and run the pull subscription it works fine
however.......
- if I run the app, invoke the pull subscription (which runs fine), and then try to access data in my local SQL Express database without firstly closing and reopening the app, I get a login error
- if I run the app, try to access data in my local SQL Express database (which works fine), and then try to run the pull subscription I get a "the process cannot acces the file as it is being used by another process" error. In this case I need to restart the SQL Express service to be able to run replication again.
I get exactly the same behaviour when I use the Windows Sync tool (with my app open at the same time) instead of my RMO code to replicate the data.
I am using standard ADO.Net 2 code to access my SQL Express data in the app and closing all connections etc
Any advice appreciated !
Thanks
Ronan
Hello,
on the server this version is running:
SQL Server Express with Advanced Services
Datenbankmodul
[Version: 9.2.3042.00 Edition: Express Edition Patchebene: 9.2.3042 Sprache: Deutsch (Deutschland)]
Reporting Services
[Version: 9.2.3042.00 Edition: Express Edition Patchebene: 9.2.3042 Sprache: Deutsch (Deutschland)]
Now I will install the "replication" modul, but when I select the option, install replication the system need the
"sqlrun_sql.msi.
I have select the folder (the install folder where the "sqlrun_sql.msi" is) but I become the message:
like this: the "sqlrun_sql.msi" is not the right.... for you SQLEXPRESS Version......
here I found the same .....error:
http://www.codeprof.com/dev-archive/71/19-95-712279.shtm
what can I do,
thanks for help, marc
We have a large number of clients attempting to replicate two publications on 2005 Express databases (2 publications subscribed to the one subscriber database) with our 2005 Server (9.00.3042.00 SP2 Standard Edition) and experiencing two significant problems:
1) Users experience the following message:
The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Subscriber for changes not yet sent to the Publisher. You must reinitialize the subscription (without upload).
This problem should not apparently occur with SQL Server 2005 (or 2005 Express) instances with SP2 applied. All clients experiencing this problem have SP2 installed as does our Server and the retention period is 30 days. The subscribers have been replicating well under that.
2) Replications never succeed after appearing to replicate/loop around for hours
This issue is the most critical as we have clients who have been installed and re-installed with new instances of SQL Server 2005 Express, new empty databases (on subscriber before snapshot extraction), and using fresh snapshots (less than an few hours old) which cannot successfully replicate.
Interestingly there is at least 1 instance where several computers are subscribed and successfully replicating the same database as another where replication refuses to succeed.
To test we have taken a republished database from another 2005 Server which is working fine and restored it to the same server as the one holding the database with which we are experiencing problems and subscribed to it. This test worked fine and replication of both publications went through fast and repeatedly without showing any signs of problem.
This indicates that the problem is perhaps data related as it appears localised to that database.
Below are two screenshots which may assist.
Screenshot 1 Shows that on the server side the replication attempts look like they are succeeding despite the fact that the subscriber end does not indicate success. Also the history indicates the the subscription has spent all it's time initialising and not merging any changes.
Screenshot 2 Shows a rogue process which has appears on many of the problem child subscribers. It shows a process running with no end time even though the job indicates failure in the message and even though other replication attempts appear to have succeeded after it. This process stays in the history showing that it is running even when I can find no corresponding process for it.
Can anyone suggest a further course of action/further testing/further information required which may assist?
This is extremely urgent and any assistance would be greatly appreciated!
Thanks in advance!
Scott
Hi!
View 14 Replies View RelatedHi
Is here anybody who knows if Merge replikation is working between SQL Express 2005 and SQL 2000 server?
Or must I use 2005 on both plattforms?
I know SQL Express supports replication as a subscriber, but a company I may be going to has a bunch of SQL 7 servers that will be upgraded to SQL 2005. They are all small databases <200MB and I see no need for full versions of SQL. The only issue is they use replication to and from these boxes to corp every night. So from corp to the stores I would use replication. From the stores to corp I was thinking of using SSIS to pull the information or maybe a job to export the data and transfer it to corp. Was looking for other ideas. The communication lines for most part are high speed but they do have unexpected outages in different areas of the country so that is a consideration.
Raymond Laubert
MCITP:Administration, MCT
http://www.rd-webhosting.com
Home Based Business Library and Hosting
Please could someone clarify for me if SQL Express can be a subscriber to a SQL Server 2000 replication?
I am interested to know if a SQL Express db can subscribe to both snapshot and transactional replication.
Thanks
I am developing a web site that contains a SQL Express database. When done, I want to FTP the entire site to server running in a DMZ. All changes are done on the inside, and every evening it will synchronize by copying everything, including the database to the DMZ web server. Am I going to have issues with the SQL Express database in doing this?
TIA --> Jon
Hi everyone,
I am not familiar with SQL express. Will it work if I setup publisher/distributor on SQL express and replicate data to exterprise version?
Thank you in advance.
Hello:
I tried to set up a pull transctional replication on SQL Express 2005.
The publisher is SQL 2000 which has tables that have primary keys.
However, only tables I see in my SQL express (Subscriber) are the system tables. What did I do wrong?
I can't find the right answer on the web.
Thanks
GCP
I am considering using a local database for a desktop application, instead of relying on remote connections. This will require replication I suppose to sync up table changes etc. What are my options when using Sql express on the client end and Sql server (standard edition) ?
After looking at this
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Now, Im wondering how do I get local changes merged back into the primary database ?
Hi,
does any know of any plans to support publications in Sql 2005 Express? I want to start moving away from MSDE but we use replication (one MSDE database is the publisher and several client PC's use MSDE as the subscribers.).
Maybe it is on SP2?
Thanks for any info you have on this.
Graham
I have tried to setup Web replication following the instructions in the articles in SQL Books Online, using RMO. I am able to create the subscription, but when I try to sync it I get the following error.
The process could not create file 'C:DOCUME~1lsimpsonLOCALS~1TempHNTBW115D$B_borings_BoringsAll_C:BORINGSBORINGDB.MDF' due to OS error 123.
Is anyone familiar with this error? If I can solve it, I think the replication will work.
I am attempting to set up the following:
SQL Server 2005 with Merge Publication
Web Replication Enabled
IIS Configured as documented, except DB server is an AD Domain Controller so can't assign Local User to Application Pool
SQL 2005 Express
Using RMO to create subscription
Using Basic Authentication of HTTPS
Calling the replisapi.dll?diag works fine
When I attempt to do a web synchronization with the Publisher, I get the following error:
The Merge Agent could not connect to the URL 'https://test.abc.com/TestWebReplication/replisapi.dll' during Web synchronization. Please verify that the URL, Internet login credentials and proxy server settings are correct and that the Web server is reachable.
Does anyone have any suggestions. I am sure it has something to do with the security setup on the Publisher, but I can't think of anything else to try.
Thanks
Hi All,
I am trying to do a Replication between a network SQL Server Express Edition 2005 DB with a client SQL Server Express Edition 2005 DB. My question is
1. Can we do replicaiton between SQL Server Express Edition 2005. (No SQL SERVER present)
2. If yes can any of you provide me some guidance or some pointers on how to achieve it.
Thanks
Suresh
Hi Mate !
I was searching to enable replication publication on my SQL 2005 Express, but as far as I look, this feature don't seem to be included.
Am I, correct?
Is there a way to enable this fearture?
Thanks
Zak
Dear All,
I have plan to use SQL Server Express Edition, is it possible to have DB Replication features in this edition? .. please advise..
Thanks a lot in advance
Regards
Winanjaya
Hello,I am learning SQL Server 2005 Express. I need to test replication butwhen I run New Subscription Wizard I got error: "There are nopublications to which you can subscribe, either because this serverhas no publications or because you do not have sufficient privilegesto access the publications."I see no option for publications. Does this mean that in Express Icannot run replication? If I can, how?Thank you very much/RAM/
View 4 Replies View RelatedI have a Windows Mobile aplication that uses merge replication to synchronize between sql compact and full sql Enterprise edition and It works great. Instantiating the SqlCeReplication object setting it's properties and calling Synchronize on it is pretty simple assuming everything is setup properly at the publisher.
For the life of me I can't figure out how to do this on the desktop (Programatically setup a subscription and create a database using objects in the System.Replication Namespace and hopefully call Synchronize on it).
Someone please point me in the right direction.
Thanks,
Patrick
Hi Everyone
I have a huge problem after I noticed that SQL Server Agent has been removed
and need your advice about how to program replication between SQL Server Express and SQL Server 2005
So far I have encountered the following problems
SNAPSHOT
1. When I created my snapshot Irealized it wasnt running. I then read from the documentation that i had to resort to the Windows Synchronization Manager as there was no SQL Server AGENT within SQL Server Express to accomplish this function
I did this and it worked but wouldlike to control this programmatically as well
REPLICATION
2. Now I have a standalone SQL Server Express which is a subsciber to the SQL Server 2005 Database
How can I force the merge replication programmatically ie Vb.NET
Your kind advice is appreciated
Regards
Touraj
yiotis writes "Is there a way where you can programmatically (via visual basic) replicate two or more SQL Express databases located on multiple computers without the need of SQL Server 2005 acting as a publisher. From what i understand this is a limitation in SQL Express.
Right now i have SQL Express installed on 2 machines. I am able via vb to communicate with each database, read and write data between databases but cannot seem to figure out how to perform a simple replication.
Bottom line is, i need to be able to replicate via vb code 2 sql express databases with each other.
Thanks"
Hello all,
We have 2 sites . each one has sql 2005 express edition .
is it possible to configure replication between those 2 sql servers for failover purposes ?
Thanks
I can choose synchronization direction for articles: a) Bidirectional b) one way
1) Is that possible somehow to replicate the schema only of an article but no synchronization / zero direction :-)/
2) Same question about columns, I should replicate schema only for few columns, but without data synch. These columns are freely updateable at anywhere (publisher and subscribers), but the data changes shouldn't be replicated.
Thanks for the answers in advance
Hello,
I have this problem on a Production database.
DBCC OPENTRAN shows "REPLICATION" on a server that is not configured for replication. The transaction log is almost as large as the database (40GB) with a Simple recovery model. I would like to find out how the log can be truncated in such a situation.
Thank you.