Creating a local SQL database for testing

Question

I am creating a VB.net application that will connect to a Microsoft SQL database. I first just want to test the application locally. What is the best/easiest way to set up the database? Do I need to create a SQL server or can I just store the database as a file? I have no idea where to begin.

Adam Robinson · Accepted Answer · 2011-08-02 14:02:06Z

4

Assuming you're targeting SQL Server 2005 or 2008, your best solution would be to install SQL Server Express.

SQL Server 2008 Express

SQL Server 2005 Express

answered Aug 2, 2011 at 14:02

Adam Robinson

186k36 gold badges294 silver badges351 bronze badges

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

3 Comments

Kritz Over a year ago

Once I have it installed, how would I connect to it from Visual Studio?

Adam Robinson Over a year ago

@Johan: Are you asking how to connect to it from the development environment, or from within your application? In both cases, the procedure would be the same as it would be if you were connecting to a remote server.

Kritz Over a year ago

I was referring to the developing environment. I will try again to connect to it. Thanks

Marcus Granström · Accepted Answer · 2011-08-02 14:01:55Z

3

Use an SQL Express instance on your local machine.

Look at: http://www.microsoft.com/sqlserver/en/us/editions/express.aspx to get started.

answered Aug 2, 2011 at 14:01

Marcus Granström

18k1 gold badge24 silver badges21 bronze badges

Collectives™ on Stack Overflow

Creating a local SQL database for testing

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related