Activity overview
Latest activity by rvw
Restore backup WITH MOVE
I'm trying to restore a backup, but get the following error. How can I restore a backup WITH MOVE?
PRD001: Restore - Failed
========================
Restoring full backup - Failed
This operation...
FTI problems: Cannot use a CONTAINS or FREETEXT predicate
I have the following problem. I want to update a database from a development version, and many times I get the following error message:
[7601] Cannot use a CONTAINS or FREETEXT predicate on table ...
FTI problems: Cannot use a CONTAINS or FREETEXT predicate
Sorry, this topic was supposed for SQL Compare, not Data Compare. I've resubmitted it over there:http://www.red-gate.com/MessageBoard/vi ... 5607#25607
I meant the box in the Project Configuration, but I see both are of equal size. The box is really useful when there are hundreds of tables, many with almost equal names. It keeps you from making mistakes by selecting the wrong tables.
If the box is bigger, or if it is resizable, it would be easier to use. / comments
I meant the box in the Project Configuration, but I see both are of equal size. The box is really useful when there are hundreds of tables, many with almost equal names. It keeps you from making mi...
Only update deleted rows when comparing data
I have two databases SOURCE and TARGET, with the target db having rows not present in the source db. I need to remove those rows from the target db, including all dependent records in other tables....
In SQL Data Compare, the filterbox could be a lot wider. Now I have to position the cursor too precisely, or otherwise I click the [x]. I find the filter very useful when selecting tables, especially if many tables have the same start of the name, like TestFooBarAbc and TestFooBarDef etc. Now I type "TestFooB", and see all these tables, but when I want to see TestFooC, I find that the X is too close to the text. Maybe the X and the dropdown arrow could be exchanged? / comments
In SQL Data Compare, the filterbox could be a lot wider. Now I have to position the cursor too precisely, or otherwise I click the [x]. I find the filter very useful when selecting tables, especial...
Manual full backups and scheduled differential backups
I wonder if a scheduled differential backup is takes the last scheduled full backup as base, or the last manual backup made if it is newer than the scheduled full backup. So take the following exam...
Disable splash screen on startup
I would like to disable the splash screen during startup. It takes quite a long time for SQL Backup to start up, and the splash displays in front of all apps, which is quite annoying. How can I dis...