How do I replicate a database to a subscriber and extract the data from the tables that I don't want the subscriber to have. I know I can extract tables from replication but I need to extract fields within a table, that the subscriber cannot have.
View 1 RepliesHi,I have transactional replication set up on on of our MS SQL 2000 (SP4)Std Edition database serverBecause of an unfortunate scenario, I had to restore one of thepublication databases. I scripted the replication module and droppedthe publication first. Then did a full restore.When I try to set up the replication thru the script, it created thepublication with the following error messageServer: Msg 2714, Level 16, State 5, Procedure SYNC_FCR ToGPRPTS_GL00100, Line 1There is already an object named 'SYNC_FCR To GPRPTS_GL00100' in thedatabase.It seems the previous replication has set up these system viewsSYNC_FCR To GPRPTS_GL00100. And I have tried dropping the replicationmodule again to see if it drops the views but it didn't.The replication fails with some wired error & complains about thisviews when I try to run the synch..I even tried running the sp_removedbreplication to drop thereplication module, but the views do not seem to disappear.My question is how do I remove these system views or how do I make thereplication work without using these views or create new views.. Whyis this creating those system views in the first place?I would appreciate if anyone can help me fix this issue. Please feelfree to let me know if any additional information or scripts needed.Thanks in advance..Regards,Aravin Rajendra.
View 2 Replies View RelatedHi,
In my production box is running on SQL7.0 with Merge replication and i want add one more table and i want add one more column existing replication table. Any body guide me how to add .This is very urgent
Regards
Don
I have database on localhost and i want to show this data on my website. I want to create a database online and want to sync with Local Host. Can it be possible syncing data automatically after some interval?
View 6 Replies View RelatedWe have a SQLSERVER database that is replicated to many users.We are currently in an expansion phase where we need to make changesto the server database. Each time we rollout a new release, we aredeleting the local replicating database and recreating.Is there any way to automatically transfer the changes from the serverto existing local database without deleting?
View 1 Replies View RelatedIs it possible to setup replication for a particular database from an SQL2005 database server to a SQL2000 database server.
I've searched a few forums and the MS knowledge base but can't find a specific answer.
Hopefully someone can point this novice in the right direction.
Mike
Trying to replicate database from a NT 4.0 server, SQL 7.0 SP2 to imilar machine on the same domain. When I use wizard following error occurs.
SQL server enterprise manager could not complete the wizard because @@servername for " is Null. Use sp_addserver to set @@servername.
Is this looking for a remote servername? What is the issue? Even if I use SP to add server name it complains about @@servername. The new name is added to the list of the remote server.
I got some experience working and managing ms sql databases, but now I am in a need to replicate 2 databases and I can't make it work.
Please advise.
If it's possible step by step.
Thanx
Hi there,
I have a software that uses access database. this database is stored locally, thus, outside cant talk to it directly.
Now, i have a website hosted on a hosting company that runs microsoft sql 2000. I need to build a web application that will read some data from my local database and update it.
So, first thing comes to my mind is database replication. I have tried searching for helps, but couldnt find anything useful.
Can anyone tell me if replication of database from microsoft access to sql server 2000 can be done?
Any help guides will be much appreciated.
To move my local database to a webserver is not an option.
Thanks for any input
I have one database(database1) in houston and the other database(database2) at Newjersy. SO if i wanted to replicate the data from the database1 to database2 how can I do that. I wanted to setup the replication to get the data into only one table. Infact both the tables are not identical in structure.
Thanks.
I'm a newbie so bare with me. If I have two servers running SQL Server, a primary and a secondary, how can I make sure that both databases (One on each server) are always syncronized? In our situation the secondary server is a hot backup in case the primary fails. If the primary fails then data gets written to the secondary. When the primary comes back up then its database needs to be synced with the secondary. Can anyone tell me how to do this?
View 6 Replies View RelatedWhen I create a suscription with the option "No, the Suscriber alreadyhas the schema and data", and I modify data, I have an error likethis:Could not find stored procedure 'sp_MSdel_ac_callejero'.(Source: SE110556 (Data source); Error number: 2812)How can I generate a replication restoring a backup, instead of make ansnapshop.Thanks in advance
View 1 Replies View RelatedHi,Wondering if anyone can help. We have a knowledge base system which uses anMSSQL server to store information. The tool is web-based, and we have needto run reports on the information in the database, such as number and age ofarticles, for example.As the tool is used quite heavily, we can't afford the drop in performancethat reporting on the live database would cause, so we have setup anotherdatabase server which is to hold a copy of the database.We have a job set up in Enterprise Administrator which takes a backup of thedatabase from the live server every night and copies it over to thereporting server. A job on the reporting server then restores the copy fromthe live server over the top.However, the job on the reporting server consistently fails when it is run.It appears as though the database file on the reporting server is becomingunusable, however the copy remaining on the live server is fine.We are able to restore the database by manually copying over the file,however this takes up valuable DBA time that could be better usedelsewhere - has anyone else ever experienced anything like this, and if sohow did you get round it?The database backup file is around 3.5GB in size.Cheers,Andi
View 1 Replies View RelatedI'm new in the area of data replication.
I hope someone is willing to help me on this little thing I'm trying to accomplish.
Problem description
-----------------------
There is one central SQL Express database. And one (or more) SQL Express database(s) on remote locations. This approach of databases remote and central is mandatory due to some application features later-on.
The local database(s) on the remote location(s) will act as a sort of backup in case there is no network connection. Meaning that the data is stored locally at all times. And moved to the central database once the network connection is on.
Updates to the local database(s) should trigger a process where all data is moved to the central database if there is a network connection. So for now, it€™s a one way stream: remote to central.
This approach gives us the option to delay the moves - if needed. For example, the daily data is kept local and moved to the central site over night. Which is a good thing to have if network resources are limited during office hours.
Solution
---------
To make this happen, I was thinking allong the lines of using triggered stored procedures.
Where a local database update triggers a stored procedure that checks the network connection and performs the move to the central database.
If there is more than one record in the remote database, all records are moved to the central database. Also, an entry should be added to a log-file.
If the network connection is not there for whatever reason, an entry should be written in a log-file stating that there was no connection to the central database.
Options
-------
Another way of solving this is using RMO-based publications and subscribers.
Where the database on the remote locations are publishers. And the central database are subscribers. However, according to Microsoft:
- SQL Express can only act as a subscriber.
- Data is copied. And not moved.
According to the SQL-BOL, the first limitation doesn€™t exist when using programmatic, transactional replication.
However, the second needs to be solved as well. And in the examples of SQL-BOL, this is not mentioned. At least not that I€™m aware of.
There are some advantages using RMO. For example deploying a new version of the application. Or deploying an updated database schema. Please let me know if this is proven to be really usefull. If so, this would be the preferred method €“ provided that the limitations mentioned earlier are solved. And if using this method, I would prefer stored procedures or Visual Basic for programming this.
Help wanted
-----------
Like I stated earlier, I€™m a newbie on these replication matters.
So I really would like some help with this.
Who is willing to help with suggestions and examples?
Sofar, I€™ve been able to:
- Install SQL Express with network connections enabled
- Running the Management Studio and create the data model I would like to use
- Add data manually and via an ODBC connection (using a system wide DSN).
- Run SQL select commands against the added data.
So the infrastructure is up and running€¦.
Best regards,
Will Moonen
Hi, newbie here.
I have an sql express database on my local machine (xp sp2) with many tables populated with plenty of data.
How can i duplicate/replicate this database?
Seems like it should be a straight forward thing, but i guess not.
Thanks!
-Gary
Hi all,
I am doing a replication of a SQL Server 2005 database from one server to another server, everything worked fine. Now, when I added some fields to this database, the replication stopped. can I do replication of a schema of a SQL database? how? Should the replication work even if I add some fields.
Hi all ,
Can i get some help please on the replication of Database . I want to know if i can have two different types of Publications i.e Snapshot and Transactional on a single Database for different articles ?
I want to schedule two jobs for these two distribution at two different timings . The problem now is when i start exeuting a job for Transactional replication , my snapshot replication also starts . How can i avoid this situation ?
Can anybody help me with detiled stepps to resolve this problem ?
Thanking you all in advance .
Susan .
Does sql server have hot standby database? what are the pros and cons of using replication vs hot standby database? Thanks for helping me.
View 1 Replies View RelatedWhen setting up Replication in v. 6.5, a 'distribution' database is created, containing these tables:
MSjobs
MSjob_commands
MSjob_subscriptions
MSsubscriber_info
MSsubscriber_jobs
MSsubscriber_status
However, they cannot be accessed via the SQL Server Enterprise Manager interface like tables in other databases, at least I can't get to them. Is this a problem or a feature? I can query them to get their contents, but I'm wondering if there might be something wrong with my installation of SQL Server.
Any knowledge shared would be greatly appreciated.
Regards,
Karl Simanonok
Hi,
we tried to set up a replication from SQL Server 6.5 to
an Oracle database via ODBC but all our attempts failed.
Where can I find a description about this subject ?
Cheers
Rainer
as i know, sql server states it can replicate oracle data to sql server. other than sql server itself, can it replicate other kinds of database like informix or sybase?
View 5 Replies View RelatedWhen configuring snapshot replication of the OnePoint database used by MOM i am having the following error being reported in SQL Replication Monitor:
Command attempted:
CREATE TABLE "dbo"."Computer"(
"idComputer" "uniqueidentifier" ROWGUIDCOL NOT NULL,
"Name" "nvarchar"(255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
"Description" "nvarchar"(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
"CustomData1" "nvarchar"(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
"CustomData2" "nvarchar"(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
"Domain" "nvarchar"(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
"DNSName" "nvarchar"(512) COLLATE SQL_Latin1_General_CP1
(Transaction sequence number: 0x000004670002E32300BF00000002, Command ID: 375)
Error messages:
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fn_ComputerHeartbeat", or the name is ambiguous. (Source: MSSQLServer, Error number: 4121)
Get help: http://help/4121
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fn_ComputerHeartbeat", or the name is ambiguous. (Source: MSSQLServer, Error number: 4121)
Get help: http://help/4121
Unfortunately I can't find much help with this error.
Any suggestions?
After reading about it, i'm still confused. Is replication and database mirroring the same? they seem to accomplish the same thing.
View 3 Replies View Related
Hi,
I.m trying to find the best practice for my solution.
This is the situation.
My application has two databases and 2 client interface. One with a windows forms having a database (sql server 2000) running in an office (on a static IP but on a slow connection). the second one is an web application running on the net with an online database. Both these databases have to have same information. Users can add records to both databases independently but these databases should be synchronize at a point. I hope the situation is cleare. Is there a standard way of doing this. If some one knows good article of how this can be done pls forward it to me.
Many thanks.
-VJ
I'm working on an application for a client. The application is distributed to 100 mobile (SQLExpress SP2 w/ Advanced Services) users via the web, and uses merge replication to sync data back to corporate with Web Synchronization.
All of this works great. No problems at all.
The client now wishes to use the Reporting Services component of SQL to deploy reports, rather than building them into the application with Crystal Reports. The rationale is it will require less work (probably true to some degree) and it will make updates easier since each time they add a report, it will not require regenerating an entire binary image of the application for users to download.
Naturally, the client asks me if there is a way to use the same replication technology to simply build the reports in-house against an internal ReportServer database, and then replicate the contents of that database down to those 100 clients with the same merge replication -- except, making it a "one way" subscription, with no updates sent back to the server.
I'm wondering if anyone has attempted to do something along these lines.. Is it possible to use SQL Server replication technology to replicate the Reporting Services database down to mobile clients?
Or... is there some other mechanism I should be investigating that will allow me to deploy and update roughly 200 reports to 100 mobile clients on a regular basis?
Thoughts from other users would be appreciated.
I've tried using replication for the past few days, but have had no success. I have created a publication and subscription, have managed to pull the data down and build the local database, but when I do so, Reporting Services immediately breaks. I've even attempted to limit the data I pull down to simply the Catalog, Datasource, and Chunk tables (eliminating what appears to be the other tables that contain site-specific configuration data), with no success.
If anyone has tried something similar, or has managed a similar application, feedback would be appreciated.
-MD
Hello,
I was curious if you can have merge and/or snapshot replication setup on a MS sharepoint database? Thanks.
John
Not sure if this is the right forum, if wrong please point me some where else.
I have a legacy applicatioin using Access97 which relies on users being able to synchronise their data
I would like to move the current Synchronise in to c# Visual Studio 2005/8
is this possible?
if so what are the new methods called and how can I access them
There are two databases on two web servers, db01 is on server01, db01_replica is on server02, db02 is on server02, db02_replica is on server01. db01 and db02 are both for one system. Each time after doing performance test, I have to recover databses. I copy the data files in a folder, try to use detach and attach to recover databases. But with two replication dbs, I don't know how to do it. The replication db should also be recovered.
View 1 Replies View RelatedHi,
Before this, I've 2 difference site that run SQL server 2000 as database server. One at north and the other at west.
At north, I've a group of terminal that run SQL server 2000. I've 1 main server that run as publisher and distributor to all the terminal. And also the main database is at the main server. The terminal will replicate together using merge replication. So that the data would be same at all terminal. At west it also have the same scenario.
Last week my boss ask me to replicate both main server ( north and west ). So that he want the data would be same at all place.
So, can anybody help me.....
I am trying to delete a database that currently subscribes for replication. The problem however, is that the publishing server no longer exists and I can't disable the subscription therefore I can't drop the database. When I try to disable the replication the server tries to communicate with the old server. Is there anyway to force the dropping of the database or to force the server to disable replication.
thanks in advance
Michael
Do we need to disable replication to do a restore? Any help on this?
View 1 Replies View RelatedHello,
We are setting up Merge replication and size of the database is
85 GB. How much disk size is feasible to keep for distribution Database.
Is there any % basis (SIZE) for Distribution DB according to the size of the database?
Is it feasible to keep seperate server for Distribution Server or keeping
Publisher and distributor on same same.
Can any one help me!
Thanks!
I have a central server (CS1) with database CDB and a branch server (BR1)
Inside the branch server, there are two database DB1 and DB2.
CDB contains data for DB1 and DB2
I made a subscription in the brancserver named BR1:DB1(this will replicate the data from CDB to DB1)
I also made a subscription for DB2 named BR1:DB2(this will replicate the data from CDB to DB2)
Unfortunately, upon starting the synchronization for BR1:DB1, the data replicated into DB1 also contains data for DB2. same happens with the BR1:DB2..
How do I filter the data that will be replicate per database..Example:only data for DB1 coming from CDB should be replicated into DB1 if that specific subscription(BR1:DB1) is synchronized.
Thank you