FileBrowser .SQL support

[dannyCage]

Would be nice with support for *.sql files too in the “FileBrowserâ€

[Sergey]

Danny,

I assume you work with VS 2005, right? There is a "Show all files or code files only" button on File Browser's toolbar. When it's not pushed down, i.e. in code files only, does it still show .sql files?

[dannyCage]

Not yet, still using VS2003.

And no it doesnt work, I get all other types of files but not .SQL files.

Worth mentioning is that the SQL files are in a SQL-Project.

[Sergey]

Not yet, still using VS2003.

Ah, that explains it. I looked into this way back when some one had reported the same problem. If I recall it correctly, SQL projects don't even expose .sql files via extensibility. In other words, there is no programmatic way to retrieve file list for SQL projects. I'll take a 2nd look to double check but most likely there isn't much I can do about that.

FYI, .sql files handling has been improved in VS 2005. File Browser shows .sql files just fine.

[Sergey]

Yep, I was right. SQL projects in VS.NET 2003 don't (programmatically) expose any files. Not much I can do about that I'm afraid. Sorry.

[mpareja]

There must be some way of accomplishing this because tools such as Resharper and I believe CodeRush are able to find these files. Perhaps I will try and look into this a little further.

Mario

[Sergey]

There must be some way of accomplishing this because tools such as Resharper and I believe CodeRush are able to find these files. Perhaps I will try and look into this a little further.

Mario

I'm gonna look more into this for one of the next major versions.

I have confirmed that none of the 3rd party file browsers, DPack's including, that rely on VS DTE extensibility and file code model are able to process Database projects. I have also confirmed that ReSharper happily displays Database project files. They must be using items hierarchy (UIHierarchyItems) or something similar to that against those kind projects.

Let me know if you find anything out on this. Thanks.

[mpareja]

Update: I took apart Resharper and found that (as suspected) they do parse the project files directly.

[Sergey]

I took a quick look at ReSharper and I see that they do massage the project file and load it into XmlDocument. Did you find anything on how they actually parse the database project file?

I went over all VS SDK interfaces again and didn't see anything that would allow me to get to the database project files. It's a shame that this late in the game VS database projects still don't have even basic file code model implementation.

Thanks for looking into this for me.

[zlatan24]

For work with sql files my friends usually use different trial tools.But yesterday I had the big problem with sql file.And I found in network-rebuilt mdf.Tool solved my problems in seconds and for free.Besides utility demonstrated how rebuilt mdf program analyzes your database and moves to the evaluation of affected data and corrupted mdf sql 2000.

[zlatan24]

Not yet, still using VS2003.

And no it doesnt work, I get all other types of files but not .SQL files.

Worth mentioning is that the SQL files are in a SQL-Project.

There are a lot of tools for recover sql files,but one of it helped me quite good-rebuilt mdf,because it fixed my sql server and files too.Besides application showed me how it read this article for more information about the recovery of affected files in Microsoft SQL Server 7.0, 2000, 2005, 2005 and even 2008 format and so on...