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 |
|
kamalkishore_in
Yak Posting Veteran
76 Posts |
 Posted - 2002-09-29 : 22:26:48
|
| Hi,I am using SQL Server 2000, Visual Basic and I need the best wayout for the situation below.I have a Main Server Installed in the Main Branch, and 17 other Server installed in different states all over country. All are connected through Internet using Golbal IP addresses.What all I need is on a perticular condition I wants to send Some of the tables from Main Server to all the 17 Branch Servers. After successfully sending the tables, I have to genreate the report also.What are the best possible solution for the situation. Expecting solutions.... |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2002-09-29 : 22:29:46
|
| DTSExpecting thanks......DavidM"SQL-3 is an abomination.." |
 |
|
|
kamalkishore_in
Yak Posting Veteran
76 Posts |
Posted - 2002-09-30 : 01:32:48
|
| Oukey.... guys.. Thanks in Advance...Please go ahead with your suggesstions... |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-09-30 : 01:58:25
|
David actually hit the answer as well as the manners lesson  DTS is the way to go. Set up a DTS package to copy data to each location.Damian |
|
|
|
kamalkishore_in
Yak Posting Veteran
76 Posts |
Posted - 2002-09-30 : 03:26:08
|
| Hi again...Got it.. DTS is the fastest solution for that. One more thing... Is it possible to run a DTS package on NOT only on time based but I also on some conditoin. Actually I need to check weather the table has been changed. Then only it is worth to send tables to the other servers.You any step towards the solution is heighly appriciated..thanks a lot |
|
|
|
davy_boy2000
Starting Member
28 Posts |
Posted - 2002-09-30 : 06:10:43
|
| You could create triggers on the table, that when an insert or update occurs, then the dts package is executed. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-30 : 06:44:15
|
| You might also look at DMO to do this to save implementing dts packages.Example of DMO for object transfer atwww.nigelrivett.comDMO transferYou don't need to set all the parameters.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
rayd
Starting Member
2 Posts |
Posted - 2002-10-01 : 15:22:05
|
| When you say when the table has been changed, you mean the structure or the data? I'm thinking you could replicate them here. |
|
|
|
|
|
|
I have a situation here