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 |
|
san
Starting Member
26 Posts |
 Posted - 2002-07-18 : 11:09:00
|
| This question may not fit in a MS SQL server forum. But I found this site the most mobile and reliable source for information. I am sure there will be some gurus out there who know both MS SQL server and Sybase SQL server..My question is simple...We are migrating our database from MS to Sybase. We have many DTS pckages running in MS (They include so amny active script tasks also..written in VB script). Is there any equivalent for this in Sybase ? If yes, how efficient are they.. Any suggestion...URLs or whatever possible is highly appreciated.. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-18 : 11:18:43
|
| AFAIK DTS is strictly Microsoft, even though it can access different data sources it still needs to be installed and running on a Windows platform. You'd have to check the Sybase documentation to see if they have an equivalent package (HIGHLY doubtful!)ActiveX scripting and VBScript are also Windows-only, at least as far as running non-ASP code. ChiliSoft has an ASP thing for non-Windows OS's, but you won't be able to use it in a DTS package.Any particular reason for the move to Sybase? Is it a show-stopper if you can't move the DTS packages? And are you getting rid of/converting the SQL Server over to Sybase, or will you keep it? |
 |
|
|
san
Starting Member
26 Posts |
Posted - 2002-07-18 : 12:11:07
|
| Thanks rob.DTS packages are necessary because the main thing it does in on every two minutes it is running an sp in Database1 and inserting the result in database2. These two database are the heart of the application. Well, we are getting rid of the MS SQL database as part of company policy..Thanks again rob. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-18 : 12:23:44
|
| You don't need DTS to run a stored procedure, if there are no advanced data transforms involved. If the 2 databases exist on the same server, then you can do this:INSERT INTO DB1..tableASELECT * FROM DB2..tableAIf they're on different servers, and Sybase can use linked servers, then you can do:INSERT INTO DB1..tableASELECT * FROM otherServer.DB2..tableAThese can be put into a regular job step as a T-SQL task. I'm not sure about Sybase's support for scheduled jobs, but I'm pretty sure they have it.If the data needs to be transformed, and the conversions are fairly simple, you can use CAST and CONVERT, I think CONVERT is available in Sybase. |
|
|
|
san
Starting Member
26 Posts |
Posted - 2002-07-18 : 13:03:34
|
| Rob, It is not just running an sp. Also, it is not a table-table bulk insert. The sp will fetch certain fields on the join of certain tables, process each of the field (IOW, have a transformation defined for each field) and then insert..This tranformation could be an ActiveX script too..This is with one DTS. There are some others, which does complex functionalites than this one..Thanks. |
|
|
|
chrissy
Starting Member
17 Posts |
Posted - 2002-07-18 : 13:46:45
|
| DTS is MS only. I've read about some Oracle admins getting sql licenses so that they can use DTS to go between their oracle servers.Also, you can call DTS from VB apps and then use the DTS exe (and dlls) to call it. You dont need SQL Server or SQL Server licenses to be involved in the mix. SQL Server is basically only needed for easy design of DTS packages, but VB can produce the same end result. Look in Brian Knight's SQL Server Admin911 book. He gives details about which files you will need. |
|
|
|
san
Starting Member
26 Posts |
Posted - 2002-07-18 : 15:24:48
|
| Thanks cris.That was a good one and I think I would look in to that, if nothing else works. But, now I am lookig for what are the alternatives available in Sybase for the DTS. I somehow feel there should be something there...Thanks again. |
|
|
|
|
|
|
|
|
DTS packages