Hi
I have a batch script which invokes bcp, to help migrate data from one DB to another and maintaining the dependencies between the tables.
I use DB_NAME() and @@servername to determine the current DB to import to/export from and pass these as variables to SQLCMD command that in turn invokes the bcp commands.
The bcp command is as follows:
bcp db.dbo.table in data.tsv -T -c -q -v -S server\LOCALDB#7779D34D
because @@servername returns server\LOCALDB#7779D34D as the database identifier.
It seems that the local database is not accessible remotely from the command line.
Is there a means that I can refer to this database so as to connect to it remotely or access it via the bcp utility?
Any help is greatly appreciated.
Regards
Lucas
...
Go to the complete details ...