Thanks for the tips.

Say you've RED (prod) and GREEN (DEV).

If you're, say in one of the (GREEN) database servers in the query Window and do a Ctrl +N and then...

Thanks for your help.

Hi,

Thanks for reading this and hope you can help me.

Tried this:

bcp AdventureWorks.dbo.HumanResources.myTeam format nul -c -t , -f \\SomeServer\SomeFolder\myTeam.Fmt -Sserver_name [MySQLServer\MyInstance] -Ulogin_id Mylogin -Ppassword MyPassword -T

it error out with this:

bcp:...

nvm ... I found some good example on this site...