SQL Server / SQL Azure Schema Compare
I'd like to compare schemas between SQL Server 2012 and SQL Azure, but I get this error in Visual Studio 2013:
A project which specifies SQL Server 2012 as the target platform cannot be published to SQL Azure.
Is it possible to compare these 2 database types?
Solution
There actually is a non-cumbersome method to overcome this problem. Just open up the schema compare options and make sure the "Allow incompatible platform" box is checked
- SSRS 2014 date range parameters not working with an OR clause
- Calculate duration using T-SQL
- Conversion failed when converting the nvarchar value to data type int while inserting records into table
- How can I run just the statement my cursor is on in SQL Server Management Studio?
- SQL rollup to add a total row for multiple columns
- Select SQL Server database size
- INSERT INTO a temp table, and have an IDENTITY field created, without first declaring the temp table?
- Create single image for database diagram in SQL Server
- Automatically define the DataTable in C# from the schema of SQL server tables?
- TSQL: how to write this query?
- CREATE TABLE permission denied in database 'tempdb'
- The SELECT permission was denied on the object 'Users', database 'XXX', schema 'dbo'
- Does database compound index order matter if the first column is only queried with an equal operation?
- Difference between .NET, OLEDB, and Native Providers in SSIS
- Is there a way to populate a HTML table from a database? (SQL Server, VB.NET, ASP.NET)
- ExecuteScalar() not returning full contents of cell
- Why does normal execution resume after Raiserror in Catch block
- PRINT output doesn't appear immediately in the Messages pane in SSMS
- Comma delimiter is not being respected
- A connection was successfully established with the server, but then an error occurred during the pre-login handshake
- Select all unique values in SQL table with additional information
- How to avoid the "divide by zero" error in SQL?
- How do I get list of all tables in a database using TSQL?
- Basic SQL commands in Terraform
- Could there be a deadlock when using optimistic locking?
- Get list of tables but not include system tables (SQL Server 2K)?
- How to change keyboard shortcut - F5 to Ctrl + Enter to execute SQL command in SQL Server Management Studio
- Self join to compare rows of table?
- Transform DateTime field to provided format in where clause
- SSMS crashes instantly