INFO:

a) I have SQL 2005 and SQLExpress running on the same machine.

b) However, through services, I just stopped SQLExpress running try to isolate the problem.

c) If I go to DDT and look at the local connection, "StrataFrame Data Store" that has connection with StartaFrame database.

d) I can create profile and database and tables with no problems.



However, my problems starts as following:

a) I went to "SQL Management Studio) and created a new database "MyDatabase", since I couldn't create a new database in DDT.

b) In DDT, I create a new connection with different name (than "StrataFrame DataStore") to connect to "MyDatabase". and as soon as I try to create new profile, I get error:





c) If I use "StrataFrame Data Store" connection name with a different database name (MyDatabase), I can open/create a profile and tables. However, If I go to "MyDatabase" with SQL Management Studio, no tables are created. In fact I don't know where the tables are created.



Question:

a) Isn't DDT a replacement for SQL Management Studio to create my tables?

b) What am I doing wrong that I can't freely switch between connections? Like in VS and create tables in "MyDatabase" Database?



Thanks!


..ßen

This really is not a safe thing to do from our perspective and presents a lot of other questions and issues.  If automated, you would spend a lot of time sitting around waiting since the entire database environment has to be evaluated each time the meta-data is deployed.  Second, it would make it more difficult to use the DDT to create faux environments, something that we will cover in class.  You will actually spend far less time clicking the button to re-deploy than taking the other approach.  The DDT is not designed to replace SQL Server Management Studio but rather provide a facility to create SQL Server meta-data which can then be packaged and deployed over and over again without using scripts and with a level of intellegence that allows the database to be evaluated and updated without having to go through a series of versions and cycles. 

Thanks Trent;



I do have a couple of alternative questions,but I'll just wait to bring it up in the class when the subjects comes up.

..ßen