| Author |
Topic |
|
Mister Ed
Starting Member
10 Posts |
 Posted - 2010-07-27 : 15:27:29
|
| Hi,I'm tasked with migrating an old ColdFusion web site, with associated Access db, to ASP.NET and MS SQL.I have access to a server with SQL 2000 and SQL 2005 Express. Am using Visual Studio 2010 to develop the new site.Would it be best to move the data to SQL 2005? I am told the Enterprise Manger in the Express edition won't import the existing data easily (I have exported the data from Access to Excel at this point and can easily export it to .CSV).I am thinking VS 2010 will have issues integrating with SQL 2000. But then again this is not super complex stuff we're doing, just serving up content to the website, allowing some forms to query a couple of tables, and creating a simple CMS to manage the data.Thanks,Ed |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-27 : 15:30:13
|
Why would you not use the latest SQL 2008 R 2 version? Then you can sit-tight for a number of years before you have to upgrade ... and do a complete regression test <Grrrrr>Any reason not to use the latest version of ColdFusion? I'm not mad about it, but rewriting it into a new language is a lot of work.But as this is a Microsoft SQL forum, I'll let you upsize Access to SQL Server  |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Mister Ed
Starting Member
10 Posts |
Posted - 2010-07-27 : 15:59:02
|
| Thanks.SQL 2008 make sense, but the client is not interested in buying an upgrade license, not sure that's a battle I want to take on.Would SQL 2008 Express serve the need? We're really talking about a regional website with moderate traffic, and there will be less than 1000 records in the most complex table of the db. The server it would run on is MS Server 2003 SP1, it currently has SQL 2000 and SQL 2005 Express running on it. Could I install 2008 Express side by side? I believe there are some issues with Enterprise manager when this is done, but it sounds like they can be overcome with a little tweaking. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Mister Ed
Starting Member
10 Posts |
Posted - 2010-07-27 : 16:23:05
|
| As far a licensing, I believe they have a full license for SQL 2000 only. Didn't realize Express required a license...Do you think Express 2008, with its limitations, would suffice for this situation? I noted it specifically mentioned websites on the homepage there... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Mister Ed
Starting Member
10 Posts |
Posted - 2010-07-27 : 17:03:49
|
| Well, the Access db is only 75 mb, and that's what their using now. And from what I can see there's a bunch of extraneous tables in there. It looks like it's in need of a good housecleaning.As I said earlier, we're not talking about huge amounts of data here. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
which SQL server to use...