Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bulk Import Sql Scripts
Message
De
28/04/2003 15:46:50
 
 
À
25/04/2003 17:09:31
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
00781258
Message ID:
00782436
Vues:
9
I'm running the OSQL utility from within foxpro but I'm getting a "Program too big to fit in memory" error. Have you had this problem?

>No, my script below uses Windows Authentication, that's the -E parameter. I believe it's optional, if you don't pass in username and password, osql should try using Windows Authentication.
>
>To pass in username and password, use -U and -P parameters.
>
>Roman
>
>
>>Do you need to pass in user id and password into osql?
>>
>>>You can use the osql utility, you can read about it in BOL. It allows you to execute SQL commands, including contents of a file. Here is an example, I use this to back a database on development server, copy the backup file to my computer and then restore the database on my local server:
>>>
>>>osql -S devweb2 -d master -E -i "C:\Projects\COM\Backup\BackupPerson01.sql"
>>>copy J:\comPerson.BAK c:\projects\com\backup
>>>osql -S ltrehak -d master -E -i "C:\Projects\COM\Backup\RestorePersonDB.sql"
>>>
> snip <
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform