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 |
|
liquifusion
Starting Member
3 Posts |
 Posted - 2007-07-23 : 12:01:14
|
| We are working with a Mexican developer to share data between our English database (SQL 2005) and his Spanish database (SQL 2000). We are thinking the best way to gain access to his data (since our website will need data from both databases) is to have them Export data from their Spanish tables into English tables within their database and replicate those tables to our database several times a day. Does this seem like a good idea - any suggestions for a better way to share the data? Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-23 : 13:31:41
|
| You can build ssis package to copy table and schedule sql job to run the package. |
 |
|
|
chicago_blues
Starting Member
1 Post |
Posted - 2007-08-01 : 12:35:34
|
| is it possible to build real-time interface between 2 sql 2005 databases instead of scheduling packages?also pls could you pioint me to steps involved in scheduling sql jobs to run the package(I was able to create map and run package). |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-01 : 14:27:10
|
| If need real time data sync, you can use replication. Regarding create sql job, you can find detailes in books online. Just choose sql server integration services package as job step type. |
|
|
|
|
|
|
Best way to transfer data