Thursday, November 22, 2012

BCP command for Data moving from SQL server to SQL Azure


For making sql  tables to text data files at local drive

bcp databasename.dbo.Client out E:\Shergroup\SqlData\MoveDataFromSQLAzure.txt -c -U sa -S sherbasefive -P 12456

rk5n5pqf6u.database.windows.net


for coping from local dive text data files to sql azure

bcp databasename.dbo.Client in  E:\Shergroup\SqlData\MoveDataFromSQLAzure.txt -c -U myadmin@rk5n5p -S tcp:rk5n5p.database.windows.net -P c0r=jdb

No comments:

Post a Comment