|
 |
asp_databases thread: Access to SQL Sever - Advice!
Message #1 by "Craig Flannigan" <ckf@k...> on Fri, 13 Sep 2002 09:35:20 +0100
|
|
Hi,
Can anyone point me to a good article on the web, or provide some advice and
tips for upgrading from Access to SQL Server?
We run our intranet on around 30 databases, and some of them are now
starting to show signs of stress and are slowing down. I have thought about
moving to SQL Server for sometime now, but I guess the ease at with
databases can be made and edited in Access has appealed to me for so long.
The idea of not having a GUI to see the table content makes me wonder if
development time is increased when dealing with SQL Server - is this true?
How easy is it to Upgrade to SQL Server?
How much of an application will need changing?
What should I look out for?
I hope someone can help me out, and thanks in advance.
Craig.
_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer
Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.
Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.
Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________
Message #2 by "Martijn Snel" <msnel@f...> on Fri, 13 Sep 2002 11:07:56 +0200
|
|
Hi Craig,
i've recently upgraded a site to SQL-server and must say it's pretty easy..
even more for you because I asume you can install and configure your
SQL-server yourself... SQL server does come with a GUI which is a little
different from Access, but once you know it it's easy to work with. About
your questions:
1. Access has an upsizing wizard and SQL-server has an import function for
Access DB.. which should make it pretty easy for you to convert your Access
DB to SQL-server
2. Depending on your app and the way you structured your code it's as easy
as changing your connection-string.. although i've found that SQL-server is
more strickt in certain things.. so you can't 'cut corners' like you can in
Access.. on the difference between Access and SQL-server this is a very
good link: http://www.aspfaq.com/show.asp?id=2214
3. There isn't a lot you really need to look out for. Look at the above link
and try and determine how many fields in your databases might give you
conversion problems.
On the whole I'd say download a trial version of SQL-server and just play
with that for a bit.. I found that I had all the basiscs down in less then a
day.. you can get a trial version (if I'm not mistaken) from:
http://www.microsoft.com/sql/evaluation/trial/default.asp
Hope this helps you some!
Greetz,
Martijn
----- Original Message -----
From: "Craig Flannigan" <ckf@k...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, September 13, 2002 10:35 AM
Subject: [asp_databases] Access to SQL Sever - Advice!
> Hi,
>
> Can anyone point me to a good article on the web, or provide some advice
and
> tips for upgrading from Access to SQL Server?
>
> We run our intranet on around 30 databases, and some of them are now
> starting to show signs of stress and are slowing down. I have thought
about
> moving to SQL Server for sometime now, but I guess the ease at with
> databases can be made and edited in Access has appealed to me for so long.
> The idea of not having a GUI to see the table content makes me wonder if
> development time is increased when dealing with SQL Server - is this true?
>
> How easy is it to Upgrade to SQL Server?
> How much of an application will need changing?
> What should I look out for?
>
> I hope someone can help me out, and thanks in advance.
>
> Craig.
>
>
> _____________________________________________________________________
> Kingfield Heath Ltd. Email Disclaimer
>
> Confidentiality : This email and its attachments are intended for the
> above-named only and may be confidential. If they have come to you in
> error you must take no action based on them, nor must you copy or
> show them to anyone; please reply to this email and highlight the
> error.
>
> Security Warning : Please note that this email has been created in
> the knowledge that the internet is not a 100% secure communications
> medium. We advise that you understand and observe this lack of
> security when emailing us.
>
> Viruses : Although we have taken steps to ensure that this email and
> attachments are free from any virus, we advise that, in keeping with
> good computing practice, the recipient should ensure they are
> actually virus free.
> _____________________________________________________________________
>
Message #3 by "Craig Flannigan" <ckf@k...> on Fri, 13 Sep 2002 11:31:54 +0100
|
|
Thanks Martijn. I'll give that ago.
-----Original Message-----
From: Martijn Snel [mailto:msnel@f...]
Sent: 13 September 2002 10:08
To: ASP Databases
Subject: [asp_databases] Re: Access to SQL Sever - Advice!
Hi Craig,
i've recently upgraded a site to SQL-server and must say it's pretty easy..
even more for you because I asume you can install and configure your
SQL-server yourself... SQL server does come with a GUI which is a little
different from Access, but once you know it it's easy to work with. About
your questions:
1. Access has an upsizing wizard and SQL-server has an import function for
Access DB.. which should make it pretty easy for you to convert your Access
DB to SQL-server
2. Depending on your app and the way you structured your code it's as easy
as changing your connection-string.. although i've found that SQL-server is
more strickt in certain things.. so you can't 'cut corners' like you can in
Access.. on the difference between Access and SQL-server this is a very
good link: http://www.aspfaq.com/show.asp?id=2214
3. There isn't a lot you really need to look out for. Look at the above link
and try and determine how many fields in your databases might give you
conversion problems.
On the whole I'd say download a trial version of SQL-server and just play
with that for a bit.. I found that I had all the basiscs down in less then a
day.. you can get a trial version (if I'm not mistaken) from:
http://www.microsoft.com/sql/evaluation/trial/default.asp
Hope this helps you some!
Greetz,
Martijn
----- Original Message -----
From: "Craig Flannigan" <ckf@k...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, September 13, 2002 10:35 AM
Subject: [asp_databases] Access to SQL Sever - Advice!
> Hi,
>
> Can anyone point me to a good article on the web, or provide some advice
and
> tips for upgrading from Access to SQL Server?
>
> We run our intranet on around 30 databases, and some of them are now
> starting to show signs of stress and are slowing down. I have thought
about
> moving to SQL Server for sometime now, but I guess the ease at with
> databases can be made and edited in Access has appealed to me for so long.
> The idea of not having a GUI to see the table content makes me wonder if
> development time is increased when dealing with SQL Server - is this true?
>
> How easy is it to Upgrade to SQL Server?
> How much of an application will need changing?
> What should I look out for?
>
> I hope someone can help me out, and thanks in advance.
>
> Craig.
>
>
> _____________________________________________________________________
> Kingfield Heath Ltd. Email Disclaimer
>
> Confidentiality : This email and its attachments are intended for the
> above-named only and may be confidential. If they have come to you in
> error you must take no action based on them, nor must you copy or
> show them to anyone; please reply to this email and highlight the
> error.
>
> Security Warning : Please note that this email has been created in
> the knowledge that the internet is not a 100% secure communications
> medium. We advise that you understand and observe this lack of
> security when emailing us.
>
> Viruses : Although we have taken steps to ensure that this email and
> attachments are free from any virus, we advise that, in keeping with
> good computing practice, the recipient should ensure they are
> actually virus free.
> _____________________________________________________________________
>
_____________________________________________________________________
Please contact I.T. Support if you have received this email in error.
This e-mail has been scanned for all viruses by Star Internet.
_____________________________________________________________________
_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer
Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.
Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.
Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________
|
|
|
View Cart
