Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sample about take last databackup(data only)in small size

Status
Not open for further replies.

vpn2012

Instructor
Jan 8, 2012
31
0
0
I have three database branches in another places but all same structure and tables every thing( A,B,C) what I need is to take every update in databases A,C then put in B

EXAMPLE
Database A:
Employee Table
ID:
Name:
ID Name
12 Ahmed
24 Mohamed
36 Islam

Database B:
Employee Table
ID:
Name:
ID Name
1 Michel
2 Ali
3 Mahmud

Database C:
Employee Table
ID:
Name:
ID Name
11 Nasser
21 Said
31 Sahel
This is daily backup
That I need according to example add extra data that make every day to database B
After updated

Database B:
Employee Table
ID:
Name:
ID Name
1 Michel
2 Ali
3 Mahmud
11 Nasser
21 Said
31 Sahel
12 Ahmed
24 Mohamed
36 Islam
And if any extra data in next day made in A, C Transfer only data that changed or updated in this day to database B
Are you having any solution to solve the problem?
Thanks







 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top