HOWTO Update several databases!
-
Hello!
Was wondering if any of you has any idea to maintain several database? Do I use a job to do it, with a alter table inside it?
Can I use DTS?
I was blamed for crossposting last time, so if this is not the right group - please help me anyway.
-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. -
quote:
I was blamed for crossposting last time, so if this is not the right group - please help me anyway.I didn't blame you, but most folks here I guess follow all categories, so I guess they notice your post anyway. The 'General' forum is always a good choice in case of uncertainty.
Now then, what do you mean by 'maintain'?
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
OK!
No one blamed me, but enough of that!
Maintain - Here is what I mean.
If I have one database created for a year ago, and another one a half a year ago, and the third one yesterday. My application can't read the first one cause it misses some vital info in a table.
My question is how do I script the database right with alter table, alter column, and so on. Can this be scripted in EM? If it can how do I script this? Can this script run as a job on several databases, just like the maintenance plan?
- 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. -
You mean you want to have all db's structure synchronized?
Do you change your database objects via EM?
If so, you should get in touch with the Query Analyzer. The scripts you write in there can easily be applied at different targets.
What I don't understand is how do you handle change management?
When your app requires something in the db to work properly don't you roll out some update script to have all db's on the latest version?
In addition this one might be of any help
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
The 'ordinary' user should not be able to change the datbase structure. I think that would be a failure. That's why I can't change the structure of the database when I open the project.
I would like to have one script to change these three databases described in the second mail.
I didn't look into the link you sent yet, so I woun't ask for that last one yet
-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. -
quote:
The 'ordinary' user should not be able to change the datbase structure. I think that would be a failure. That's why I can't change the structure of the database when I open the project.agreed, that's your job as a developer or dba. But it is also your job to care for the 'ordinary user' that he can still use the app and the db when changes to either are made. (No flaming, just my thoughts !!! )
You should read the link, because essentially you're trying to compare table structures and apply changes to those which are not on the latest version.
I guess you don't want to spent money on third-party tool?
AFAIK you cannot use EM to only script changes to a table, but I might be wrong...
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply