Recommendations for maintaining shared hosting sites with ASP.NET and SQL Server?

I have been running PHP / MySQL sites with shared hosting providers for the past two years. The daily process is mainly:

  • development in eclipse, one website per folder
  • Download via FileZilla, one website in a folder
  • use PHPMyAdmin to create and manage local and online databases and transfer data from one to another.
  • to backup an online database I dump the database tables in a script and copy them locally

Now I want to create ASP.NET sites with SQL Server 2008 on hosting providers, and I'm trying to enter this new paradigm, I hope some of you can give me some pointers based on your experience and tell me what I'm not doing optimally :

  • I installed both Visual Web Developer 2008 Express and the full version of Visual Studio 2008, both seem to be full-featured ASP.NET website development tools. As for the websites of hosting providers, what can you do with the full version that you cannot do with the express version?
  • I use FileZilla to load my sites that seem to be working fine. Do you use an external FTP program to upload your sites, or do you use Publish or FTP Website in the above IDEs?
  • SQL Server 2008 Management Studio SQL- - SQL Server ( , , , , www.domainbox.de, -, "ASP.NET Enterprise Manager", , , , "Query Box", .) "ASP.NET Enterprise Manager" ASP.NET - , , ... , - SQL Server SQL Server Management Studio, ? ( , 2001 SQL Server 2000 - Enterprise Manager, 10 , , 800 - ).
  • - ? ( , , XML SQL Script)
  • , , , - ? ( SSMS Tools [http://www.ssmstoolspack.com], script, - ).

, , , , , , .. " " , ASP.NET, SQL Server .

+3
2

, , - asp.net.

, Visual Web Developer 2008 express , . microsoft, visual studio 2008, Visual Web Developer 2008 Express: Visual Studio 2008

- , , , . , . - ( , ). . .

SQL-, - SQL. , . , , . , SQL , , .

SQL-, , - . , SQL. .bak , . , .

script sql script SQL. , , . Visio. ( ), script .

.

+3

VS Express vs Standard - Standard - . , .

- , b/c, ( ). Express ( , JavaScript - ), Standard .

/ - - - MSBuild, MS. , -, FTP-. - MSBuild - - - - ASP.NET.

0

All Articles