[SA 9.0.176 Pro] - Update workspace 2

[SA 9.0.176 Pro] - Update workspace 2

I've had to create another topic because the last one was locked (why?).

The issue is back again, but the error message in the log is different this time:

Quote:

2016-11-11 15:27:22 SqlEditor64.exe Selected DB items count: 5
2016-11-11 15:27:22 SqlEditor64.exe fmSCSRepProgress: Create
2016-11-11 15:27:22 SqlEditor64.exe Start task TSCSTask_DatabaseToWorkspace at $000000000B3C8B20
2016-11-11 15:27:38 SqlEditor64.exe Failed getting DDL: Exception has been thrown by the target of an invocation.
2016-11-11 15:27:38 SqlEditor64.exe Failed getting DDL: Exception has been thrown by the target of an invocation.
2016-11-11 15:27:38 SqlEditor64.exe Failed getting DDL: Exception has been thrown by the target of an invocation.
2016-11-11 15:27:38 SqlEditor64.exe Failed getting DDL: Exception has been thrown by the target of an invocation.
2016-11-11 15:27:38 SqlEditor64.exe Failed getting DDL: Exception has been thrown by the target of an invocation.
2016-11-11 15:27:38 SqlEditor64.exe RefreshTrees(262) begin.
2016-11-11 15:27:38 SqlEditor64.exe RefreshTrees end.
2016-11-11 15:27:41 SqlEditor64.exe End task TSCSTask_DatabaseToWorkspace at $000000000B3C8B20

We expect a fix for the issue with table DDL extraction released next week. It has been already implemented and queued for the release version.

This is great news. I was getting desperate and began testing comparison and source control solutions from ApexSQL and RedGate. As I expected, they worked out of box and had fewer bugs (still, they were there). In exchange customization was at beginner level. Also, they only work with SQL Server so that makes them a temporary substitute at best.

Though the staff at ApexSQL was rather willing and helpful, it only proved that a forum is a much more suitable tool to solve issues such as this than email would ever be.

gemisigo wrote:

This is great news. I was getting desperate and began testing comparison and source control solutions from ApexSQL and RedGate. As I expected, they worked out of box and had fewer bugs (still, they were there). In exchange customization was at beginner level. Also, they only work with SQL Server so that makes them a temporary substitute at best.

Though the staff at ApexSQL was rather willing and helpful, it only proved that a forum is a much more suitable tool to solve issues such as this than email would ever be.

I had tested RedGate SCS before I bought SQL Assistant way back in 2012 (or whenever). I had found myself wishing that SQL Assistant's SCS was more like RedGates (Though I cannot recall why now).

I had gone through all of the "autocomplete tools" SQL Prompt, ApexSQL Complete, Devart SQL Complete and SQL Assistant won overall because I thought I could use it with Microsoft Access (but it turns out they use the catalog API for tables, so it doesn't show my linked tables).

Overall I'm still pleased with SQL Assistant (though I haven't revisited any of the competition in a while) But somehow I have a feeling their support may not be as quick.. I'm sure it helps we have a forum to vet our issues on.

I visit them every once in a while. Mostly to check their comparison tools and 'steal' new ideas. But this time I was in dire need for source control so I checked those as well. My experience is that both ApexSQL and RedGate has competent staff and reliable support but they don't come anywhere near SoftTree Tech when it comes to amenability. Even their responsiveness is acceptable but STT is usually much faster. This forum and the ability to share thoughts and be exposed to other viewpoints gives us unsurpassable flexibility. Sometimes I wonder how many people are behind SysOp.

Hmm, I just checked and I have 8 unanswered posts/questions, half of them already stalked to page two :)

I wish messaging was enabled here. I'd love to bounce things off you privately.

I too wonder how many reply as sysop

	Mindflux wrote:
	I wish messaging was enabled here. I'd love to bounce things off you privately.

Well, that would be nice. But while there aren't a lot of active (or at least actively contributing) people here, many are reading it and that would deprive those others of our thoughts. Also, SysOp almost always has pretty some good insights. Nevertheless, I'm pretty easy to reach. You just have to try :)

I'm pretty sure I've found you online but most places seem like you've abandoned the account like on twitter.

	Quote:
	Hmm, I just checked and I have 8 unanswered posts/questions, half of them already stalked to page two :)

The answer is 2.

The reason there are no complete responses to several post of yours, we are waiting for help from the development team and they need more time to try to reproduce the issues and investigate their causes and look for solutions. So we are on the receiving end here too.

I'm sorry for the disabled messaging and some other stuff being turned off, that's for a reason. We are trying to keep the amount of posted spam down and prevent other abuses of this support site.

	SysOp wrote:
	I'm sorry for the disabled messaging and some other stuff being turned off, that's for a reason. We are trying to keep the amount of posted spam down and prevent other abuses of this support site.

Can't you set the board up to allow private messaging after the account has 25 posts or something ?

	SysOp wrote:
	The reason there are no complete responses to several post of yours, we are waiting for help from the development team and they need more time to try to reproduce the issues and investigate their causes and look for solutions. So we are on the receiving end here too.

Hey, don't take it too seriously, I was just teasing you, sorry if it caused confusion. I'm completely aware that certain things can take formidable amount of time. If I wasn't okay with that I'd ask/complain in those posts.

	Mindflux wrote:
	I'm pretty sure I've found you online but most places seem like you've abandoned the account like on twitter.

Yepp. I'm a workaholic, and as such, socially not very active. You can find me on gmail, though. I usually respond within a few hours.

	SysOp wrote:
	I'm sorry for the disabled messaging and some other stuff being turned off, that's for a reason. We are trying to keep the amount of posted spam down and prevent other abuses of this support site.

Yes, I've seen that a few times. The speed you clean up the mess those occasional spams create is remarkable.

I'm still getting those

	Quote:
	2016-11-21 10:44:34 SqlEditor64.exe Failed getting DDL: Exception has been thrown by the target of an invocation.

error messages. Any idea what those could be?

The topic subject issue should have been fixed in the latest build 9.0.185.

The topic subject issue should have been fixed in the latest build 9.0.185.

	SysOp wrote:
	The topic subject issue should have been fixed in the latest build 9.0.185.

The issue mentioned in parent topic was fixed indeed, by explicitly installing and early SMO version. The error message is different this time.