Comments
Sort by recent activity
Hi,
The way to do this is to create a project in the GUI, then run the command line with the /project switch to specify the .SDC file you just created. Unlike in version 5 and before, we will now respect object mappings set up using the GUI.
Hope that helps,
Robert / comments
Hi,
The way to do this is to create a project in the GUI, then run the command line with the /project switch to specify the .SDC file you just created. Unlike in version 5 and before, we will now r...
Hi,
I'm afraid there isn't - if you want to do this, you'll either need to use the SQL Toolkit and do it programmatic ally, or you could take a look inside a .sdc file with some mappings set using your favourite text editor, though I'm afraid this is somewhat unsupported ;-).
Cheers,
Robert / comments
Hi,
I'm afraid there isn't - if you want to do this, you'll either need to use the SQL Toolkit and do it programmatic ally, or you could take a look inside a .sdc file with some mappings set using ...
Something you might want to try, if you haven't already, is setting a filter on which methods you're profiling. If you limit yourself to only methods in the namespace(s) you're interested in, then hopefully it should mean less overhead.
Hope that helps,
Robert / comments
Something you might want to try, if you haven't already, is setting a filter on which methods you're profiling. If you limit yourself to only methods in the namespace(s) you're interested in, then ...
Hi,
There's a couple of things that might help you here. First off, if you set add environment variable named RGTEMP, and set that to a path with more space available, then Data Compare will use that for temporary storage rather than just your system TEMP location.
Secondly (if this isn't what you're doing already), you can use the WHERE clause editor to only compare a subset of the rows in the table, then synchronize those, then do the rest of the rows.
Hope that helps,
Robert / comments
Hi,
There's a couple of things that might help you here. First off, if you set add environment variable named RGTEMP, and set that to a path with more space available, then Data Compare will use th...
Hi,
Thanks for the post.
We do do this intelligently - we really don't do a "SELECT * FROM target_db WHERE comparisonKey=SomethingOrAnother" for every row in the source ;-).
The reason that a comparison with an empty database doesn't take zero time is that we still have to extract all the data from the source database in order to present it in the UI, and then further to generate the SQL synchronization script.
Hope that helps,
Robert / comments
Hi,
Thanks for the post.
We do do this intelligently - we really don't do a "SELECT * FROM target_db WHERE comparisonKey=SomethingOrAnother" for every row in the source ;-).
The reason that a compa...
Another thing to try if that's still causing you problems is to set a sneaky registry setting:
HKEY_CURRENT_USER\Software\Red Gate\SQL Backup Reader 1\PageCacheLimit
It should be a string value (REG_SZ), and set it to something like 1000. This'll limit you to somewhere in the region of 150MB of cache for non-clustered indexes, which will probably slow it down, but should sort the OOME.
I've just compared one of our samples with 1.7M rows and an NCI, and that stayed under 260MB throughout (the app started at 100MB before I hit compare, then about 160MB went on during the compare).
Cheers,
Robert / comments
Another thing to try if that's still causing you problems is to set a sneaky registry setting:
HKEY_CURRENT_USER\Software\Red Gate\SQL Backup Reader 1\PageCacheLimit
It should be a string value (RE...
Morning,
That's moderately concerning - we've certainly tested it on larger tables than that!
Were you using a clustered or non-clustered index as the comparison key on that table? Non-clustered indexes are generally a lot more painful (and slower) to compare than clustered indexes, and in an effort to keep performance decent, we do use some quite aggressive memory caching of such tables.
This is based on the amount of free physical RAM reported by Windows, but the Alpha / RC1 seems to have used a bit more than I was expecting - in particular if you're comparing two backups to each other (this doubles the memory requirement). I've pushed the maximum down considerably for the final release, so hopefully that should solve the problem...
If you were using a clustered index as the comparison key, and still getting problems, I'm probably more concerned :-s.
Thanks for the report,
Robert / comments
Morning,
That's moderately concerning - we've certainly tested it on larger tables than that!
Were you using a clustered or non-clustered index as the comparison key on that table? Non-clustered in...
Morning - and thanks for the comments!
1. I've just checked this, and as far as I can tell, we try and reselect the object that was previously selected. If you open a project that doesn't contain a similarly named object, we don't select anything, but we do expand all the panes, I think.
2. That's an entirely valid request - it's something we have considered, but it's not something we can get in for this release. However, it has been noted, so hopefully will make it into a future version.
3. The easiest way of doing this is to right-click the project, click "locate on disk", then rename the file in Windows Explorer. However, I should warn you that in RC1, if you rename a project while the "comparison projects" dialog is open, it'll probably get upset :shock:. This has been fixed internally already, and should make it to the final release.
4. I'm afraid I can't reproduce this one. I've just created a simple test database with a couple of tables with FK dependencies, and SDC does correctly order both inserts and deletes (delete from child before parent, and insert into parent before child). The caveat here is that if the target database is a backup, we don't take dependencies into account.
Glad you like the pivot view - so do we :-)
Thanks for the comments,
Robert / comments
Morning - and thanks for the comments!
1. I've just checked this, and as far as I can tell, we try and reselect the object that was previously selected. If you open a project that doesn't contain a...
Excellent! Well done, you had me stumped there :-)
Cheers,
Robert / comments
Excellent! Well done, you had me stumped there :-)
Cheers,
Robert
I'm guessing that's a permissions issue that time. Does the user you're running the service as have administrative privileges?
You might want to check the Windows event log, though sometimes if you try and start an IIS 6 Worker Process without the right access, it just exits silently, which isn't the most helpful thing when it comes to diagnosing problems :-) (this is why we use a service running as LOCAL SYSTEM by default).
Robert / comments
I'm guessing that's a permissions issue that time. Does the user you're running the service as have administrative privileges?
You might want to check the Windows event log, though sometimes if you...