November 26, 2003 at 12:55 am
Hello!
I have several databases, that my application is using. If I make a new version of my app, it must check the databases, and see if one item is missing in a table, or the field is too small. The way it has been done now is that the application changes the table.
The problem here is security. If all the users would be able to change the database - you all know how that's going to end.
I was thinking of making a job who runs every week to update all the databases with the correct information. Either from a script(.SQL) file, or a SP. I really don't know, but I think some of you have this problem, or a other solution.
Do I script the table with ALTER TABLE, instead of CREATE TABLE? Should that work. Just change all CREATE TABLE with ALTER TABLE inside the sql script?
DTS? Could I use that?
Could anyone help me here? Thanks
-Lars
Please only reply to this newsgroup. All mails would be bounced back.
-Lars
Please only reply to this newsgroup. All mails would be bounced back.
November 26, 2003 at 7:11 am
For Development -> Production server deployment I use SQLDiff. Quite handy for what I use it for. Sort of pointless if you don't have a 'model' db to base it from though.
November 26, 2003 at 7:35 am
quote:
For Development -> Production server deployment I use SQLDiff. Quite handy for what I use it for. Sort of pointless if you don't have a 'model' db to base it from though.
sqldiff - how do you set it up?
-Lars
Please only reply to this newsgroup. All mails would be bounced back.
-Lars
Please only reply to this newsgroup. All mails would be bounced back.
November 26, 2003 at 7:39 am
http://www.adeptsql.com - look for the SQL Diff tool. You can demo it.
Basically you select a two DBs and it compares everything but the data- code in sps, triggers, foreign keys, etc. You can play a little bit with the 'difference detection' but I have just left it at default. It will detect differences in fill factors even. Pretty handy and very easy to use.
Once it 'parses' through both DBs it displays a list of all items. You can hide all without differences. The status of the items is color coded- which db is treated as the 'missing' object one etc. dependds on which one you set as being the master.
November 26, 2003 at 7:55 am
So SQL server itself doesn't has anything like this?
-Lars
Please only reply to this newsgroup. All mails would be bounced back.
-Lars
Please only reply to this newsgroup. All mails would be bounced back.
November 26, 2003 at 9:29 am
Nothing pre-made that I know of.
If you are only wanting to deal with field changes you can write scripts that will look for table differences fairly easily. Personally I don't have any code that parses check constraints etc. but those may be available in the information schema tables.
Honestly though, I like the SQL Diff tool- worth the license cost imo.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply