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 |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2008-05-20 : 09:42:41
|
| Dear All,I have a need to replicate data between MS Access and SQL 2005 (Enterprise Edition).Could someone give advice as to whether this is possible or not, and how I might go about setting it up?ThanksKrishna |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-20 : 10:01:13
|
| You can't replicate from MS Access to SQL 2005 with built-in features. However, you can use third-party tools like (Golden Gate) but not sure though. Try using SSIS and take full advantages. |
 |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-05-20 : 10:03:30
|
| Thanks sodeep, Right now i am using the third-party tool DBSync for MS Access & MS SQL. Let me try with SSIS. Thanks for the advice-- Krishna |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-20 : 21:58:11
|
| Doesn't dbsync work properly? |
|
|
|
|
|
|
Replication between MS Access and SQL2K5