Member Avatar for mallikaalokam

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
  • 147 Views
  • 4 Hours Discussion Span
  • Latest Post Latest Post by poojavb
Member Avatar for ChrisHunter

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.

Member Avatar for poojavb

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.