Activity overview
Latest activity by ashaw
We also resolved this issue, if you do not wish to give DBO privilages... by executing GRANT VIEW DEFINITION to [user]
for each of the databases, if you look up the syntax, you can have this applied to individual tables, but in this case you won't want that. The above will give those permissions to all objects in the database. / comments
We also resolved this issue, if you do not wish to give DBO privilages... by executingGRANT VIEW DEFINITION to [user]
for each of the databases, if you look up the syntax, you can have th...
Eddie,
I have referred to that topic and read it multiple times, however this does not suit my needs as I need to syncronize all of the data, the compare works just fine, it's the amount of data that needs to be syncronized following the compare. This is going to be set up as a batch file command prompt compare at some point that will be done unattended at night. I cannot afford to either write multiple compares based on some arbitrary value that I may not know to split the data up. There are many times that there may only be a couple thousand changed records each time, but there are also the occasions that we will have the hundreds of thousands or very soon millions of records change between syncronizations. There has got to be a better solution.
Anthony / comments
Eddie,
I have referred to that topic and read it multiple times, however this does not suit my needs as I need to syncronize all of the data, the compare works just fine, it's the amount of data th...
Slow Data Comparison
OK, I know I've seen this before in a post about how slow the data conversion can be, but I really need some help and I'm hoping my circumstance is slightly different than someone elses.
I am doing...
What do you mean by a clear position? I know that you currently do not support it since it requires a completely different connection and whatnot, I was basically asking that since it's been released in the last couple weeks, if you planned to incorporate it into the SQL Tools or not. / comments
What do you mean by a clear position? I know that you currently do not support it since it requires a completely different connection and whatnot, I was basically asking that since it's been releas...
SQL Compact Edition (formally known as SQL Everywhere)
With the recent release of SQL Compact Edition being supported on the desktop platform as well as the PocketPC/CE environment. What are RedGates plans, if any, for supporting the new (or improved) ...
Thanks Brian for your reply and your apology of the vagueness of the error message. I did talk to our DB admin and he assigned DBO to myself for the db in question and it did work after that.
I also found a similar post in the Sql Compare forum as well... Maybe this could become a FAQ item? / comments
Thanks Brian for your reply and your apology of the vagueness of the error message. I did talk to our DB admin and he assigned DBO to myself for the db in question and it did work after that.
I als...
Here is an image of what I'm experiancing [image] / comments
Here is an image of what I'm experiancing
I also want to clarify... this is occuring when I am creating my project for comparison. It happens when I switch to the second tab to select views and tables. It also occurs if I fill out the server and login information and click Compare Now / comments
I also want to clarify... this is occuring when I am creating my project for comparison. It happens when I switch to the second tab to select views and tables. It also occurs if I fill out the serv...
Specified cast is not valid.
I am getting an error: Specified cast is not valid when trying to view the tables and views within a database that I am trying to data compare against another database.
What might be the cause of t...