Visual Web developer advertises itself to people NEW to ASP.NET
New to ASP.NET is not the same thing as new to database centric development and SQL Server :) The problem you're having would show itself in any other environment.
And the problem, again, isn't what features are needed from your host. That much should be semi-obvious: ASP.NET 2.0 and SQL Server 2005. The issue is that hosts are free to criple this in very, VERY custom ways...so its case by case basis.
THAT BEING SAID: There was new development, semi-recently. SQL Server Express Service Pack 1, comes with the DTS tool.
If you have access to your database server's IP adress, username, and password (you should), you can use that to easily export your database to your server.
After installing SQL Server Express Service Pack 1, by default the wizard will be there:
Using that wizard, you can convert (almost) any data base type, to any other data base type. Its really awesome (it can even handle stuff like text files and excel, if done correctly). It is a bit tricky to use, but documentation is readily available if
you look on google. Point the tool to your source database, point it to the destination, fix your connection string in your web.config (and if you're changing database type totally, you'll probably have to change your APP...like if you move from MySQL to SQL
Server), and you're done.
This is the way it is "normaly" done, but it wasn't available for free until recently.
Contributor
7230 Points
2205 Posts
Re: Visual Web Developer is UTTERLY useless.
Nov 04, 2006 03:51 PM|shados|LINK
New to ASP.NET is not the same thing as new to database centric development and SQL Server :) The problem you're having would show itself in any other environment.
And the problem, again, isn't what features are needed from your host. That much should be semi-obvious: ASP.NET 2.0 and SQL Server 2005. The issue is that hosts are free to criple this in very, VERY custom ways...so its case by case basis.
THAT BEING SAID: There was new development, semi-recently. SQL Server Express Service Pack 1, comes with the DTS tool.
If you have access to your database server's IP adress, username, and password (you should), you can use that to easily export your database to your server.
After installing SQL Server Express Service Pack 1, by default the wizard will be there:
C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe
Using that wizard, you can convert (almost) any data base type, to any other data base type. Its really awesome (it can even handle stuff like text files and excel, if done correctly). It is a bit tricky to use, but documentation is readily available if you look on google. Point the tool to your source database, point it to the destination, fix your connection string in your web.config (and if you're changing database type totally, you'll probably have to change your APP...like if you move from MySQL to SQL Server), and you're done.
This is the way it is "normaly" done, but it wasn't available for free until recently.