Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2012
>>>Just curious, why is the script so big? If it's all manual inserts, then yes, you might want to look at putting the data in some text/CSV file and try a bulk load
>>
>>I need to script a table from an environment to another.
>
>I realize this will take some time to go through the learning curve, but you might want to take a look at some of the Azure offerings from Microsoft (unless you've been doing so already)
>
>Over the last year and a half I've been going through the learning curve. The technology isn't perfect but getting better, and it might help with a scenario like that.
While learning is almost never wrong, having a reliable toolset for ex/import via basic files is more important IMO. If generation is under your programmatic control, a parametrized loop to create 1..n input files helps you to get the job done IAC, even if performance might not be the best and leave you time to try out faster appoaches if it matters.
While I often rely on vfp as table based handling of checks is easy (which is the same trap as to go exclusively to Azure), I have ex/import libs in java, C, Python and a few languages today almost forgotten like ModulaII and Pascal ;-)
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement