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
Hi,
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
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
Hi
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
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
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
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
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 RelatedHi 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
Hello!
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
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 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.
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
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
Hi,
Our current environment is: SQL Server 2000 backend; XP/Windows 2000 clients with MSDE loaded; a Microsoft Access 2002 app using DSN to connect to the local MSDE database; Merge replication which is a job within the MSDE engine that we execute in VBA code using the following DMO code:
' Find the Job name to execute
lngJobCount = oServer.JobServer.Jobs.Count
lngJobIndex = 1
blFoundJob = False
While lngJobIndex <= lngJobCount And blFoundJob = False
strJobName = oServer.JobServer.Jobs.Item(lngJobIndex).Name
Me.lstJobs.AddItem strJobName, 0
If InStr(1, strJobName, "LEXData", vbTextCompare) > 0 Then
If InStr(1, strJobName, strServerName, vbTextCompare) Then
blFoundJob = True
End If
End If
lngJobIndex = lngJobIndex + 1
Wend
' Execute the job
If blFoundJib Then
Set oServer1 = New SQLDMO.SQLServer
With oServer1
.LoginSecure = True
.Connect strServerName
End With
Set oJob = oServer1.JobServer.Jobs(strJobName)
End If
We are now planning a move to a SQL Server 2005 backend and Express edition on the clients and the app would remain as Access 2002. Any pointers to documents that will be useful would be appreciated but I have a couple of specific questions as well.
1) As I understand it we can load Express side by side with MSDE so we will probably go down that path and load the data from MSDE into an Express version of the database. Once that's done we will create a DSN pointing to the new database and name it the same as the DSN which is currently used for the MSDE database. If we do this will our Access app simply work as before (ignoring replication)?
2) When we have our app happily running against a DSN that points to an Express database would we expect our existing DMO code (as above) to work, e.g. find a particular job in a list jobs and executes it? I can see that the replication job itself may have to be rejigged for Server 2005.
TIA - Peter
I have done a couple of little projects in VB express and was pleased with the results. Now I have something bigger in mind and need to know if VB express version of SQL will support merge replication. If not will the full version support it?
Thanks
Dave
Hello,
I have the following scenario. An application using SQL Server 2000 SP3 on the server side and clients using MSDE 2000A (SP3a) on the client machine. Since the client is offline quite often merge replication is used to keep the clients in sync.
Now we try to upgrade to SQL Server 2005 SP1. The publisher and distributor upgrade (on the same box) worked fine and all clients could still synchronize. Fine :-)
Now we try to upgrade the clients to SQL Express SP1. Now the problems start :-(
1) After the upgrade the entry within the Synchronization Manager is gone (we can overcome this by using sp_MSregistersubscription or by manually disable and enable Synchronization manager on the subscription properties)
2) Initial Synchronization (takes a long time but) works fine, if I apply changes to the subscriber or force a reinitialize all following synchronization will fail. With the following messages:
Error messages:
The merge process could not clean up the subscription to 'tstvmw23':'TestBase:'TestBase'. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200965)
Get help: http://help/MSSQL_REPL-2147200965
New request is not allowed to start because it should come with valid transaction descriptor. (Source: MSSQLServer, Error number: 3989)
Get help: http://help/3989
Remark the test system I use is a nearly empty db (only with full schema and a few lookup tables) with 15MB. The same error occures if I create a new database an subscribe to the same publication.
Please help otherwise I'm forced to step back to MSDE.
Thanks in advance,
Thomas Hotz
Is there any method to setup table replication between you sql server express?
View 3 Replies View RelatedI am having trouble setting up my Pull Subscription and I am new to replication.
I have several servers hosting a databased website that will be the same, except for user input and traffic. Quite simply, I need to copy most tables, SPs and data from network to network. I can't use FTP/Web synch ... as I mentioned the networks do not touch eachother or the internet.
On server Web1, it was easy to create a Publication called Pub via the wizard for my database: TheDB. Then on Web1, again, I added a Subscription to the Publication, indicating my second server, Web2, and the same database name: TheDB (I have already backed up and restored TheDB to all my servers). Here's one of the sp's I ran on Web1:
use [TheDB]
exec sp_addsubscription @publication = N'Pub', @subscriber = N'Web2'', @destination_db = N'TheDB', @sync_type = N'Automatic', @subscription_type = N'pull', @update_mode = N'read only'
GO
This is where I feel stuck. Using the wizard on Web2 doesn't allow me to see Web1. So I tried the following on Web2:
use [TheDB]
exec sp_addpullsubscription @publisher = N'Web1', @publication = N'Pub', @publisher_db = N'TheDB', @independent_agent = N'True', @subscription_type = N'pull', @description = N'', @update_mode = N'read only', @immediate_sync = 1
exec sp_addpullsubscription_agent @publisher = N'Web1', @publisher_db = N'TheDB', @publication = N'Pub', @distributor = N'Web1', @distributor_security_mode = 1, @distributor_login = N'', @distributor_password = null, @enabled_for_syncmgr = N'False', @frequency_type = 1, @frequency_interval = 0, @frequency_relative_interval = 0, @frequency_recurrence_factor = 0, @frequency_subday = 0, @frequency_subday_interval = 0, @active_start_time_of_day = 0, @active_end_time_of_day = 0, @active_start_date = 0, @active_end_date = 19950101, @alt_snapshot_folder = N'', @working_directory = N'', @use_ftp = N'True', @job_login = null, @job_password = null, @publication_type = 0
GO
I copied the snapshot folder, ie. 20070709134423, onto CD and moved it into Web2's default replication folder, but I always receive: cannot connect to Distibutor. I've tried using an Alias, as well, but don't understand exactly how I should point that either. I checked the publication's PAL and my Web2 user has rights and is an owner of the Web2 TheDB database.
Any help is appreciated.
Nate