Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bringing in Sybase Data
Message
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
00728761
Message ID:
00728771
Views:
13
>I have been gifted with a bunch of sybase data and I have to import it into SQL. I have tried to import the data using DTS but Get errors regarding data in use. I have loaded Sybase server temporarily on the same machine as a SQL server in hopes of expediating the transfer... I am missing a key element, something small yet paramount.
>
>I need some help as I am under a time crunch.
>
>My thanks in advance,
>Joe

You can get the Sybase data into VFP cursor and then dump it to SQL.
For quick and dirty example, you may create two corresponding connections, create two remote views, get the data from Sybase into one, (optionally do any data manipulations here) add the data to the second remote view from SQL and TABLEUPDATE it.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Reply
Map
View

Click here to load this message in the networking platform