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

JavaScript should be your favorite language

So you think you're really cool because you're hardcore and know everything there is about PHP or C# or C++ or VB or Perl or Ruby or Python or ColdFusion or Java or ActionScript or..  I should stop right?  The thing is, as developers we've been coding in all these other languages to fit the phone, desktop, server and platform we think is best.  But we were wrong.  There is no "best" or "favorite" platform.  We shouldn't have been writing Flash apps.  We shouldn't have been writing Silverlight or Windows or Mono or XNA or Java apps.  We should have been writing HTML5 apps this whole time.  Don't get me wrong.  I don't thing that the debate of standards based apps vs native apps is over.  I think it's going to go nuclear.  Soon their will be iOS , Windows , Ubuntu , Chrome , Android , Blackberry , Firefox OS , and more to come.  They (I assume) will all probably be a little different but there will be ways to write in just HTM...
Read more

Why I won't be registering as a blogger in the state of Florida.

This blog post is about Ron DeSantis. Why am I writing about Ron DeSantis? Did he create a new JavaScript framework? No. Did I move to Florida? Nope. Did Mr. DeSantis contact me about my blog? No.  Does anyone at the Republican party in Florida know that I exist? Absolutely not. I'm writing about Ron DeSantis because he and his party in Florida are working to pass a law requiring me to register my blog with them. I'm disseminating this information to you in possible violation of a law written 1000 miles away. At the discretion of some official in Florida they may decide that I owe them money and fine me for not registering with that official. I also must tell them how much money I make off my blog post. It's just pennies by the way. https://www.flsenate.gov/Session/Bill/2023/1316  This proposed law is as stupid as the book bans. Just like the banned books, nobody is being forced to read this blog. A person has to seek this blog out. You don't have to finish reading a bo...
Read more

Cool new stream about F# from LaylaCodesIt

Image
There was a cool new series about F# on Twitch today.  It was fun to see and I haven't used F# in a long time. I felt like it was my first time while watching the stream. https://www.twitch.tv/laylacodesit  Here is my code inspired by Layla and Alyssa. https://gist.github.com/trendoid/ad4c5f3b58fc09c6a0ee472a0fd869d6 or if you want the whole project... https://github.com/trendoid/FsharpConsoleApp It just reads from a text file and prints the contents out to the console. // For more information see https://aka.ms/fsharp-console-apps printfn "Console App: Started!" open System.IO let baseDirectory = __SOURCE_DIRECTORY__ let filePath = "Text.txt" let fullPath = Path.Combine(baseDirectory, filePath) let readFilesTask (path1) =   task {     let! content = File.ReadAllTextAsync(path1)     return content   } printfn "Content: %s" (readFilesTask(fullPath).Result)
Read more