Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data Migration SQL to Sybase
- Thread starter psamedy
- Start date
Best way would be to set up a DTS package and put it as a scheduled task.
AS to how to set up the DTS package, it depends on what you want to do to the data before moving it. If it is a straight move, then you can use the import export wizard, just remember to save the package before executing it the first time, so that you can schedule it.
AS to how to set up the DTS package, it depends on what you want to do to the data before moving it. If it is a straight move, then you can use the import export wizard, just remember to save the package before executing it the first time, so that you can schedule it.
- Status
Similar threads
- Locked
- Question
