Thursday, November 29, 2007

Export table and data using SqlBulkCopy

i have one database to be exported and i try to use the import and export features from the sqlserver 2005. However i enconter one problem which is the primary key of the enabled indentity insert is all mess up after the importing to my new database. I just found and tested a utility and it works quite well.


method to export

generate a sql script with having the sql schema
use this program simple sql bulk copy downloadable from http://projects.c3o.com/files/default.aspx


ref:

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx

12 comments:

CresceNet said...

Oi, achei seu blog pelo google está bem interessante gostei desse post. Gostaria de falar sobre o CresceNet. O CresceNet é um provedor de internet discada que remunera seus usuários pelo tempo conectado. Exatamente isso que você leu, estão pagando para você conectar. O provedor paga 20 centavos por hora de conexão discada com ligação local para mais de 2100 cidades do Brasil. O CresceNet tem um acelerador de conexão, que deixa sua conexão até 10 vezes mais rápida. Quem utiliza banda larga pode lucrar também, basta se cadastrar no CresceNet e quando for dormir conectar por discada, é possível pagar a ADSL só com o dinheiro da discada. Nos horários de minuto único o gasto com telefone é mínimo e a remuneração do CresceNet generosa. Se você quiser linkar o Cresce.Net(www.provedorcrescenet.com) no seu blog eu ficaria agradecido, até mais e sucesso. If is possible add the CresceNet(www.provedorcrescenet.com) in your blogroll, I thank. Good bye friend.

Anonymous said...

Bonjorno, carso-owen.blogspot.com!
[url=http://athe.pun.pl/ ]Vendita in Italia[/url] [url=http://viagraradf.pun.pl/ ]Vendita viagra online[/url] [url=http://viagraonline.pun.pl ]Vendita viagra [/url] [url=http://viagracqui.pun.pl/ ]Acquisto viagra in Italia[/url] [url=http://cialisenta.pun.pl/ ]Comprare cialis generico[/url] [url=http://viagrakhou.pun.pl/ ]Acquistare viagra in Italia[/url]

Anonymous said...

ah at last, I could find your article once more. You have few [url=http://tipswift.com]useful tips[/url] for my school project. Now, I won't forget to bookmark it. :)

Anonymous said...

mesothelioma support and information!
[url=http://www.mesothelioma-support.org/]asbestos mesothelioma lawsuit[/url]

Anonymous said...

I merely wished to officially say "Hi there" to everyone here. In my opinion , that this appears like an unusually appealing place to be online.

I cannot wait to begin. Do you have any sort of guidance for someone in the beginning stages? Any certain section that you would advise more versus others to begin?

I want to to share with you a quote that i have often found to be tremendously motivational in order to start formal introductions:

[quote]Never believe in mirrors or newspapers. ~Tom Stoppard[/quote]
Greetings,
Mark

Anonymous said...

[url=http://www.hadigel.net/program/Program.asp?id=735]total video converter indir[/url]

Anonymous said...

"Staropolskim obyczajem,
gdy w Wigilię gwiazda wstaje,
Nowy Rok zaś cyfrę zmienia,
wszyscy wszystkim ślą życzenia.
Przy tej pięknej sposobności
i ja życzę Wam radości,
aby wszystkim się darzyło,
z roku na rok lepiej było."

[url=http://www.karty-swiateczne.com]kartki świąteczne[/url] - kartki świąteczne
NIECH MIKOŁAJ PRZYNIESIE CI PEŁEN WOREK SZCZĘŚCIA I POCIECHY DLA SERCA!

- Żyj z rodziną i przyjaciółmi w zgodzie i pogódź się z nimi nawet jeśli to niemożliwe!

CZAS ŚWIĄT TO OKRES WIARY, NADZIEI, POJEDNANIA I WYBACZANIA!

Niech nadchodzące święta, pełne rodzinnego ciepła i odpoczynku, napełnią Was prawdziwą radością i pokojem. Niech będzie to dla Was chwila wytchnienia od codzienności, chwila refleksji i dobrej nowiny, która wyzwoli to, co najlepsze i da siły do podejmowania nowych zadań na cały zbliżający się nowy rok

Anonymous said...

My girl sabbatical goal are mountains. I especially love the European ones, in France or Austria. The weather is proper appropriate for hiking and there are innumerable skilful villages, where you can stay. People are exacting and you can entertain the tempo of your soul there. Look: [url=http://www.transport-warszawa.info/]przeprowadzki warszawa[/url]

Anonymous said...

Fastened, they demand to be taught that filing lawsuits is not the steadfastness to ode dotty piracy. A substitute alternatively, it's to move something child than piracy. Like peace of use. It's absolute scrap a immense numbers easier to working-out iTunes than to search the Internet with imperil of malware and then crappy righteousness, but if people are expected to answer after loads and rub elbows with on seeing that ages, it's not moneyed to work. They not securely be subjected to a squat every so day in and day out old-fashioned in bootee people mould software and Network sites that vocal millions it ridiculously unaggressive to corsair, and up the quality. If that happens, then there convert into be no stopping piracy. But they're too circumspect and alarmed of losing. Risks perceive to be bewitched!

funny

Anonymous said...

you love this? [URL=http://www.karenmillen--outlet.com/]karen millen uk[/URL] with low price fDtSxtAs [URL=http://www.karenmillen--outlet.com/ ] http://www.karenmillen--outlet.com/ [/URL]

Anonymous said...

http://site.ru - [url=http://site.ru]site[/url] site
site

Anonymous said...

architects and designers said: We are trying [url=http://www.ddtshanghaiescort.com]escort shanghai[/url] to generate a party line to showcase the exhaust of robotics in the creative industries