SQL Azure Integration In SQL Server 2008 R2

[This article was contributed by the SQL Azure team.] Today is T-SQL Tuesday #7 and the SQL Azure team is blogging as part of T-SQL Tuesday for the first time. This  Tuesday’s topic: “What’s your favorite hot new feature in the SQL Server 2008 R2?” Of course, SQL Azure integration is our favorite topic of…


Unicode Works Better With SSIS

[This article was contributed by the SQL Azure team.] Now that you have decided to move your SQL Server data to SQL Azure, it is a good time to change your varchar(max) and text data types to nvarchar(max). Changing your data types to Unicode will make your migration from SQL Server to SQL Azure easier…


SSIS Error to SQL Azure with varbinary(max)

[This article was contributed by the SQL Azure team.] In using the SQL Server Import and Export Wizard found in SQL Server 2008 R2 to export data to SQL Azure, I noticed that it was having trouble with a column that was the data type of varbinary(max). This article will discuss how to the fix…


Exporting Data from SQL Azure: Import/Export Wizard

[This article was contributed by the SQL Azure team.] In this blog post we will show you how to export data from your SQL Azure database to a local SQL Server database using the SQL Server Import and Export Wizard in SQL Server Management Studio 2008 R2. This is a great technique to backup your…