Activity overview
Latest activity by samjones11
One to Many Log shipping -- doable?
Hello!
I use SQL Backup 6.5, and need to set up one to many log shipping (to on site spare SQL server, to off site, to development...)
I have it set up now to the on site warm standby.
Any tips or ...
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...
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...
SQL Compare does not support DB attributes?
(Is there another tool that does this?)
My scripts are usually like this:USE [master]
GO
CREATE DATABASE [FOO] ON PRIMARY
ALTER DATABASE [FOO] SET ANSI_NULL_DEFAULT OFF ...
Suggestion for SQL Compare: Useful error messages
As you can see in this thread: http://www.red-gate.com/MessageBoard/vi ... 1164#31164
SQL Compare is not working out for me (so far).
(Hey, that is what demo versions are for, right? <g>)
Anyway, a...
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 ...
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 ...
Thanks a bunch! I will give it a try! / comments
Thanks a bunch! I will give it a try!
Merge a large stack of SQL files into one file?
(If this is the wrong tool, tell me the right one!)
So our devs work like this:
CreateDB_001.sql // main file, creates the main tables
CreateDB_002.sql // these are all little adds and mods
......