This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

Insert / Add data into a Table

Question
0

Sign in to vote

Hi

I have 2 database both on SQL Server, both are having different application

S1 -- Server1 ,D1 -- Database1

S2 -- Server2 , D2 -- Database2

the user of D1 is using table T1 (customer table) he does insert, update on the table T1.

the user of D2 is using table T2 (customer table) doing insert ,update on the table T2.

WHAT I WANTED

assume on the start of the day Table T1 in the database is having 800 records and it is increased to 50 more records at the end of the day. What I wanted is 50 rows which are added today needs to transferred to the table T2 available in the database D2 at the end of the day, so that user of D2 can view the newly added data when he is starting on the next day.

Regards

Muthu

Friday, April 20, 2012 5:57 AM

Answers

0

Sign in to vote
If you want ONLY the new data replicated you can put the schema (tables) in place on d2, and then do a no sync subscription from the publication you create on t1.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Proposed as answer by amber zhang Monday, April 23, 2012 2:41 AM
- Marked as answer by amber zhang Friday, April 27, 2012 1:58 AM
Friday, April 20, 2012 1:03 PM

Answerer

All replies

0

Sign in to vote
can you keep a Date field in T1 with default value of today's date and check at end of day all those records which equals to today's date and Insert them into Table T2 in D2 database. You can schedule a SQL agent Job which will execute at end of day and Insert these records.

Kindly mark the reply as answer if they help
- Edited by Sunil Gure Friday, April 20, 2012 9:57 AM
Friday, April 20, 2012 9:56 AM
0

Sign in to vote
If you want ONLY the new data replicated you can put the schema (tables) in place on d2, and then do a no sync subscription from the publication you create on t1.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Proposed as answer by amber zhang Monday, April 23, 2012 2:41 AM
- Marked as answer by amber zhang Friday, April 27, 2012 1:58 AM
Friday, April 20, 2012 1:03 PM

Answerer