importing a database into ms sql server

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • fresher0021
    New Member
    • Mar 2007
    • 1

    importing a database into ms sql server

    there is a project which has got a dababase .. in sql server .. i neeed to import the database into sql server .. before running the project .. how do i do this ??
  • iburyak
    Recognized Expert Top Contributor
    • Nov 2006
    • 1016

    #2
    In SQL Server Enterprise Manager go to
    Tools - Data Transformation Services - Import Data

    Follow wizard....


    Good Luck.

    Comment

    • ammie
      New Member
      • Mar 2007
      • 2

      #3
      Originally posted by fresher0021
      there is a project which has got a dababase .. in sql server .. i neeed to import the database into sql server .. before running the project .. how do i do this ??
      -----
      Where are you importing the database from? There are several options depending on the platform. You could backup and restore, detach and attach or use Data Transformation Services. All that depends on whether you're geting the data from another sql server, an oracle server, a flat file or etc....

      ammie

      Comment

      Working...