Tag Archives: SQL Azure

Update database schema changes to SQL Azure using DAC


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


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


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


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


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