- 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.
3 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.
Hello,
I have developed a new clean web 2.0 wordpress theme.
Has 2 colours silver and blue, has custom header(colour or image).
I am curently working on it, so if you have suggestions let me know.
You can view live demo and download from here www.getbelle.com
If you found bug reports or you have suggestions pm me.
Wish you a happing using.
many thanks to [url=http://www.usainstantpayday.com/]USAInstantPayDay.com[/url] for paying the hosting and developement of the theme
DamyTyday
It's so easy to choose high quality [url=http://www.euroreplicawatches.com/]replica watches[/url] online: [url=http://www.euroreplicawatches.com/mens-swiss-watches-rolex/]Rolex replica[/url], [url=http://www.euroreplicawatches.com/mens-swiss-watches-breitling/]Breitling replica[/url], Chanel replica or any other watch from the widest variety of models and brands.
Post a Comment