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 |
|
Flaterik
Starting Member
26 Posts |
 Posted - 2011-11-18 : 04:45:24
|
| Hi People,i have a great doubt.I have a SQL SERVER 2008 R2 with one database and some data.I have another SQL SERVER 2008 R2 that have no data and in another place (with another IP Address not in the domain)I want to put some data from the Database in my domain to the other database. But i want real time synchronized data.I must select only few data , not all the database.The better solution?************************************************the world is strange but people are crazy |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-11-18 : 05:28:23
|
| What do you mean by real time? What sort of latency can you have? What sort of connection can you have between them, how much data do you need to transfer and how quickly can you transfer data?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Flaterik
Starting Member
26 Posts |
Posted - 2011-11-18 : 05:43:31
|
| For real time, i don't necessary want is "True" Real time but also a syncro every hour. About the connection, i have 5 Public ipFor security reason i don't want to put the production server with external ip so i have two server. One , with local ipaddress and main database.The other, with an external ip address and a database that must have only a little quantity of data to use by a web application. Actually i open the connection to the external database only by the SQL port 1433. So that server could be reached only by this way but i can open other portsAbout the quantity of data , are the Customer table, article table and another table.************************************************the world is strange but people are crazy |
|
|
|
|
|
|
Reply some data to other database