Sean Cleaver - Software IT Consultant, Hastings

SQL Bits V - Celtic Manor - Newport Wales

I will be attending the SQL Bits conference this week in Newport on Friday and Saturday so if anybody would like to hook up whilst I am there please drop me a line and we can arrange a time.

Data Synchronisation Studio – SQL Azure Support

We have just updated Data Synchronisation Studio so that you can connect to a SQL Azure database. Previously you couldn’t browse the Databases and Schema when trying to connect, SQL Azure prevents calling the Database Schema tables directly from the OleDb provider for some reason this is all fixed now in Data Sync.

We have been testing some simple synchronisations between a local SQL Server and SQL Azure and so far found that writing data to SQL Azure to be pretty slow once we had some data in there the compare was pretty quick and any updates after that were also quick.

Download the latest version of Data Synchronisation Studio from http://www.simego.com/beta

Azure SQL Manager – Support Updated

Today we have been updating our experimental support for Azure SQL. So far we have enough support for the application to be very useful for development/testing with Azure SQL.

Browse Objects

• Databases
• Tables
• Views
• Procedures
• Functions
• Synonyms
• Indexes
• Logins
• Users

Script / Edit

• Tables
• Views
• Procedures
• Functions
• Synonyms
• Indexes
• Logins
• Users (assign roles, change passwords)

Also you can sync data between SQL Server and Azure SQL with the Data compare features.

Schema compare is partially working (compare works by sync has issues) except for Table changes which fails due to deprecated SQL functions.

Connecting to Azure SQL Server

Viewing Schema and Table Data

Download the latest build of SQL Tools from http://www.simego.com/beta

Experimental SQL Azure Support for SQL Admin Studio

So I have been tinkering with SQL Azure this weekend and it looks pretty good but I needed a few tools to work with my databases. As SQL Admin Studio is my favorite tool for working with databases I have made a few tweaks so that it works with SQL Azure.

So in the latest beta build you can browse the database schema, edit table data, compare schema, compare and sync data etc.

There are a few problems with Logins, Users, Table Designer and the scripts that are generated from the schema compare but I hope to improve this over time.

Download: http://www.simego.com/beta