milkwood
asked on
Switch to SQLServer from Access
I have written a program that has been used for some time by about 14 users. These users are scattered over a large geographic area in Western Australia and will not have Internet access. The current program uses MS Access as its database. As the size of the database is increasing and added to the fact I would like to take advantage of Entities Framework in Framework 3.5 SP1 it is possible for me to install my program along with SqlServer or something that I can use to all the current users of the program.
I have a working version of the new database on my development machine that has SQLServer 2005. None of the current users will have SQL server.
It is possible?
Can I install SQLexpress and how do I distribute the database. Each user will be using a standalone version of the database.
I have a working version of the new database on my development machine that has SQLServer 2005. None of the current users will have SQL server.
It is possible?
Can I install SQLexpress and how do I distribute the database. Each user will be using a standalone version of the database.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, with any data source that can be hooked into VS - Oracle, MySQL, etc. including XML.
/gustav
/gustav
ASKER
Perhaps I am straying from my original question but this is why I went down the path of SQLServer,
When I try to build the entity model
- Add new item - ADO.NET Entity DataModel - Generate from database - Choose your date connection - Data source - Connection Properties - Change Data source
it will only allow me to select from SQL Server ther isn't a choice of Access/Jet
What am I missing?
When I try to build the entity model
- Add new item - ADO.NET Entity DataModel - Generate from database - Choose your date connection - Data source - Connection Properties - Change Data source
it will only allow me to select from SQL Server ther isn't a choice of Access/Jet
What am I missing?
Sorry, I was mixing it up with something else:
http://forums.asp.net/t/1316099.aspx
I tried myself and also only found out of the box the SQL Server version including the Compact Edition which I still think could be fine for your purpose.
Third-party items are found. Here is one - at a cost though - for MySQL:
http://www.devart.com/mysqlnet/
and SQL Anywhere:
http://www.reuters.com/article/pressRelease/idUS87501+02-Jun-2008+BW20080602
But don't expect too much for using it with Access:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1849284&SiteID=1
/gustav
http://forums.asp.net/t/1316099.aspx
I tried myself and also only found out of the box the SQL Server version including the Compact Edition which I still think could be fine for your purpose.
Third-party items are found. Here is one - at a cost though - for MySQL:
http://www.devart.com/mysqlnet/
and SQL Anywhere:
http://www.reuters.com/article/pressRelease/idUS87501+02-Jun-2008+BW20080602
But don't expect too much for using it with Access:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1849284&SiteID=1
/gustav
Just noticed this which you could find useful:
---
Live Webinar: Using Microsoft ADO.NET Entity Framework with MySQL
Tuesday, November 4, 2008 - 10:00am PST
In this new web seminar you'll learn about the new Entity Framework and how you can access these and other benefits with MySQL:
- Develop your application against SQL Server and then switch it to MySQL with zero code changes
- Optimize your database schema without requiring any code changes in your application
- Use LinQ syntax for type safety in your applications
Register for this Webinar:
http://www.mysql.com/news-and-events/web-seminars/display-204.html
---
/gustav
---
Live Webinar: Using Microsoft ADO.NET Entity Framework with MySQL
Tuesday, November 4, 2008 - 10:00am PST
In this new web seminar you'll learn about the new Entity Framework and how you can access these and other benefits with MySQL:
- Develop your application against SQL Server and then switch it to MySQL with zero code changes
- Optimize your database schema without requiring any code changes in your application
- Use LinQ syntax for type safety in your applications
Register for this Webinar:
http://www.mysql.com/news-and-events/web-seminars/display-204.html
---
/gustav
ASKER