creating an existing db schema baseline

What is the best method of creating schema creation scripts that can be
stored into a version control system. The process of using em to
generate a script is not an appealing option. I am still learning the
MS Sql sys tables and have not found a useful list of all the codes &
types to join the tables etc.

mike

--
Posted via http://dbforums.comwukie <member30544@.dbforums.com> wrote in message news:<3242331.1060980041@.dbforums.com>...
> What is the best method of creating schema creation scripts that can be
> stored into a version control system. The process of using em to
> generate a script is not an appealing option. I am still learning the
> MS Sql sys tables and have not found a useful list of all the codes &
> types to join the tables etc.
>
> mike

I don't like the fact that all source code versioning systems are
using proprietary files instead of proven relational databases
(SourceSafe is not exception from this). The reasons for this are
probably RDBMS licensing costs in the past.

Database schema can be exported also as XML file, which can be further
manipulated. If you and your team have serious schema versioning needs
I suggest you to evaluate Meta Data Services in SQL Server 2000 and
XML. One article about this has been published in the MSDN Magazine:
http://msdn.microsoft.com/msdnmag/i...es/default.aspx

Metadata Repository can be created not only through Enterprise Manager
but also programmatically using Meta Data API. Further information
with examples can be found in Meta Data Services SDK 3.0, which can be
downloaded for free.

Sinisa Catic|||found what I was looking for...

in EM > Tools > Generate SQL Scripts. THis will create the total schema
of the existing database.

mike

any known issues with this tool??

--
Posted via http://dbforums.com

Creating a User

Hi,
I am having a problem while creating an user to a DB.
When I Click users --> New Database User --> it opens an New user
creation window. Under the login name the -drop down I have this User
"user_ABC" listed. (I don't know how this user ended up in this drop
down). I select this login name and keep the deafult user name -->
which is also "user_ABC" , give appropriate rights and click OK. When
I refresh the users list, this user is listed in the list. Allthough
when the user tries to access the database, he gets an error message
as "permission denied" .
To solve this problem, I deleted user "user_ABC" from the users list.
Refresh the list the user "user_ABC" is not present. Try to create a
new user, the deleted user is still exist in the Login Name: drop down
list.
Can anybody please help me understand what is going wrong in creating
a user?
Thanks in Adv.
Sunitadeleting a user from a database does not delete the login.
the login is what appears in the drop down you talk about.
go to security->logins and try managing the user account from there.
Sunita wrote:
> Hi,
> I am having a problem while creating an user to a DB.
> When I Click users --> New Database User --> it opens an New user
> creation window. Under the login name the -drop down I have this User
> "user_ABC" listed. (I don't know how this user ended up in this drop
> down). I select this login name and keep the deafult user name -->
> which is also "user_ABC" , give appropriate rights and click OK. When
> I refresh the users list, this user is listed in the list. Allthough
> when the user tries to access the database, he gets an error message
> as "permission denied" .
> To solve this problem, I deleted user "user_ABC" from the users list.
> Refresh the list the user "user_ABC" is not present. Try to create a
> new user, the deleted user is still exist in the Login Name: drop down
> list.
> Can anybody please help me understand what is going wrong in creating
> a user?
> Thanks in Adv.
> Sunita|||Thanks, it solved my problem.
Sunita
chxxx <chxxx@.dontemailme.com> wrote in message news:<3FB28F16.36350FA8@.dontemailme.com>...
> deleting a user from a database does not delete the login.
> the login is what appears in the drop down you talk about.
> go to security->logins and try managing the user account from there.
>
> Sunita wrote:
> > Hi,
> >
> > I am having a problem while creating an user to a DB.
> >
> > When I Click users --> New Database User --> it opens an New user
> > creation window. Under the login name the -drop down I have this User
> > "user_ABC" listed. (I don't know how this user ended up in this drop
> > down). I select this login name and keep the deafult user name -->
> > which is also "user_ABC" , give appropriate rights and click OK. When
> > I refresh the users list, this user is listed in the list. Allthough
> > when the user tries to access the database, he gets an error message
> > as "permission denied" .
> >
> > To solve this problem, I deleted user "user_ABC" from the users list.
> > Refresh the list the user "user_ABC" is not present. Try to create a
> > new user, the deleted user is still exist in the Login Name: drop down
> > list.
> >
> > Can anybody please help me understand what is going wrong in creating
> > a user?
> >
> > Thanks in Adv.
> > Sunita|||Try setting up the user from Security > Logins rather than
at the database level. You should probably delete the
user from the database first if he is still there and
reset the password at the login level. In Security >
Logins you can select which database the user should have
access to. When you go back to that database, he should
be there. You can set up permissions.
>--Original Message--
>Hi,
>I am having a problem while creating an user to a DB.
>When I Click users --> New Database User --> it opens an
New user
>creation window. Under the login name the -drop down I
have this User
>"user_ABC" listed. (I don't know how this user ended up
in this drop
>down). I select this login name and keep the deafult user
name -->
>which is also "user_ABC" , give appropriate rights and
click OK. When
>I refresh the users list, this user is listed in the
list. Allthough
>when the user tries to access the database, he gets an
error message
>as "permission denied" .
>To solve this problem, I deleted user "user_ABC" from the
users list.
>Refresh the list the user "user_ABC" is not present. Try
to create a
>new user, the deleted user is still exist in the Login
Name: drop down
>list.
>Can anybody please help me understand what is going wrong
in creating
>a user?
>Thanks in Adv.
>Sunita
>.
>

creating a table

I need a module to help me create a SQLServer database table. Is there a module that allows users to specify parameters in the creation of a SQLserver table?well, firing a CREATE TABLE sql statement allows a fine level of control over table creation, as does using the SQL Server client tools. what exactly is your requirement here?sql

Creating a Database for deployment in SQL Server

I am in the process of designing a Windows Forms 2.0 app, and need advice on the recommended deployment/creation of the database for my customers.

Should i use database creation scripts as I have previously used on other apps, or is there a more recognised modern way of creating the DB. I have heard mention of "Sql Server Management Studio" possibly being useful here. If so, will there be issues if one of the customers buying my application uses Oracle?

Any advice appreciated.

Cheers,

StewManagement Studio certainly won't work with Oracle. If your main objective is portability, I suppose scripts is still your best bet.

Creating a Database for deployment in SQL Server

I am in the process of designing a Windows Forms 2.0 app, and need advice on the recommended deployment/creation of the database for my customers.

Should i use database creation scripts as I have previously used on other apps, or is there a more recognised modern way of creating the DB. I have heard mention of "Sql Server Management Studio" possibly being useful here. If so, will there be issues if one of the customers buying my application uses Oracle?

Any advice appreciated.

Cheers,

StewManagement Studio certainly won't work with Oracle. If your main objective is portability, I suppose scripts is still your best bet.