Archive

Posts Tagged ‘SQL Server 2008’

MySQL to SQLServer : Free Migration Assistant

January 13, 2010 Leave a comment

Microsoft announced the first CTP of a SQL Server Migration Assistant (SSMA) for MySQL v1.0 which automates aspects of the migration process to Microsoft SQL Server 2005 & 2008 including SQL Azure Database.

SQL Server Migration Assistant for MySQL is available for free download and preview at SSMA 2008 for MySQL v1.0 CTP1 and will be generally available in the summer of 2010. Customers and partners can also provide feedback via ssmateam@microsoft.com.  (via)

SQL Server 2008 : Prevent Saving changes

June 7, 2009 Leave a comment

Today I was working on a pet project and got this weird problem. I have worked with SQL Server 2005 but this is my first experience with SQL Server 2008. On the first very attempt with SQL Server I got this error from Visual Studio Management Studio.

SQLError-1

My change involves changing the column type from Nullable to Non-Nullable. So naturally SQL Server will have to drop the table and recreate the table. I understand.

But it is obvious that this message comes from Management Studio not from SQL Server. There must be some setting in Management Studio that does not allow me to do this change. I searched in the Tools  Options menu and aha I have struck gold.

SQLError2

Just uncheck “Prevent Saving changes that require table re-creation”. That’s it.
By the way, any good web3.0 project ideas for a asp.net pet project? Share with me