Solved

Creating database from script

Posted on 2009-06-29
4
211 Views
Last Modified: 2012-05-07
I have a script that creates a database and empty database tables with constraints from SQL Server 2000. How do I go about running this script using SQL Server 2005 Management Studio to create this database as SQL Server 2005?

Can someone help by guiding me throught the process?
0
Comment
Question by:YZlat
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
ErezMor earned 250 total points
ID: 24738995
in management studio, fo to File->Open->File... and point to the file/s with the scripts
then, when displayed (as tabs with the scripts inside) click the Execute button on each (of course in the right order (db creation, then tables then relations etc...)
good luck
0
 
LVL 6

Expert Comment

by:PIERCGG
ID: 24739009
In SSMS, choose FILE/OPEN and then point to your sql file to open it.  Then execute it.
0
 
LVL 35

Author Comment

by:YZlat
ID: 24739325
Thank you! I ran the script but now I cannot find my stored procedures. Where would they be?
0
 
LVL 35

Author Comment

by:YZlat
ID: 24739332
found them! Thanks!
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Incremental load example 2 53
Order by but want it in specific order 2 34
Grid querry results 41 78
convert null in sql server 12 34
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question