EDV Gradl

I have a SQL 2005 database and created a SQL projects out of it. Now I do compare the database (source) against the project (target). All works fine. Now when I try the comparison a second, it does not work. I get an error: Your project in not in a valid state. See output windows for more information. The output windows is empty. What to do

Marco Muller



Re: Visual Studio Team System - Database Professionals Compare a database against a Project

Gert Drapers - MSFT

Did you write back changes from your first comparison session to the project


The message means that the model changed underneath you, invalidating the state the schema compare uses to compare, if you would compare with an invalid state you get wrong results.

The error message is poor at best in describing the state and what you should be doing. I will make sure that gets addressed.

-GertD





Re: Visual Studio Team System - Database Professionals Compare a database against a Project

EDV Gradl

Yes, I tried it all.

Saving the project, checking all pending changes in, restarting Visual Studio, restarting Windows, but I still got the problem.

What do I do to get rid of the error message short of creating the project from scratch (as I do it now)

Thanks!

Marco Muller, EDV Gradl





Re: Visual Studio Team System - Database Professionals Compare a database against a Project

Gert Drapers - MSFT

If you close your schema compare sessions, it should re-establish with the new context when you open a new schema compare sessions. What is the version of the bits you are using

-GertD





Re: Visual Studio Team System - Database Professionals Compare a database against a Project

EDV Gradl

Sadly, even closing and opning Visual Studio does not do the trick. The comparison won't start again.

I am using Visual Studio Team Suite with SP1 for Vista and Datadude SP1 with Power Toys installed.

Marco





Re: Visual Studio Team System - Database Professionals Compare a database against a Project

Gert Drapers - MSFT

Can you trying deleting the project cache <project>.dat file and see if that resolves the problem

If not we will have to turn on a trace on your machine to detect why it does not want to cooperate. Please send me an email through my blog http://blogs.msdn.com/gertd so we can communicate faster and more direct through email, so we can get this resolved for you.

-GertD





Re: Visual Studio Team System - Database Professionals Compare a database against a Project

AZ_ELIE

Was this issue resolved I am having the same issue. I also have the same setup.

Thanks
Elie





Re: Visual Studio Team System - Database Professionals Compare a database against a Project

Gert Drapers - MSFT

I asked Marco if he could send me a trace of his problem, but I have not received it yet. If you would like to provide a trace send me an email via my blog and I will send you the details.

-GertD

http://blogs.msdn.com/gertd





Re: Visual Studio Team System - Database Professionals Compare a database against a Project

AZ_ELIE

Thanks Gert.

I did not realize yesterday that there was another developer checking stuff in while I attempted my compare and he created errors preventing the project from compiling. This might be why I was getting the project is in an invalid state. So I am going to get those resolved today before trying the compare. I will follow up with my result later.

Thanks

Elie





Re: Visual Studio Team System - Database Professionals Compare a database against a Project

AZ_ELIE

In my case, the reason I was getting the invalid state is because there were 4 stored procedured that were in source control by somehow where not in my local directory. I did get the latest version but this still did not bring those file in. So I did get a specific version and checked "force get of file versions already in workspace". This brought the missing file. After that I was able to do a schema comparison.

Thanks,
Elie





Re: Visual Studio Team System - Database Professionals Compare a database against a Project

Gert Drapers - MSFT

Thanks for getting back to us with the resolution of your problem.

-GertD