Quick one for you, designing a bit of software in VB.net for a company that inputs data into an mdb file and then uses a web service to take this data an insert into an SQL server 2008 R2 database. I know I can have to instances of vb express running, one with the app and one with the web service in, the question is how can I create a SQL database on my computer and test as if I was running in real environment?
I cant afford to actually buy SQL server 2008 and I dont think I need to do I? The issue is the company is asking me if I can script the database rather than them go through and create all the tables and fields individually. I have downloaded what I thought was a free version of SQL server 2008 R2 but the only thing I seem to have is configuration tools > Installation Centre?
Cheers for your help in advance.