Yorkshire Divers

Deep Blue Technical
Go Back   YD Scuba Diving Forums > Non-Diving Related Forums > Technology
Copying Database Tables Across Servers via C# Copying Database Tables Across Servers via C#
User Name
Password

Welcome to the YD Scuba forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

Technology: Discuss Copying Database Tables Across Servers via C# in the Non-Diving Related Forums forums: Definately use the SQLBulkCopy class. I've been using it with VS2005 for the last two years now and it offers ...

Reply
Page 3 of 3 < 12 3
 
LinkBack Thread Tools Display Modes
  #21 (permalink)  
Old 22-09-06, 01:12 PM
GCParris's Avatar
Now with built-in Titanium PaceMaker...
  

Join Date: Mar 2005
Location: Bishops Stortford, Hertfordshire
Posts: 183
GCParris paddles in the seaGCParris paddles in the seaGCParris paddles in the seaGCParris paddles in the seaGCParris paddles in the seaGCParris paddles in the seaGCParris paddles in the seaGCParris paddles in the seaGCParris paddles in the seaGCParris paddles in the seaGCParris paddles in the sea
Definately use the SQLBulkCopy class. I've been using it with VS2005 for the last two years now and it offers almost the same performance as the command line bcp utility.
I can usually achieve about 25,000 rows inserted in 2/3 seconds, handy for bulk loading several hundred thousand rows of trade cashflows everyday !!
__________________
Helen Parris Underwater Photography... http://www.helenparris.com/
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #22 (permalink)  
Old 22-09-06, 01:43 PM
aclivity's Avatar
Shipwrecked & Comatose, drinking fresh mango juice
  

Join Date: May 2003
Location: nr Shevington, Lancs
Posts: 2,565
aclivity is a scuba diver - warm wateraclivity is a scuba diver - warm wateraclivity is a scuba diver - warm wateraclivity is a scuba diver - warm wateraclivity is a scuba diver - warm wateraclivity is a scuba diver - warm wateraclivity is a scuba diver - warm wateraclivity is a scuba diver - warm wateraclivity is a scuba diver - warm wateraclivity is a scuba diver - warm wateraclivity is a scuba diver - warm water
My suggestion is to ditch that SQL Server stuff and get a proper database, then invest in an industrial strength ETL tool (PowerCentre by preference!). Then discover the joys of a non-Wintel infrastucture too.

Seriously, though, Sql Server 2005 has an much improved ETL capability (no longer called DTS, called, I think, Integration Services). Does that help?
__________________
The first rule of diving: Anyone can call the dive for any reason.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #23 (permalink)  
Old 22-09-06, 01:48 PM
MartinS's Avatar
Senior Member
  

Join Date: Jul 2002
Location: Redhill, Surrey
Posts: 1,552
MartinS paddles in the seaMartinS paddles in the seaMartinS paddles in the seaMartinS paddles in the seaMartinS paddles in the seaMartinS paddles in the seaMartinS paddles in the seaMartinS paddles in the seaMartinS paddles in the seaMartinS paddles in the seaMartinS paddles in the sea
VS2005 is the way to go for us - we won't change our infrastructure as all our major apps are build on the back of SQL databases.
Am hoping to get VS2005 next week, which means we'll be good to go. The databases we are copying contain 200,000 records plus, so can see a real benefit in doing it this way.
Thanks again for all the advice
Martin
__________________
Never test the depth of the water with both feet!
69 Divers SAC
Yorkshire Divers
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #24 (permalink)  
Old 22-09-06, 01:52 PM
RonProwse's Avatar
why does it always do that......
  

Join Date: Feb 2006
Location: Chatham
Posts: 535
RonProwse swims in cold waterRonProwse swims in cold waterRonProwse swims in cold waterRonProwse swims in cold waterRonProwse swims in cold waterRonProwse swims in cold waterRonProwse swims in cold waterRonProwse swims in cold waterRonProwse swims in cold waterRonProwse swims in cold waterRonProwse swims in cold water
Martin start reading up on the new sql server 2005, it allows you to write stored proc in either C#, VB.Net or SQL.

Ron
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply
Page 3 of 3 < 12 3

« WANTED- laptop for little sister | Don't throw it out, throw it this way please! »

Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Sponsored Links

Yorkshire Divers - RSS Feed
All times are GMT +1. The time now is 10:40 PM.
Powered by vBulletin
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.2.0
Trademark and all rights reserved : © YD.com Ltd (2006)
YD.com Ltd (Registered in England - 05886696)
Other sites : Golf Clubs | New Premiership Football Kits | MP3 Portable Players | MP3 Players For Sale | Replica Football Kits | Cheap Football Boots

Advertise - Contact Us - Yorkshire Divers - Sitemap - Privacy Statement - Terms & Conditions - Top
Forums Directory