Tag Archives: SQL Azure

Update database schema changes to SQL Azure using DAC

Posted on January 20, 2013 by

In my previous blog posts (Deploy DAC, Import/Export DAC), I have shown you how to migrate database schema and data to SQL Azure. In this blog post, I am going to show you how to update the database schema changes … Continue reading →

Posted in SQL Azure | Tagged , , , | Leave a comment

SQL Azure data migration using Import/Export tool

Posted on January 16, 2013 by

In my previous blog post, I have shown you how to upload data to SQL Azure database using SSIS. In this post, I will show the data migration operation using Import-Export wizard. Implementation In this example, I am going to … Continue reading →

Posted in SQL Azure | Tagged , , , | Leave a comment

Connect SQL Azure using SSMS

Posted on January 15, 2013 by

We can use SQL Server Management Studio (SSMS) 2012 to connect with SQL Azure. You can also execute DDL, DML, DCL and TCL commands here. In this blog post, I will be showing you how to connect and work with … Continue reading →

Posted in SQL Azure | Tagged , , | Leave a comment

Upload data to SQL Azure Database using SSIS

Posted on January 14, 2013 by

In this blog post I will be showing you how to transfer data to SQL Azure database. Implementation Step 1: Create a package and a dd Data Flow Task Step 2: Add ADO NET source and ADO NET destination task … Continue reading →

Posted in SQL Azure | Tagged , , , , , | 2 Comments

Creating SQL Azure Database Objects and View Spatial Data

Posted on January 13, 2013 by

In this post I will be showing you how to create SQL Azure Database, Tables  and input data to a table. Create SQL Azure Database Step 1: Go to Administration page and Click create database icon. Step 2: Input Database … Continue reading →

Posted in SQL Azure | Tagged , , | Leave a comment