BCP data to/from SQL Server

madeinstein ,

BCP data from database to file

"c:\Program Files\Microsoft SQL Server\80\Tools\Binn\bcp.exe" database_name..table_name out c:\data_file.csv -c -q -b 1024 -S server_name -U user_name -P password -e c:\\log_file.log

BCM data from file to database

"c:\Program Files\Microsoft SQL Server\80\Tools\Binn\bcp.exe" database_name..table_name in c:\data_file.csv -c -q -b 1024 -S server_name -U user_name -P password -e c:\\log_file.log

Comments

Post a Comment

Popular posts from this blog

Parse XML to dynamic object in C#

madeinstein ,
<? xml version="1.0" encoding="utf-8" ?> < contacts > < contact id = '1' > < firstName > Michael </ firstName > < lastName > Jordan </ lastName > < age > 40 </ age > < dob > 1965 </ dob > < salary > 100.35 </ salary > </ contact > < contact id = '2' > < firstName > Scottie </ firstName > < lastName > Pippen </ lastName > < age > 38 </ age > < dob > 1967 </ dob > < salary > 55.28 </ salary > </ contact > </ contacts > public class XmlToDynamic { public static void Parse(dynamic parent, XElement node) { if (node.HasElements) { if (node.Elements(node.Elements().First().Name.LocalName).Count() > 1) { //list var item = new ExpandoObject(); var list = new List<dynamic
Read more

C# Updating GUI from different thread

madeinstein ,
void MyEventHandler( object sender, EventArgs e) { if (this.InvokeRequired) { this.Invoke( new EventHandler(MyEventHandler), new object [] { sender, e } ); } else { //update GUI here } } void MyEventHandler( object sender, MyEventArgs e) { if (this.InvokeRequired) { this.BeginInvoke( new EventHandler<MyEventArgs>(MyEventHandler), new object [] { sender, e }); } else { //update GUI here } }
Read more