0

Ohayo
I Hav a Doubt regarding the storage of database..
Suppose i have a college database...among
Master
Model
Tempdb
MSdb
were do i store this college database??in master??
even if i create a new database how to add the new data into the existing database??

3
Contributors
2
Replies
3
Views
5 Years
Discussion Span
Last Post by poojavb
0

if you're creating a new database it is just added to the list that master is in e.g. the list would read:
-collegeDB
-master
-myDB1

if you want to move all data from one DB to another you may have to bulk move everything over in an SQL statement. If you have the SQL script that creates the DB that contains the data you want too move over, simply alter the "CREATE DATABASE DBName;" statement.

0

Right click on ur database and select add new database....ur new database will be different...it wont be added in ur system database...

after ur database is created right click and then select new table to add ur data....

ur tree view in database will be

Servername
    Database
        - System Databases
        - YourNewDatabase
        - and so on
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.