Hi all,

Short history - C programmer whose day job is working on AS400's over VPN. Now getting into C# and chose VS 2008 using ASP 2.0 MSSQL for web development on IXWebhosting

They don't have 3.5 yet, so I believe I have to use MS SQL 2005, but I can use VS 2008 and point it to 2.0. (If this is wrong, please let me know. It seems to be working as I'm able to use their MSSQL ok so far.)

I'm usually on VPN and don't want to be hitting the remote site, so I'm wanting to set up a localhost mirror for development, and there's where I'm getting messed up.

What do I need to do to duplicate the web database locally and later be able to update the web with my localhost structures? I currently have MS SQL Server 2005 Standard (full, not express) loaded right now. Will that work or do I need Developer or Enterprise? Have been to Microsofts site and through all the post here and am nothing but confused. Don't want to waste money unless I need to, though.


Thanks in advance.