- SQL to SQL Azure
- SQL Azure to SQL
- SQL Azure to SQL Azure.
This tool can do a lot. A nice screen cast in which the author: George Huey explains what the tool can do can be found here:
I practise with this tool and could create the SQL objects, like tables very easy. The migration wizard can also check your scripts for compatibility issues with SQL Azure. However the upload of data always failed with next error message:
Process starting ...
-- Success: CREATE NONCLUSTERED INDEX [JournalStatusEntryGuid] ON [dbo].[amutak] ...
Uploading data to "Deltabike.dbo.amutak
*
*****
Sorry, but BCP upload process failed:
SQLState = 37000, NativeError = 40531
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Server name cannot be determined. It must appear as the first segment of the server's dns name (servername.database.windows.net). Some libraries do not send the server name, in which case the server name must be included as part of the user name (username@servername). In addition, if both formats are used, the server names must match.
This error can be solved if you specify also the servername after the login name.
instead of only
Enjoy uploading your data to SQL Azure.
5 comments:
I want to thank the blogger very much not only for this post but also for his all previous efforts. I found www.keepitsimpleandfast.com to be very interesting. I will be coming back to www.keepitsimpleandfast.com for more information.
Hi there all, I just signed up on this incredible community forum and desired to say hey there! Have a extraordinary day!
hi everybody
just registered and put on my todo list
hopefully this is just what im looking for looks like i have a lot to read.
Excel is one of the most powerful Microsoft tools, as it helps in managing and analyzing large data. When I was looking for an do my homework for money based technology essay, I got an essay on excel and its capabilities. Then I got to know that it provides great help to different types of business to generate large analytical reports and do forecasting and calculation stuff. This shows the power and ability of this tool and its importance in organizational use.
We realize that assignment writing in university life requests a person to have top to bottom information on the topic. Our master journalists have encountered experts with having wide information premise to Assignment Done For You finish your scholastic papers so your grades can raise! We realize that there are different sites that are at present contributing help with the college tasks however not a solitary one of them is fit for meeting our nature of composing group and ability.
Post a Comment