Can I upload a database using visual basic 05 express edition ?

Hi,

Can I upload a database using visual basic 05 express edition ? or do I have to download sql server ?

Thanks

To actualy transfer the database you'll need the SQL Server Management Studio Express tool, -UNLESS- the server on which you will host it has support for mdf files, in which case you can just upload it with an FTP client or whatever tool your host supports.|||

Hi Shados,

Thanks for the reply.

"the server on which you will host it has support for mdf files, in which case you can just upload it with an FTP client or whatever tool your host supports."

Is it possible to upload a database tohttp://www.discountasp.net/ ? and let them host it ? or would I still need a SQL Server Management Tool ?

Thanks

|||

Yes, after a quick glance I saw

"NEWAttach MDF Tool
Transfer your SQL Express/2005
to hosted SQL 2005 Database"

So thats a yes, its what I was talking about. You'll need their SQL Server hosting thing (bottom right on that page you linked me to)

|||

You database mdf file is just a file and you can use FTP client to do this, the only problem is that some server does not allow to put big files to server so it is possible that if your database is too big your transfer can crash, but with most cases it should be OK, but it will take some time. The best solution could be to download database structure, check if everything work and next put data in it.

Thanks

|||

Hi Shados and Jpazgier,

Thanks for your responses. If I did upload data to my database how would I affectly use the uploaded data on my internet site ?

Thanks

|||Same way you would do while developping locally. You might have to change the connection string in the web.config, but thats about it.|||

Hi James,

The Management Studio enable you to access database and do a serials of jobs with GUI.

Whether it is possible to upload the .mdf file to that vendor depends on their capability. You might need to contact them for more information.

|||

Hi James,

The Management Studio enable you to access database and do a serials of jobs with GUI.

Whether it is possible to upload the .mdf file to that vendor depends on their capability. You might need to contact them for more information.

HTH. If this does not answer you question, please feel free to mark the post as Not Answered and post your reply. Thanks!