Schema compare does not support SQL Server 2008

I just rebuilt the home server and installed Windows Web Server 2008, SQL Server 2008 and Visual Studio Team System 2008 SP1.  I also ran all windows updates.  But I still couldn't do a schema compare against the 2008 database.

After installing (manually) GDR Release Candidate 1 all is well.  I also have some new settings on the schema compare wizard.

 

This is a very good update.  I recommend it.  I have had no problems yet.

It "now supports comparing Projects, Databases or dbschema files in any combination. For example, Project to Project, which has not been possible until now. Object Type Filtering. Additional ignore filtering options."

When using schema compare to deploy tables from a 2005 database to 2008, pay attention to Database Options and definitions.  You might also want to filter by "New" items only.  That helped me quickly deploy a production database to my new test server.

If you use the ignore filtering options and use the target collation, that will also help move a schema over.  Also pay particular attention to users and schemas.  They can cause your update script to fail because 2005 does these things differently than 2008.

DOWNLOAD IT NOW!

Comments

Post a Comment

Popular posts from this blog

Special Characters are Truly Special

Image
Do you remember the days before string interpolation in C#? I do. It was medieval. Those were truly the dark days of development. We would all use string formatting and concatenation and carried swords around to defend ourselves against giant beasts. Ok, maybe I'm the only one that was wearing a helmet but I'm kind of a weird guy. I think we can all agree that string concatenation is not all that fun. It might not be as dangerous as dragons, but it can still light your hair on fire when there is a bug in your code just to display some text. Classes in C# like StringBuilder helped make things safer but it wasn't all that readable. String.Format is easy but keeping the parameters in the right order isn't exactly a no brainer either. What if that code was just in a class behind a view? Can't we just put it in the view? In the code behind it was easily testable, but the context was lost, and it wasn't as simple as what we can do today. output = String.Format("
Read more

.NET Maui and VS Code

Image
  I was disappointed in the developer experience for .NET Maui and Visual Studio Code. I assumed that the popular debuggers and extensions would cover getting an app running. I am always up to date on my .NET and Visual Studio and Visual Studio Code so I just figured the tooling would be there. When the marketplace didn't really reveal a solution for me, I went searching. The best search result for me is the one that pointed me in the direction to get my .NET Maui CLI working.  That's right. I went to the CLI to get my IDE running the way I wanted it to. .NET MAUI with .NET CLI (Command Line Interface) Getting the .NET Maui workload and the maui-check command line tool installed really helped. Those installs made sure that the libraries and emulators were setup so I could run them without Visual Studio.  It also reminded me that I'll need some sort of emulator or device to connect VS Code to. dotnet new maui After running the CLI to create my solution and project, I realize
Read more

Where’s my phone update?

  http://www.microsoft.com/windowsphone/en-us/features/update-schedule-usa.aspx   I have a Samsung Focus.  If you look at the chart and details (as of today April 4th) I should get my February update 10 days to several weeks after AT&T gets thru testing.  AT&T isn’t done with testing at the time of this blog post.  So the February update should be called the June update and the March update could be called the July update.   I’m glad I don’t have a brick.  I’m glad I don’t have an Android 2.* and need to figure out if I can spend money on an app because it might actually not work on my version on the 2.x operating system.  I’m glad I don’t have an iPhone 4 with the bigger GBs and the cracked screens.   But how much different is copy and paste on the AT&T network than another network?  The Samsung update is in network testing right?  Or maybe that is just smoke and there is a bigger fire.  Tell me there is fire and I’ll not want the update. Otherwise quick puff
Read more