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…

0

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…

0

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…

0

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…

0