DDT Usage Questions


Author
Message
fansanitis
fansanitis
StrataFrame Novice (63 reputation)StrataFrame Novice (63 reputation)StrataFrame Novice (63 reputation)StrataFrame Novice (63 reputation)StrataFrame Novice (63 reputation)StrataFrame Novice (63 reputation)StrataFrame Novice (63 reputation)StrataFrame Novice (63 reputation)StrataFrame Novice (63 reputation)
Group: Forum Members
Posts: 45, Visits: 103
1. I've imported my database into a DDT profile.  I'm assuming that from this point on any changes I make to the database schema in my development environment should also be made in the DDT profile.  Is it best to try and keep the 2 insync manually or would it be better to make the changes to the DDT profile, create an installation package and deploy it to my development environment?

2. It appears the DDT can't create Logins at the database server level or Users at the database level or am I missing something.  It appears the only security it handles is for Microfour's Role-based Security tool.  

Replies
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Great to see you back out here, Greg.  I hope that you had a great vacation!

2. It appears the DDT can't create Logins at the database server level or Users at the database level or am I missing something.  It appears the only security it handles is for Microfour's Role-based Security tool.  

Just to add to Greg's comments in this point.  It sounds like you are trying to create users for SQL Server.  Is this correct?  If so, the DDT doesn't have a section to create and deploy users to a server...though this may be an idea for a future enhancement.  The reason is that security is generally handled at the server level itself and is not generally something that is used for deployment purposes.  Though this is not a bad idea for a future enhancement.  If you have this need you can always create a stored procedure and then execute it to create your initial users.  The reason that this functionality was never added is because security is generally setup at the time SQL Server is installed versus the database.

Greg McGuffey
Greg McGuffey
Strategic Support Team Member (4.8K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
[quote]Trent L. Taylor (03/05/2008)
Great to see you back out here, Greg. I hope that you had a great vacation![\quote]



Yep, it was great. Good to be back too!
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search