User profile for dwainew

yes, you can close it. no issues since. / comments

yes, you can close it. no issues since.

0 votes

dwainew said: Additionally, despite using the sa account, another fairly complex project is having a similar issue. During project refresh, it hangs for literally 5 minutes (at either 96% or 98%) during "Reading Dependencies," and then completes. But a callout on two tables shows an error similar to the windows auth issue above. https://www.screencast.com/t/6fS4NhHg0 https://www.screencast.com/t/cGrCF2voJwTK If it hangs at 96%, then two errors show up for the same two tables, not one. The additional error just has a different "initialization" value. It turns out these two tables are using the same existing data source (which is also being generated), and that the preview pane is stuck on that source table. https://www.screencast.com/t/GaWqSwL7 Please advise. I just realized the entirety of the second post was due to the connections to the source for each table were still using windows auth. It seems to be working now with everything set to use sa account. / comments

dwainew said: Additionally, despite using the sa account, another fairly complex project is having a similar issue. During project refresh, it hangs for literally 5 minutes (at either 96% o...

0 votes

not much help there. It stopped after a second restart and hasn't occurred since. / comments

not much help there. It stopped after a second restart and hasn't occurred since.

0 votes

Additionally, despite using the sa account, another fairly complex project is having a similar issue. During project refresh, it hangs for literally 5 minutes (at either 96% or 98%) during "Reading Dependencies," and then completes. But a callout on two tables shows an error similar to the windows auth issue above. https://www.screencast.com/t/6fS4NhHg0 https://www.screencast.com/t/cGrCF2voJwTK If it hangs at 96%, then two errors show up for the same two tables, not one. The additional error just has a different "initialization" value. It turns out these two tables are using the same existing data source (which is also being generated), and that the preview pane is stuck on that source table. https://www.screencast.com/t/GaWqSwL7 Please advise. / comments

Additionally, despite using the sa account, another fairly complex project is having a similar issue. During project refresh, it hangs for literally 5 minutes (at either 96% or 98%) during "Readin...

0 votes

The quick fix is, don't launch SSMS (or other extension consumers?) first after newing up a system. Launch one of the RG apps, which will give you the same dialog, but it allows you to authenticate. Then the SSMS plugin works fine. [image] Could someone explain the efficacy of requiring a login to even run the tooling? What if I'm installing in an isolated (from web) dev/test environment? (which we have plenty of, but I've never had to try, yet) / comments

The quick fix is, don't launch SSMS (or other extension consumers?) first after newing up a system. Launch one of the RG apps, which will give you the same dialog, but it allows you to authenticat...

0 votes

:oops: :oops: :oops: sorry, brain fade. I forgot about the refresh at the top position of the drop down. perhaps it's because clicking the drop down always hides the refresh option and you have to purposefully scroll up to see the option. Somehow I think a refresh button would be more intuitive, but this works too. / comments

:oops: :oops: :oops: sorry, brain fade. I forgot about the refresh at the top position of the drop down. perhaps it's because clicking the drop down always hides the refresh option and you have...

0 votes

No response from anyone? Someone at Redgate? RG sql data compare is clearly showing a quick "Cancelling .... something ... " and starting over. Infinite loop. making my expensive software not very useful in this case. I've run into this with a few other comparisons (user databases) since I noticed this issue on Monday. / comments

No response from anyone? Someone at Redgate? RG sql data compare is clearly showing a quick "Cancelling .... something ... " and starting over. Infinite loop. making my expensive software not ve...

0 votes

Don't let the simplicity of the example fool you. Amanda is now managing 100 databases, each with thousands of objects and is put in the same situation... Your suggestion of retrieving the missing objects (CHANGING the current truth), then dropping it (using what as a guide, a screen shot or a had written list?), simply to allow SSC to get its bearings is untenable in a situation where there are potentially hundreds of objects to process. WHEN a DB is linked to a TFS node (or to what node) should have no bearing on the ability of the tool to capture the current shape of the DB in your source control system. I'm really curious what the answer to this is. If you have an older version in a DB linked to TFS and a newer version in another DB, the best workflow I can think of (which isn't very appealing) is using SQL compare to sync the new db to the old and then use SSC to check in. I don't understand why the physical action of a drop against a currently linked db is required to check in the absence of an object. / comments

Don't let the simplicity of the example fool you. Amanda is now managing 100 databases, each with thousands of objects and is put in the same situation... Your suggestion of retrieving the missing ...

0 votes

OUCH, saved a draft a few days ago, and now it's gone.... ugh. The page you've called out helps me understand why the app is working the way it does, but not how to use it in the wild. The real question is how to get the truth into TFS. What's the workflow? I'm used to being able to tell source control what the truth is based on my knowledge of the state of the project, not having the tooling dictate which direction information can flow. This is probably me not having that ah-ha moment of understanding, so please, set me strait! Using the page you've referenced as an example, I'd like to call out the moment I start to stumble... If we compare Amanda's database and the scripts folder in source control, we can see a table in Amanda's database that isn't in source control. We don't have any information about where the difference came from, so we can't tell whether we should commit that table to source control or drop it from Amanda's database. Shouldn't it be up to AMANDA what to do with the table? She's the dev and knows what her intent is. The table should show on both the commit tab as an add (to push the table to SCS) AND the get latest tab as a drop from the database. my situation is this.... Amanda commits the table from her local db to TFS and labels this as v1. Amanda is informed by the master of her universe that v2 now lives on server xyz. (v2 is actually an empty db, so the table isn't there) Amanda opens SSMS and links xyz.db to the same TFS node with the intent of checking in v2. To her surprise, SSC shows (by way of the icon in object explorer) that there are no differences! The commit tab shows nothing. Are v1 and v2 identical? Out of curiosity, Amanda views the Get latest tab and sees that there IS A DIFFERENCE between the DB and TFS that was otherwise unknown to her and SSC is offering to add the table to the v2 db. What should Amanda do? She knows the new db is the truth, but can't check it in because SSC is only offering to go from TFS to DB. / comments

OUCH, saved a draft a few days ago, and now it's gone.... ugh. The page you've called out helps me understand why the app is working the way it does, but not how to use it in the wild. The real q...

0 votes

haleyjason, I truly appreciate the input. I would also (really) appreciate a little background on what's going on. I was under the impression that if an assembly is in the GAC it is available to all .NET processes on the system, this being the purpose of the GAC. I never really paid much attention to the "Process architecture" attribute displayed there. So I'm admitting my naivete in this area and asking for some explanation of what's happening under the covers. If an assembly is in the GAC but showing as MSIL, does that affect the assembly's visibility system wide? I explained what my ultimate goal is, this crystal assembly is in the GAC_MSIL and a web application is failing to fulfill it's reference to that dependency. How should I proceed? / comments

haleyjason, I truly appreciate the input. I would also (really) appreciate a little background on what's going on. I was under the impression that if an assembly is in the GAC it is available to a...

0 votes

How can we help you today?

dwainew

Comments