Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
manieverster
Starting Member
5 Posts |
 Posted - 2009-05-11 : 06:04:42
|
Hi there, I would like to know if anyone can help me creating a SSIS package to synchronise data in a table on two different databases. I have a website where members can login and capture data as well as an intranet that looks the same where admin clerks can capture this data for people without internet access. The two tables looks exactly the same. I have to admit that I do not have a clue where to start. Manie VersterDeveloper - SQL and ASP.Net |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-11 : 11:40:30
|
| will both the db tables change simultaneously, or is it that one is changing and effort is to make other same as this? |
 |
|
|
manieverster
Starting Member
5 Posts |
Posted - 2009-05-13 : 02:46:01
|
| Both db tables are changing. I want to schedule this to run once a day say at midnight. I know I haven't given much info so far but I really do not exactly know where to start.Manie VersterDeveloper - SQL and ASP.Net |
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-05-13 : 04:37:09
|
| Do you have a site identifier in the table? What is your primary key?Would need this to determine which rows to copy (check what's missing).Will the package have access to both databases? Firewall permitted? |
|
|
|
manieverster
Starting Member
5 Posts |
Posted - 2009-05-16 : 02:01:04
|
| Sorry guys, I will come back to this a bit later. After some consideration I decided that a first need to have a plan. I came here without a plan. As soon as I have that sorted out I will come ask this question again.Manie VersterDeveloper - SQL and ASP.Net |
|
|
|
|
|
|
SSIS Package