MS SQL Server :: Synchronize Data Between Servers

How To Synchronize 2 Tables On Different Sql Servers

Jul 23, 2005

Hi, anybody can help me.How can i synchronize 2 tables on 2 different sql servers 2000i mean TABLE1(col1, col2, col3, col4) andTABLE1(col1, col2, col3, col4, col5, col6)the first 3 colums are the same in rwo tables.Thanks--Message posted via http://www.sqlmonster.com

View 6 Replies View Related

Synchronize 2 Databases On Different Servers

Apr 10, 2006

Hi,

I was wondering if the following is possible: I have 2 SQL Express servers on different machines. One holds the production and one the development database. On a request basis I'd like mirror all the data of the production database to the development database. Right now I have to stop the sql engine, zip the mdf, send it over, attach it to database, etc. and that's quite cumbersome. So, is there an easier way to do this? If not with SQL Express, is it possible with the full version?

Thanks,

Tom

View 1 Replies View Related

Synchronize The Sysxlogins Between Two SQL2000 Servers

Feb 18, 2002

Hi,

I have tried to synchronize master..sysxlogins table from production server to
a testing server. All the databases in the testing server will be loaded from the production server. In order to save drop and recreate the database's users in every database restore, I have tried to find out a quick way to synchronize the sysxlogins table. However, when I load the sysxlogins from the production server onto the tempdb in the testing server, I get the following error :

Server: Msg 213, Level 16, State 5, Line 1
Insert Error: Column name or number of supplied values does not match table definition.

Any comment and suggestion is highly appreciated.
Thanks

The table structures (output of sp_help) of the temporary table and master..sysxlogins are as follows :

1. sp_help testjoe4

Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- ---------------------------
testjoe4 dbo user table 2002-02-19 15:27:31.930

Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
srvid smallint no 2 5 0 yes (n/a) (n/a) NULL
sid varbinary no 85 yes no no NULL
xstatus smallint no 2 5 0 no (n/a) (n/a) NULL
xdate1 datetime no 8 no (n/a) (n/a) NULL
xdate2 datetime no 8 no (n/a) (n/a) NULL
name sysname no 256 yes (n/a) (n/a) SQL_Latin1_General_Pref_CP1_CI_AS
password varbinary no 256 yes no no NULL
dbid smallint no 2 5 0 no (n/a) (n/a) NULL
language sysname no 256 yes (n/a) (n/a) SQL_Latin1_General_Pref_CP1_CI_AS
isrpcinmap smallint no 2 5 0 yes (n/a) (n/a) NULL
ishqoutmap smallint no 2 5 0 yes (n/a) (n/a) NULL
selfoutmap smallint no 2 5 0 yes (n/a) (n/a) NULL

Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------- ---------------------------------------- -------------------
No identity column defined. NULL NULL NULL

RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.

Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY

The object does not have any indexes.

No constraints have been defined for this object.

No foreign keys reference this table.
No views with schema binding reference this table.

2. sp_help master..sysxlogins

Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- ---------------------------
sysxlogins dbo system table 2000-08-06 01:29:12.500

Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
srvid smallint no 2 5 0 yes (n/a) (n/a) NULL
sid varbinary no 85 yes no no NULL
xstatus smallint no 2 5 0 no (n/a) (n/a) NULL
xdate1 datetime no 8 no (n/a) (n/a) NULL
xdate2 datetime no 8 no (n/a) (n/a) NULL
name sysname no 256 yes (n/a) (n/a) SQL_Latin1_General_Pref_CP1_CI_AS
password varbinary no 256 yes no no NULL
dbid smallint no 2 5 0 no (n/a) (n/a) NULL
language sysname no 256 yes (n/a) (n/a) SQL_Latin1_General_Pref_CP1_CI_AS
isrpcinmap smallint yes 2 5 0 yes (n/a) (n/a) NULL
ishqoutmap smallint yes 2 5 0 yes (n/a) (n/a) NULL
selfoutmap smallint yes 2 5 0 yes (n/a) (n/a) NULL

Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------- ---------------------------------------- -------------------
No identity column defined. NULL NULL NULL

RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.

Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY

index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ncsysxlogins nonclustered located on PRIMARY srvid, sid
sysxlogins clustered, unique located on PRIMARY srvid, name, sid

No constraints have been defined for this object.

No foreign keys reference this table.
Table is referenced by views
--------------------------------------------------------------------------------------------------------------------------------

View 1 Replies View Related

Synchronize Data Via GPRS???

Apr 29, 2005

I made application (using .NET) to transfer data using PDA via GPRS and
then upload data to database server. The data not update old data but make
new insert new data to database server.

If we use USB to synchronize data from PDA to database server, we can use merge
replication. But i still confused how to synchronize data, if we transfer data from
PDA via GPRS, then insert to database server???

Regards

Agus Ilmi

View 1 Replies View Related

Synchronize Data Via GPRS???

Apr 29, 2005

I made application (using .NET) to transfer data using PDA via GPRS and
then upload data to database server. The data not update old data but make
new insert new data to database server.

If we use USB to synchronize data from PDA to database server, we can use merge
replication. But i still confused how to synchronize data, if we transfer data from
PDA via GPRS, then insert to database server???

Regards

Agus Ilmi

View 1 Replies View Related

Synchronize Chart With Report Data

Mar 20, 2007

Hi,

How do i change chart data on click of drilldown in ssrs 2005 .

If any one know please help....

View 1 Replies View Related

Merge Synchronization Does Not Synchronize The Data

Feb 21, 2007

Hi!

I've the following replication topology:

SrvA (Publisher/Distributor) -> (Transactional Publication/Push Synchronization) -> SrvB (Subscriber, Publisher/Distributor) -> (Merge Publication/Pull Synchronization via HTTPS for remote clients) -> Client (Anonymous Subscriber)

To test synchronization with this tier I do the following:

1. Update data on SrvA

2. Push changes to SrvB (there are transactions that replicated)

3. Run RMO Merge Agent (.NET application) on Client and get messsage "No data needed to be merged", although there were changes made on publisher SrvA and SrvB

I saw the thread where similar problem have been discussed (http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=664153&SiteID=17). The sugestion there was to create subscription using wizard rather then T-SQL script. But all my clients are remote and have only HTTPS connection to the IIS over 443. And in the MSDN there was the script that I used to create pull subscription for web synchronization.

Guys, HELP! I almost gave up - do not see the reason for the case in the documentation, settings and code.

Thank you.

Alexander.

View 5 Replies View Related

Data Synchronize For 2 Diff Db, Need Advise.

Dec 30, 2007

Hi all.
I have a client that request his system's db to be installed at his HQ, and another db installed at webhosting company. And he want both data to have the same data, and the db at the HQ will act as a backup.
I could not modify the code to save data at both db, this is because there will be a huge modification.
And this is the first time that I deal with data synchronize, so I need advise on this issue.
All advise will be must appreciated, thank in advance.

View 5 Replies View Related

Synchronize Data Between Sql Mobile Db And Sql Server Db, Over Gprs

May 30, 2008

Hello!

I don't know if this question belong to sql forum or smart device forum.

So far i was able to sync data between pda and the sql server pc, over a wi-fi LAN using Remote Data Access.

Now i want to do the same but without using the wifi LAN, i mean, i want to be able to over a gprs connection, do the same data synchronization.

My main question is how to get access to the sql server database ? My connection string (obviously) only works in LAN.

My doubt is how can i access my sql server database data ?

I need some help over here, i really don't know how can i overcome my current problem.

Thank you

View 9 Replies View Related

Windows CE 5.0 Divice To My SQL Server 2005 Database And Synchronize The Data.

May 12, 2008

Can any one tell me

==> How can i connect my windows CE 5.0 divice to my SQL server 2005 database and synchronize the data.

==> i have tried using activesync 4.5. i am able to make the connection trough the activesync but it does not synchronize the data files.

==> what if i want to connect to the database from windows CE 5.0 divice.

Thanx

Harpreet

View 4 Replies View Related

Data Transfer Between Two Or More SQL SERVERS

Dec 8, 2006

Hello,
I want to transfer data in between two or more sql servers. Actually One server is on the web while others are in small networks in diffrent locations.
I want to update the main server with the changes in local servers. My problem is if the connection goes failed in between process of data transfer then how will it be recovered that how much of data is uploaded and how much is left.
Please I need help on this isue.
Thanks in advance
pronov

View 1 Replies View Related

Getting Data From Remote Servers

Jun 20, 2007

am an authenticated user of a remote data base
I can log in using sql server management studio and add tables and
even I can back up the database .
Good.

But I want to get a copy of the
database to my local computer
Is there any way to do
this?The problem is that i don't have access to the directory of sql sever pleases tel me a way that is possible just by using sql server or any add on on it

View 7 Replies View Related

Data Access Across Servers

Aug 27, 1999

Hello,
I have a developer here who wants to be able to access two databases on different servers with the same query statement.
Both servers have SQL Server 7.0 ??? Any suggesstions?

Joanna

View 1 Replies View Related

How To Query Data From To Servers

Aug 25, 2000

hi,
I have a question. how do query data between the two servers.
thanks
kumar

View 2 Replies View Related

Replicating Data Across Servers

Jun 17, 1999

We have a database that I would like to replicate on another server but am unable to use regular replication via publish/subscribe due to the fact that the production database has no primary keys on tables, only clustered indexes. The backup db needs to be as close to real-time synchronized as possible and will be in fairly active use most of the time. Has anyone had success in developing such a system? How did you do it and what are the pitfalls? Any advice would be greatly appreciated. Thank you.
W.

View 1 Replies View Related

Accessing Data Across 6.5 Servers

Jun 22, 1999

Hi,

I need to access data across my sql servers . All the servers are 6.5. Think MS DTC is the solution. But how to implement the same. Can somebody give me step by step instructions.

Thanks in Advance.

Cheers

View 1 Replies View Related

Transfer Data Across Servers

Apr 1, 2008

Hi,

Not sure thisis the right forum for my question.
I have to insert data from one table into another. The problem is that the 2 tables are on different servers and computers for that matter. I only need data that is in one specific table.
What is the easiest and most efficient way to do that.

If I access the 2 computers via remote desktop from my computer and actually go and copy the data from the table in computer 1 and paste it inside the table in computer 2 it does paste the data.However, for some reason it doesn't paste all the data. The column datatype is ntext.
I mean if the entry is for example 'hello world how are you today? blah bla blah'
It will only paste 'hello world how are'

I will appreciate your help.

Many thanks

Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.

View 4 Replies View Related

View Data From 2 Servers

Apr 6, 2006

Guys,

How do I create a view that will pull data from dbases on 2 different servers ?

I have 2 server names....

svr10mbr01
svr11mbr02

2 Databases...

PWBstaff on svr10mbr01
PWBdata on svr10mbr02

I need to create a view in PWBdata that will do something like....

Select * from PWBstaff.dbo.staff

Is this possible, if so what is the syntax.

Ta
Bob

"I dislilke 7am. If &am were a person, I would kick 7am in the biscuits." - Paul Ryan, dailyramblings.com

View 3 Replies View Related

Transfer Data Between SQL Servers

Sep 20, 2006

Hi,

I've got a quick question here. I'm still quite new to SQL Server. My question is how to transfer file between SQL Servers. For example, i have been working on the database - updating or editing some tables in the SQL Server 2000 at my end. Then, i need to pass whichever tables got updated on to my client who also uses the SQL Server 2000. So we have two separate SQL Servers 2000. i wonder how to transfer data like tables between the two SQL Servers.

Thank you in advance

View 2 Replies View Related

Data Collection From Many To One Servers

Mar 7, 2008

I need to feed head office sql server with the data from regional servers. Servers are spread through all continents
Data input done locally on Head office server as well and plus need to ship data from other servers.
So clarify this - Head office server is not standby one. Mirroring is out of the picture, I think..
Initially, I thought ship a log every 15 min and restore on Head office server but is this going to create an issue for the local data processing?

Any bright ideas welcome!

View 2 Replies View Related

Transferring Data Between Servers

May 14, 2006

I need to append data from a database on one server to a table in a databaseon a different server. Both servers are running SQL 7. How can that be done?Thanks.

View 2 Replies View Related

Sync Data Between Two SQL Servers

Jul 20, 2005

Ok..here is my problem. I have two SQL servers that I need to haveidentical, at least semi-real time data on. One is in a public DMZwith full access to and from the internet, and one is behind acorporate firewall and the box can get out to the internet but cannotbe hit directly from the internet in. The two are on seperatenetworks and cannot be connected via lan. Is there a way for me tohave semi-real time data transfers between the two to keep bothservers identical? I have thought that the server behind the firewallcould initiate an XML session with my dmz sql server and processupdates, but I am unfamiliar with how it would know what has changedon the remote server and how the remote server would know what haschanged on the server behind the corporate firewall. Any good ideas?ThanksDan Hirsch

View 3 Replies View Related

Exchange Data Between Databases On Two Servers??

May 29, 2007

Dear all

I have tow server on the same intranet. One server has a sql server 2000 database and the other one has SQL server 2005 databse.
The sql 2000 database has a table called employee. When ever a new employee is inserted in the database i would like the same values to be sent to the sql 2005 database. But this cant be done on the application level. It has to be done in the database. The application level can not be changed.
I was thinking a trigger but how to achieve the writing from one database to another. If they were on the same server then it would be easier but because they are on different servers i dont know how to do it.
Has anyone had similar issue before?
Any help is apreciated.

Sincerely
Dan

View 2 Replies View Related

Select Data From Two Databases On Different Servers

Oct 27, 1999

Hi there,
I was just wondering is it possible to select data from two different databases on two different servers?

ie Select * from
Server1.databasename..table, Server2.databasename..table

If anyone has any suggestions they would be appreciated,
Thanks,
Fin

View 2 Replies View Related

Transfer Data Between Linked Servers

Nov 12, 2004

Hello to all,

my problem is about the slow execution of a query.

I have two database located in two different servers. The servers are linked with the linked server connection made with the enterprice manager.

The databases structure is the same and I copy some data from a database to the other with the following query:

INSERT INTO DATASERVER.RESULTS.dbo.Tab_Tests SELECT * FROM LINESERVER.WIP.dbo.Tab_Tests WHERE ID_Result = '{76271FC1-9470-4EF7-A403-000CF75C2215}' OR ID_Result = '{08C8EEB9-CD22-4CF9-8269-8C1CC58C752B}' OR ID_Result = '{B7B7EED1-36E4-48FA-9636-ABBE62AAE04D}' OR ID_Result = '{8F7BA69E-D2CE-4EB2-BBC4-AFFA165CE0CE}' OR ID_Result = '{273CB805-945F-4EFA-AE20-BC4E0898A19F}'

Everything works till the database grows up more than 400 MB.

Also if I select one result, that consist of some records, the query is very slow and the CPU is working over the 75 %.

I ask you if my working way is corret or if you have some solution or some explanation for me.

Thank you

View 1 Replies View Related

Transfer Data Between Two Remote Servers

Sep 26, 2005

Hi, I'm looking for an artical or Someone who can explain me what is the best way to transfer data between two remot database?

I'll Explane:
two business have local SqlServer in their office.
1 of business need to get Specific data from other. each database is protected. how can I read ake information of it?

Thanks.

View 5 Replies View Related

SQL Express Data On Web Servers - Will It Work?

Jul 7, 2007

I am preparing a new website that will contain names, address and phone numbers of people in my region of Costa Rica. Will I be able to post a database prepared in Visual Basic 2005 Express / SQL Server 2005 Express on the website's MySQL Server and utilize the data to populate webpages?

If not, what should I use to prepare the database and drive the webpage.

New to SQL and VB
Don Johnson
Latitude 8 Lodge
Costa Rica

View 2 Replies View Related

Moving Data Tables Between SQL Servers

Jul 20, 2005

I have user that we just migrated his Access database to SQLServer. All went well with the migration, but then he came up withanother requirement to be able to replicate the database to a localSQL server living on the hard drive of a laptop. Before the migrationhe just copied the entire Access databse to the lap top.I tried using the Copy SQL Server Objects Task to move thenecessary tables from the production server to the laptop, but noticedit doesn't copy over the table Indexes/keys identiy fields etc. Iended up backing up the production database and restoring it to thelaptop database, but wondered if there is any way to move the tables,with their properties from one server to another? I know I can setup the backup process to run as scheduled, but the problem is the dataneeds to be moved on an irregular time table. I thought about justwriting code on the remaining Access front end to empty the localtables and then query the data from the production side to reloadthem, but I'm sure there's an easier way.Any suggestions would be appreciated.Thanks,Tom

View 1 Replies View Related

Need To Push Data To Several Servers In Parallel

Jul 25, 2007

I'm working on an SSIS package whose job it is to push data from x # of tables to x# of servers. Right now, I have it implemented with nested ForEach loops. ForEach Server loop inside of a ForEach table loop. It works great, but it will take too long as it is serial. I need a way for the inner operation to take place in parallel. In SQL 2000, the way I 'm doing this is by spawning a SQLAgent job per server. I could always do this here as well, but I'm interested in finding out if there is a way to do this with a single package.

I'm okay with process the table serially, but for each table I'd like to be able to parallel the push to the servers. Can't do it with multiple data flows because there are N # of servers being pushed to.

Hope that makes sense.

View 1 Replies View Related

Binary Data On Multiple Servers

Feb 18, 2007

I'm using EncryptByKey to encrypt data in my SS2005 database. Since our server is really slow to access from home to work on, I used the Database Publishing Wizard and installed the db to work on at home. Then I created the certificate and symmetric key in my home db.

When I pull info using the DecryptByKey on our database at work on Windows 2003 Server, no problem, the data is decrypted. However, the same data does not decrypt at home on my Windows XP computer. I'm using TripleDes on both machines for the symmetric key (AES won't work on XP).

--To create my cert and key:

USE My_DB;
CREATE CERTIFICATE MyCert
ENCRYPTION BY PASSWORD = 'some password'
WITH SUBJECT = My Data',
START_DATE = '01/01/2007',
EXPIRY_DATE = '01/01/2099';
GO

CREATE SYMMETRIC KEY MyKey WITH ALGORITHM = TRIPLE_DES
ENCRYPTION BY CERTIFICATE MyCert;
GO

To encrypt:

OPEN SYMMETRIC KEY MyKey

DECRYPTION BY CERTIFICATE MyCert

WITH PASSWORD = 'same password as above';

Insert my record, use scope_identity to return primary key into @CustomerID.

INSERT INTO [Customers] (EncryptByKey(Key_GUID('MyKey'), @DataToEncrypt, 1, CONVERT( varbinary, @CustomerID)))

CLOSE SYMMETRIC KEY MyKey

To decrypt:

SELECT CONVERT(varchar(3925), DecryptByKey(EncryptedField, 1, CONVERT( varbinary, @CustomerID))) as PlainTextData

FROM Customers

WHERE (CustomerID= @CustomerID)

Everything works fine when I run the decrypt query on the database on our work server. But I'm not getting decrypted data at home. Is the symmetric key or certificate machine specific? If so, that will cause a huge problem when we deploy to a production server.

Thanks in advance for your help!

View 5 Replies View Related

Getting Meta-data For Linked Servers

Oct 25, 2006

My customer has a .NET application that reads meta data from SQL Server, Oracle, DB2, and several propritary databases. Because each DBMS stores the meta data using various techniques, they have written custom code for each DBMS. They are working on a generic ODBC/OLEDB suppport, but in the interim I was trying to use SQL Server to link to an Access database. The Access linked server works fine for queries in Query Analyzer, but I would like to be able to programatically read the metadata for an Access DB (tables, columns, types, etc) via the linked server. SQL Server's usual mechanism for storing meta-data in the Master database aparently is not used for Linked Servers.

Does SQL Server expose Linked Server meta data?
How would one retrieve this meta data if it is exposed?

Thanks,

Ben

View 3 Replies View Related

Copy Data And Objects Between SQL Servers

Mar 23, 2006

I have recently moved from a Microsoft SQL Server 2000 to a SQL Server
2005.

In the good old Enterprise Manager, when I imported a table from a SQL
server to another, I could choose "Copy objects and data between SQL
Server
databases". When choosen, all primary keys, and default values was
copied.

My question is:
Is it possible to do the same in Microsoft SQL Server Management Studio
with
SQL Server 2005? And how do I do it?

I have tried using the "SELECT * INTO NewTable FROM OldTable"
statement, but
it just drops all information about primary keys and default values.

Best Regards

View 1 Replies View Related