PDA

View Full Version : sqlexpress vs sql standard editions


jnroche
11-17-2009, 04:58 AM
hi!

im new to all of this especially dot net.

given i bought the add on sql for 10 $ per month and its beeing added to cpanel already, how can i test that database locally if i only have express edition attached to my localhost studio 2008 developer? will it work? what if i use the express edition and save it under app_data folder and just change the connection string in my webconfig to 'not' use '.\SQLEXPRESS' parameter and use whatever is used for the normal sql server? is this possible? its a big deal for me to be able to edit the real sql server with only the free edition of sql server installed on my local pc....

Thanks in advance!

wisemx
11-17-2009, 05:21 AM
Hi,
SQL Server Express is full-featured now, unlike the previous Express versions.
You can use it locally to open and test your remote DASP SQL server, (which is the Web Edition).
Importing and Exporting remote to local, local to remote is very easy:
http://www.dasptv.com/avc-view.aspx?videoid=17&categoryid=1

(That's a Silverlight Streaming Video, give it a minute to load.)
All the best,
Mark