SQL installation

Hi there,
I am now in the midst of trying to set up the website after toying around in my local machine.

I used previously, ./SQLEXPRESS as server name. And windows authentication.
I am now feeling alittle insecure whether i have done this right. This is by far the easiest way I think to get it up and running since i was new to nop.

My store would be targeting around 50000-100K skus.
Should I be using sql compact instead and connection strings?

Your advise is most appreciated.

thanks
Jus

I think I should use the proper sql instead of compact or express.

Pls would some kind soul advise me what I should fill in for the server name and connection string?

Also is there actually a way of converting my current local machine setup to this new setup without having to start all over again?

thanks
Jus

Jus,
I'm new, but had similar questions at one time, so lets see if I can help.

Default SQL SERVER NAME:   <machine name>\SQLEXPRESS
<machine name> is the name of your computer.  You may try 127.0.0.1 as well (I've not tried that.)

To reset the database, delete (or rename) the Settings.txt file in Presentation/Nop.Web/App_Data.   This will cause it to run the setup screen again.  Optionally, you could edit the file as it just contains the link information to your database.

Good Luck,
Randy