Database Reference
In-Depth Information
keyword and specify the server name and credentials for your SQL Azure database, as shown in Figure 5-
18.
Figure 5-18
.
Uniqueidentifier
data type error during bcp import
After you type in the command, press Enter to execute the bcp utility. Only one row is copied over,
and then an error is generated, stating that an unexpected end-of-file (EOF) was encountered. This error
isn't specific to SQL Azure; the bcp utility has issues with columns of the
uniqueidentifier
data type.
You can find posts and blogs all over the Internet about this problem.
The solution is to execute the following T-SQL against the Users table in your SQL Azure database:
alter table users
drop column rowguid
The cool thing is that you don't need to re-export the data. You can re-execute the bcp
import
command. Do that, as shown in Figure 5-19, and all 105 rows are imported. Then, use the same syntax to
import the Docs and UserDocs data.
Figure 5-19.
Successful bcp import
