Comments
Sort by recent activity
First: Context
I am brand new to redgate tools.
I am an old (ancient) SQL Server hand (since v4.21....).
Response:
I envision the first screen of SQL Compare (where you set source & target) to have some addl options:
( ) Compare objects only (tables, indexes, sprocs, etc)
( ) Compare objects and db attributes (above + db properties)
[ ] Skip the nice comparison screen and just give me the script
ADDITIONALLY, I would like the script to include verbose comments. For example, say you have an index named FOO in both db's, but the index definition differs.
I would like AT THE TOP of the script a comment block to effect:
** Existing objects that are being changed by this script
<list>
** New objects being created by this script
<list>
Then, next to the DROP/CREATE INDEX (or ALTER, or however you implement it), a comment:
** This index is being redefined based on the definition in the source <source name> as of <date/time>
That is my feedback! / comments
First: Context
I am brand new to redgate tools.
I am an old (ancient) SQL Server hand (since v4.21....).
Response:
I envision the first screen of SQL Compare (where you set source & target) to have...
Thanks. I am new to the redgate kit, so am still getting adjusted...
Yesterday I found myself trying three or four tools (I have the demo), trying to figure out which one to use for a certain task... / comments
Thanks. I am new to the redgate kit, so am still getting adjusted...
Yesterday I found myself trying three or four tools (I have the demo), trying to figure out which one to use for a certain task...
Hello!
Yes, it does tell me the problem table.
Yes, the problem compare does actually have two CREATE blocks (a problem).
The dir of scripts has this:
createdb_001.sql
createdb_002.sql
etc
Then it also had
createdb_008_fullscript.sql
which duplicated the stuff in the 007 and earlier .sql files...
Ergo the issue.
So I dropped the ...fullscript files, and am trying to do a compare of the dir of sql scripts to another dir (which has a single, composite file I built by hand). CURRENT PROBLEM
I am trying to do a compare a dir of sql scripts to another dir (which has a single, composite .sql file I built by hand).
This is failing: SQL Compare - Aborting
X Registering databases
scripts.parts-runningpostprocessing actions
I Failed to compare two elements in the array
I am running: SQL Compare 8.0.0.965 (from the help | about)
So far, I have been unable to get SQL compare to do anything.... Please help! / comments
Hello!
Yes, it does tell me the problem table.
Yes, the problem compare does actually have two CREATE blocks (a problem).
The dir of scripts has this:
createdb_001.sql
createdb_002.sql
etc
Then it ...
David Atkinson wrote:
I would suggest you narrow down what's at fault by trying to compare the set of scripts against a blank folder or empty database to see whether this will compare synchronize correctly.
Cool idea (comparing to a blank folder... excellent, but never would have thought of it!)
Results:
a) My single file parses fine, and gives expected results vis-a-vis schema
b) My folder of files fails, with same error: SQL Compare - Aborting
X Registering databases
scripts.parts-runningpostprocessing actions
I Failed to compare two elements in the array
/ comments
David Atkinson wrote:
I would suggest you narrow down what's at fault by trying to compare the set of scripts against a blank folder or empty database to see whether this will compare synchronize...
Thanks a bunch! I will give it a try! / comments
Thanks a bunch! I will give it a try!
No joy.
I have tried to:
a) Compare a dir of scripts to a db
b) Compare a dir of scripts to a dir of a single, composite script
It all fails.
(Ack, I was going to post a screen shot, but this form seems to not allow attachments?)
The error is:
SQL Compare Aborting
X Registering Databases
...
A duplicate definition was found for the table....
Now what? / comments
No joy.
I have tried to:
a) Compare a dir of scripts to a db
b) Compare a dir of scripts to a dir of a single, composite script
It all fails.
(Ack, I was going to post a screen shot, but this form ...