| Author |
 Topic  |
|
|
AskSQLTeam
Ask SQLTeam Question
USA
0 Posts |
|
|
AjarnMark
SQL Slashing Gunting Master
USA
3246 Posts |
 Posted - 01/07/2002 : 16:40:39
|
Graz, nice work! We are getting ready to move to SQL2K and I can't wait to try this out. (SQL 7 doesn't do user-defined functions  ).
A question on the script... There are a couple places where you have this:
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Is that just a leftover from merging multiple scripts, or is there some functional reason for that series I'm not aware of?
--------------------------------------------------------------
1000 Posts, Here I come! I wonder what my new title will be... |
 |
|
|
graz
Chief SQLTeam Crack Dealer
USA
4128 Posts |
Posted - 01/07/2002 : 17:01:09
|
That's left over from using Enterprise Manager to generate the scripts for the objects  No other reason beyond that.
===============================================
Creating tomorrow's legacy systems today.
One crisis at a time. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
Australia
4970 Posts |
Posted - 01/07/2002 : 17:13:10
|
It's good to keep the SET command working like that.
Other it gets all jammed up and stuck. You need to keep it all moving and loosened up, then you need a can of WD40 or something to unjam it.
Damian |
|
|
|
mfemenel
Professor Frink
USA
1414 Posts |
Posted - 01/07/2002 : 17:21:32
|
Merkin The Dimented Yak
Mike
"A program is a device used to convert data into error messages."
|
|
|
|
AjarnMark
SQL Slashing Gunting Master
USA
3246 Posts |
Posted - 01/07/2002 : 17:25:32
|
quote:
Merkin The Dimented Yak
Yeah, he's just gunning for 1400 before I hit 1000. 
--------------------------------------------------------------
1000 Posts, Here I come! I wonder what my new title will be... |
|
|
|
GreatInca
Posting Yak Master
USA
102 Posts |
Posted - 01/07/2002 : 18:58:02
|
How about everying else? Particularly indexes (w/ column order and properties), FKs (w/ columns & properties), Primary/Unique Key (same thing), and all them default constraints everywhere (I made most of them).
|
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
Australia
4970 Posts |
Posted - 01/07/2002 : 19:05:24
|
Once it got to that level of complexity you might be better off buying one of the tools that does this.
Unless you feel like adding the functionality into the script yourself ???
Damian |
|
|
|
Traber
Starting Member
2 Posts |
Posted - 03/05/2002 : 11:12:08
|
| I have aa low tech, low cost solution that I use all the time. I generate SQL scripts in Enterprise Manager, script all objects, include keys, constraints, indexes, etc, one file per object to a separate directories for the source and target. Go to http://www.fileware.com/ and get FileSync and FileDiff (only $15, well worth it, IMO). Point FileSync at the source and target directories and run a binary compare. It will show you every SQL object that is different in green. Try it and you'll like it too. |
|
|
| |
Topic |
|
Article: Comparing Tables
