Create db from sql script in VS 2008

Question

I have worked on Visual studio 2008 before, but do not have a lot of experience in working with databases. I have a Sql Script file which contains the complete information about the datanase that i am supposed to replicate and use in my project(which is a web site). Could someone guide me as to how am i supposed to use the Sql script file to create the database...? The language i am using is C#. Thanks a lot...

do you know what kind of database the script is for? (for example SQL Server, Oracle, mysql) — Jonny Cundall
– Jonny Cundall, Commented Sep 5, 2010 at 11:11

Louis Waweru · Accepted Answer · 2010-09-05 11:18:06Z

1

I think you should just run the sql script directly on the SQL engine.

From the command prompt: sqlcmd -i C:\myScript.sql

Or open it in Server Management Studio, and hit execute.

http://msdn.microsoft.com/en-us/library/ms170572.aspx

answered Sep 5, 2010 at 11:18

Louis Waweru

3,66210 gold badges40 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create db from sql script in VS 2008

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related