Updating my local database

Apparently there is no Import support in the Express edition.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=156956&SiteID=1

If you're stuck I'm willing to export your DASP data, no charge.
Salute,
Mark

 

That is a very gracious offer and I appreciate it.

However, the problem is this is something I would need to do on a semi-regular basis.

I have a program on visual basic express that needs the data from my database to run. So, once I send it up to the website from web developer and it gets updated by users, myself, etc., the one of my local server (where visual basic is pulling the data from) is no longer up to date.

I need to figure out some way for my visual basic program to get access to my online database.

Any ideas???

 

If youmuster-up$41 you canbuy SQL Server 2005Developer editionon Amazon.

A much harder solution, but doable, is to create an ASP.NET application that will fetch the remote data.
You can save it to XML and from what I've read the Express editions do work with XML.
Of course you can easily work with XML from your local VB apps too.

 

Hi guys,

I want to update my local database from my online ms sql 2005 database. I have successfully used sql studio manager express to dive into my db and update records. but, is there a way i can now use it from there to go back and update my local database. I read a previous post and you suggested using the import/export. i have express, so i don't know if i have the import/export command, if i do, i sure can't find it.

Can you guys help me out?

 

Hi wisemx,

I'm back. I was in the process of purchasing sql developer edition and one of the reviews commented that msde and vwd are not compatible. to install msde he had to uninstall vwd. once he had msde installed he could not re-install any express editions. Do you or anyone else know anything about this? Anyone have any experience with using these two together?

All I want is the import/export feature!

 

I don't know for sure but I do run SQL Server 2005 with Visual Web Express 2008.
But I installed SQL Server 2005 with Visual Studio Pro and I've managed to keep SQL Express off this system.

Even if they aren't compatible with each other you can run them independantly of each other on the same system.

Try that, remove your express tools, install SQL Server then install the new Visual Web express 2008.
Should work.
http://weblogs.asp.net/scottgu/archive/2007/11/20/steps-to-uninstall-vs-2008-beta2-before-installing-the-vs-2008-final-release.aspx