Replication Of Several Satellites Into One Central Db: Adding Location Key ?

Dec 6, 2005

Dear group,

i have the following setting:

satellite databases in different locations with the same structure (and
sometimes identical data) need to be replicated into one central
database. The databases hold information on machine results and
machines are numbered from 1 to n.

Results for machine 1 in location 1 should be entered in the central
database whereas results for machine 1 in location 2 should also be
entered.

Thus i would need a copy of the tables in the satellite database which
adds one column for "location id" (or something like that).

Is there an easy way to accomplish this ? Seems to me that the
replication scenarios in the "replication wizard" for SQL-Server miss
out this case.

Some hint at documentation or websites would be extremely helpful.

Thanks + Greetings from Vienna

Uli

View 1 Replies


ADVERTISEMENT

Replication :: Replicate All Data From Remote Locations To Central Location

Aug 29, 2015

there are several remote locations where sql is running, my company has asked me to find a way to collect all the data from the remote locations to a central location automatically,for example day to day data should be synced at night time from 2am to 7 am and it should be compressed automatically before data transfers to the central location. NOTE there is no domain only standalone workstations

View 3 Replies View Related

SQL 2012 :: Access To Central Backup Location

Dec 11, 2014

SQL Server service accounts; the default (and recommended) service account is NT ServiceMSSQLServer virtual service account - which is shown as MSSQLSERVER locally - if you want to assign permissions to a local location. Fine, that's OK, works.

For network resources, as far as I understand it (or think I do, anyway), a virtual service on a box is made visible to the network using the <Domain><Computer>$ credential. Eg for box Bimble on Domain Wimble - if I want to give access to a directory on backupServer1, I simply assign rights to WimbleBimble$ and SQL Server should get those rights.

This, or so I thought, should allow SQL Server access to that location. The thing is, when trying to access that location, it's throwing an access denied error. But it works fine with LocalSystem.

Do I need to do some additional configuration to allow the Virtual Service account to be shown via <Domain><Computer>$ ?

View 1 Replies View Related

Replication :: Replicate Multiple Databases (publications) To One Central Subscriber?

Sep 2, 2015

We need to replicate multiple databases (publications) to one central subscriber. The schema of those articles are identical in all publications and also the primary keys in publications do not have any overlap.

Is this possible?If yes is there any specific thing that I should consider for it's implementation? Should each publication has it's own dedicated distributor or all of them can share one distributor?

View 2 Replies View Related

Replication :: Replicate Data From 3 Publishers To A Single / Central Subscriber Transactionally?

Oct 15, 2015

Is it possible to replicate data from 3 publishers to a single/central subscriber transactionally? In other words I have Server A, Server B, Server C with databases A,B,C respectively. I need to replicate 2 articles from A,2 from B and 2 from C to a central Server D that hosts database D. D will have only 6 articles. The replication is Transactional Replication.

If it is possible what will be the drawbacks of such implementation? (if one server goes down will the whole replication break?) If not possible then what is the best way of implementing this?

View 3 Replies View Related

SQL 2012 :: Specify Server Installation Location When Adding Second Node To Cluster

Jun 6, 2014

When adding a node to a SQL Server 2012 Standard edition cluster, how I do I identify the location for SQL server shared components and the rest of the SQL Server installation binaries?

When adding a node to a SQL Server 2012 Standard edition cluster all the binaries went to the C: drive default location. We put those files on a different drive when installing the first node. What needs to be done so both nodes have the binaries on the same drives and folders?

View 3 Replies View Related

Adding New Table In Replication And Changing One Column Replication Database

Jan 17, 2002

Hi,

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

View 1 Replies View Related

Alternate Snapshot Location For Transactional Replication

Jun 2, 2006

Hi,
I have transactional replication setup with SQL 2000 on W2K3 cluster using updateable push subscribers. While setting up replication, we chose default location for snapshot folder that resides on non-clustered drive. Is there a way to change this location without disturbing current replication setup. I looked at the 'alternate snapshot location' solution, but it requires snapshot re-initialization. I am trying to do this with minimal effort and downtime.
Thanks,
np70

View 3 Replies View Related

Replication :: Change Snapshot Default Location

May 13, 2015

How to change the default snapshot folder (Merge Replication) location in SQL Server 2012 Standard Edition? Actually that field is grayed out.

View 3 Replies View Related

Adding New Article In Replication

Mar 27, 2008

how to add new article within the existing replication

View 1 Replies View Related

Adding Article To The Existing Replication

Feb 11, 2005

Hi All,

I am having a server where replication is set up between 2 differnt databases. It is currently running. I want to add a couple of tables to the replication. I tried using sp_addArticle, but after executing it, in the properties of the publication it shows the new tables, but at the database level the tables are missing.

I tried with sp_addsubscription but I am getting strange error:

Server: Msg 14100, Level 16, State 1, Procedure sp_addsubscription, Line 240
Specify all articles when subscribing to a publication using concurrent snapshot processing.


What can I do to publish the tables into the target database?

Thanks in advance.

View 5 Replies View Related

Adding New Fields To Transaction Replication.

May 19, 2006

I need help to add new fields in Transaction replication & also want to know how it will be replicated to Subscriber.

View 1 Replies View Related

Snapshot Replication - Adding Articles

Mar 4, 2004

Hey All - Another replication question:

Using VBScript in an ActiveX module of a DTS package...

Anyone have an idea how to add ALL articles to a Subscription.

The only way I can figure it is to load an array from sysobjects, then run sp_addarticle on each one.

Thanks for your help

RobbieD

View 2 Replies View Related

Adding Table In Merge Replication(urgent)

Dec 31, 2001

Hi everbody,

Anybody tell me how to add new table in merge replication using Enterprise manager or T-sql.

Thanks in advance

View 1 Replies View Related

Adding Push Subscription For Snapshot Replication

Jan 7, 2008

Hi all,

I've been looking for the right stored procedure to create a push subscription for publication but i haven't had much luck so far. So I was wondering if you guys know which SP is appropriate, that'd be super great!! thanks guys!

note. the sp should run on the subscriber database.

thanks again

View 2 Replies View Related

SQL 2012 :: Adding Article To Existing Transnational Replication?

Aug 5, 2014

In my local environment , i was setup transnational replication then i have added new article by using below script

EXEC sp_changepublication @publication = 'demo', @property =
N'allow_anonymous', @value='TRUE'
Go
EXEC sp_changepublication @publication = 'demo', @property =
N'immediate_sync', @value='TRUE'
EXEC sp_addarticle @publication = 'demo', @article ='employee',

[Code]....

But article not added and showing this error message The initial snapshot for article 'employee' is not yet available.

What is the issue, what can i do to add new article ? What did I mistake?

View 2 Replies View Related

Adding A 2nd Subscrber Makes My Merge Replication Blow Up.

Aug 25, 2006

I have two machines running SQL Express that I am attempting to use as proxies for a client application as the security admin has deemed that outside clients can not connect directly to the main DB servers.

When I have one of the SQL Express boxes subscribed to my SQL 2005 standard server, everything is happy, but when I attempt to add the second SQL Express box as a subscriber, everything seems to blow up.

OK, I'm setup as a merge with updates and no filter since I want all of the servers to get all of the data. I'm also on a non-standard port but have my aliases setup, and I don't have any connection issues. When I run the subscription wizard from the management studio, it comes back with "Success", but about 2 seconds later, I get errors on both subscribers from the replication monitor. Oh, I am aslo setup for push subscriptions and am setup to run continuously.

Here is the error message from the rep. monitor.

Error messages:


No subscription is on this publication or article. (Source: MSSQLServer, Error number: 14050)
Get help: http://help/14050

The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001

What I find odd is that It only dies when I try to add a second subscriber, and then it kills both of them. Any help or ideas on where I should look would be most welcome.



Thanks!





View 4 Replies View Related

SQL 2012 :: Adding Articles To Existing Publication In Transactional Replication

Sep 26, 2014

I have an existing publication in sql 2012 with 2 articles, and then I add 2 more articles. After that when I generate a snapshot, will the snapshot be generated for 2 new articles only or for all 4 articles?

I remember adding 1 new articles to one existing publication with 150 articles and when I generated snapshot, it was generated only for 1 article. But I don't remember clearly.

Does it behave differently for small and large number of articles?

-----Table Proc Index Performance TSQL &&%$#@*(#@$%.......------------

View 0 Replies View Related

Central Database

Nov 1, 2007

Hi I would like to use SQL Express as a central database in a project but I have few things in my mind needs to be answered.

I need to create a parts table and when a user opens a part in the client application no other user should be able to modify that part info. Is this taken care by database or should I use a flag in the parts table which indicates particular part is opened and in use?

If a row (a part) in part table is read by a client how this effects the other related tables? For instance if I open part1 info in my client application and also accessed to part1 properties in another table, how can I prevent other clients to make modification in related tables related rows?


What is the best way for submiting an image for a part in part table? I dont want to store images in the database. Do I need some file transfer code which takes care of transferring image and returns the path to the database?

Thanks

View 7 Replies View Related

[SQL] Central European Encoding

Mar 5, 2008

Hello,I faced a problem while reading some strings from the database (SQL 2005). Some letters are encoded with html codes making the sorting really difficult. I tried to use IComparer objects with different CultureInfo information, but it doesn't do any good.I am quite new to the web development, so I don't really have any clue if there is a recommended and clean way of solving this problem. It could be that it's something really simple, but I only came up with an idea of search and replace in all strings. If possible, I would like to omit this. :) If not, please let me know.Thanks in advance. 

View 1 Replies View Related

SSIS Central Server?

Sep 20, 2007

We have about 150 SQL servers and basically we're considering the pros and cons of installing SSIS on a central SSIS server - that is responsible for all DTS jobs - as opposed to installing SSIS on the local SQL instance.



On the plus side so far:



1./ Central administration, alerting, change management etc

2./ Possible performance gain on the local instance not having SSIS installed?



On the negative side:



1./ Central point of failure

2./ Possibility that it would need to be a clustered...

3./ Compatibility issues may mean having to make the central SSIS server 32-bit?

4./ Possible performance cost of remote SSIS?

5./ With multiple DTS packages running at different times, when would we take the server down for maintenace...?

Would appreciate your thoughts.

View 7 Replies View Related

Multiple Database And Central Libraries

Jan 5, 2005

I have a question about MS sql 2000 and hope someone can give me a hand though this may not be the most suitable place to post.

I have created multiple databases storing multi-country data. Tables and store proc in each db are exactly the same except they are placed and run in different dbs in runtime.

My question is:
Is it possible to centralize all the store proc and function into a central db (or a dummy db) for easy maintenance but it allows us to point to the desired database environment in runtime even I run the store proc in central database.

I find the "Use database" command but it does allow us to use it in store proc. Any advice or suggestions???

Thanks in advance
bryan

View 4 Replies View Related

Central Store Of SQL Server Registration

Nov 7, 2000

I am attempting to centrally register all of my sql server so I can go to any workstation and open enterprise manager and select to read the sql server registration from the remote server.

I followed all of the steps in books on line about going to the central server, turning off the store/user independent option, registering all of the servers and then going to a workstation and selecting the option to read from the central server.

I get error messages like registry read error: 5 and registry read error: 2

This is getting frustrating because we have a lot of servers in our environment and re-registering them everytime is getting to be quite a pain. If the central store will not work, is there a way to write a script to register all servers in an enterprise.

Thanks,

PJ

View 2 Replies View Related

Problem With Central Subscriber Model

Apr 26, 2007

Hi,



I am trying to acheive the central subscriber model for Sql server 2005 replication. I have two publishers and the centrol subscriber. Both publishers are Sql server 2005 Workgroup edition. The following table shows the Software I have used for the test.









SQL version

Service pack

HotFix


Publishers

SQL Server 2005 Workgroup edition

2

1


Subscriber

SQL Server 2005 Enterprise edition

2

1

I have encountered an obstacle in the replication process to achieve the Central subscriber model. I have configuration table, It exists on servers TB1 and TB2 and want to amalgamate the data to a central subscriber. There are two duplicate primary key and overlapping values existing across the 2 publisher tables. These records need to be updated during the process of replication.

TB1

Guid Name CreatDate EditDate
34a.. TEST02F 3/6/2007 3/6/2007
775.. EP109F 1/29/2007 1/29/2007
ffe.. EP109G 1/26/2007 1/26/2007

TB2
Guid Name CreatDate EditDate
d008.. MS060F 7/20/2005 11/21/2006
775.. EP109F 1/29/2007 1/29/2007
ffe.. EP109G 1/26/2007 1/26/2007

Normally, the default Article properties settings are used 'DROP existing table and re-create it', however here we don't want this setting, because the one table records will then be removed, leaving just the data from the other table. So, we modify the article properties on the snapshot tab to 'Keep the existing table unchanged'€™. As result we got the PK violation error.

I have tried using -SkipError option in distribution job Replication Agent Profiles, that did not work.



Thank you for your help





View 2 Replies View Related

Updating Central Database Over The Internet

Jul 21, 2006

Hi, I've spend quite a bit of time on this but no luck. so any help is really appreciated.

I'm writing a class library dll that would pull data from a central db to offsite comps, manipulated then updated it back to the central db, much like systems salemen would use. Please keep in mind that i'm talk about LARGE amount of data. I want downloaded data to be manipulated on the client computer(without direction connection to db server) with EXCEL or something of the likes then upload changes back to the central DB.

Is there anything in SQL Integration Services that would help me? please keep in mind that data are distributed to computers over the internet, not on the same LAN. Please be as specific as possible

i'd really appreciate any help you guys can provide, thanks.

Vu,

View 4 Replies View Related

Central Store For Server Registration Information

Jun 26, 2001

Has anyone had any luck trying to use a central store for server registration information? I'm following the steps but it doesn't seem to work.

I receive the following error: The Server Registration Information could not be loaded - Registry read error:2

Any help is appreciated.

View 1 Replies View Related

Report Service Not Showing Up In WSS 3.0 Central Admin

Jan 16, 2007

I installed the Reporting Service for Share Point just fine but when I go to central admin I do not see the reporting service section. Any Ideas?

View 4 Replies View Related

Reporting Services Not Showing In Central Admin

Mar 7, 2007

I downloaded and installed SQL Server 2005 SP2 update on my reporting services server. I think downloaded and installed the share point reporting services admin to my share point dev server. I open up the central administration and there is no reporting services menu option under the Application menu. The sharepoint server is a farm with backend database on one server and all the web apps on the other (where the add-in was installed). The reporting server is a separate server running its own instance of SQL 2005.

Am I missing something with this setup?

View 1 Replies View Related

SP2 Integration Mode Kills Sharepoint Central Administration

Feb 27, 2007

Hi

I had the following setup:

Farm Server 1
* Sharepoint 2007 full install

Farm Server 2
* SQL Server 2005

I installed the following:
* SP2 for SQL Server 2005 on Server 2
* Web-front end install of Sharepoint 2007 on Server 2 - to install the object model
* SSRS2005 reporting services add-in for Sharepoint technologies on Server 2

Since doing that, I can no longer get to central administration on Server 1 - I now get the following error when navigating to central admin:


Server Error in '/' Application.


Runtime Error Description:
An application error occurred on the server. The current custom error
settings for this application prevent the details of the application error from
being viewed remotely (for security reasons). It could, however, be viewed by
browsers running on the local server machine.

Which web.config do I have to edit to get the full error to show, and has anyone else experienced this?

This happened to me when my servers were fully configured and had data - so I rebuilt them from scratch and the same problem occured again!

Adam

View 8 Replies View Related

SQL 2012 :: Retrieve Job History For All The Jobs Using Central Management Server?

Apr 2, 2015

Is there anyway we could retrieve the job history for all the jobs in all the sql server using Central Management Server?

View 0 Replies View Related

DB Design :: Moving All SC Databases From Their Respective Application Servers To A Central One?

May 18, 2015

We are planning to move all of our System Center Databases that reside on front end servers to each system center application to a centrally located SQL 2012 server. We'd like to centralize everything and have our DBA care for the server. here is our setup:

SCOM has 1 monitoring and 1 Data warehouse server. SCCM has 1 server with all roles on it. DPM database is on the same server as Application. Same with SCVMM. I have 2 questions regarding this move:

1. Can I have all these databases running on 1 SQL instance?

2. Is there a best practice document that highlights steps and "gotchyas"

View 4 Replies View Related

Consolidation - Changing Replicated Data In A Central Subscribing Site

Sep 25, 2006

Hi all,

I am new to replication and have a few questions.

1) Are there any "hooks" available to insert processing when a subscriber is about to copy data from a replicating site?

2) Is it possible for a subscriber to change only his local copy of the data - without replicating the changes back to the publisher?

I realise that once the data changes in one place it isn't really replicated anymore, and I realise that my limited knowledge of the subject might well mean I'm not even asking the right questions. Therefore, I shall try to describe as best I can my scenario.

I wish to use many servers for transactional input (to distribute the workload) and use replication to publish the inputted data to a subscribing central site. One of the tables I wish to replicate has an identity column as primary key, but the records should otherwise be unique - i.e. no two records should differ only in the value of the key. Another table, which should also be replicated, uses this id value as a foreign key.

I can use the identity increment and seed to guarantee no key violations will occur when copying data to the central server. However, there is another issue: Several servers can create the same record but with different id values.

I need to "merge" such records by deleting duplicate entries in the table with the identifier as primary key, and update the foreign keys correspondingly. To clarify (I hope!), here's an example of what data I might have on the central site after copying data from two input sites:

TRANSACTION table

amount = 200, metadata_id = 1001 // Replicated from server INPUT_1

amount = -117, metadata_id = 2001 // Replicated from server INPUT_2

METADATA table:

id=1001 Actitiy=Sales, Country=USA

id=2001 Activity=Sales, Country=USA

What I would like is basically for the central site to identify that metadata 2001 is really the same as metadata 1001, update the foreign key in the TRANSACTION record accordingly and not import (or delete, if this "merging" is done in a post-treatment) the duplicate metadata record.

If anyone can offer any advice on how to achieve this I would appreciate your input.

View 3 Replies View Related

Central Management Server Doesn't Support Multi Domains

Jun 4, 2015

As CM doesn't support SQL authentication, and if access SQL Server on another domain with no trust, we cannot use Windows authentication as well.

CM only supports Windows authentication, but for large organizations which will have multi domains...

View 2 Replies View Related







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