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??

Recommended Answers

All 2 Replies

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.

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
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.