Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bringing in Sybase Data
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
00728761
Message ID:
00728771
Vues:
15
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform