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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-11 : 07:06:42
|
| hendra writes "i have two different database, one is sybase and on other computer is sql server, i dont want to any changes on sybase, just keep it as ussual, but i need some information from sybase and transfer it to sql server. if there is changes in sybase sql server will also changes (including insert update and delete command), is there any idea how to solve this? thanks" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-11 : 12:52:11
|
| Have you used DTS before? How about linked servers? Both of those would work. Does Sybase have a tool that can export the data into a text file. If so, you could then use bcp to import the data into SQL Server.Tara |
 |
|
|
|
|
|
import from sybase to sql server programatically