Hi All,
This might not be the right discussion group but I'm having diffuclty
finding documentation, so here is the question. My company uses Access 2000
extensively to create local databases to support some data manipulation and
conversion. Sorry I can't go into detail. Recently we decided to migrate
all of the applications to .NET and therefore it seems logical to migrate to
SQL Server, but other than MSDE the costs would be prohibitive, since we
currently have hundreds of Access databases barring a process change, which
is not likely in the near-term. Needless to say the challenge is defending a
recommendation to move to SQL Server.
Is there a documented comparison between SQL Server and Access other than
the obvious concurrent user, maximum physical memory and database size
advantages you gain with SQL Server?
Any help or guidance is greatly appreciated.
Thanks,
EE_Developer
None that aren't *heavily* biased towards SQL Server. We're working on it
though.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
"EE_Developer" <hfcd@.newsgroup.nospam> wrote in message
news:708DBFC7-36CC-4000-B4AF-58C85E4085EB@.microsoft.com...
> Hi All,
> This might not be the right discussion group but I'm having diffuclty
> finding documentation, so here is the question. My company uses Access
> 2000
> extensively to create local databases to support some data manipulation
> and
> conversion. Sorry I can't go into detail. Recently we decided to migrate
> all of the applications to .NET and therefore it seems logical to migrate
> to
> SQL Server, but other than MSDE the costs would be prohibitive, since we
> currently have hundreds of Access databases barring a process change,
> which
> is not likely in the near-term. Needless to say the challenge is
> defending a
> recommendation to move to SQL Server.
> Is there a documented comparison between SQL Server and Access other than
> the obvious concurrent user, maximum physical memory and database size
> advantages you gain with SQL Server?
> Any help or guidance is greatly appreciated.
> --
> Thanks,
> EE_Developer
|||Hundreds of Access database? It is most likely that many of those hundreds
Access databases have the same or similar table structure and can ans should
be merged. I cannot imagine a business need that many different databases
(if they are not designed duplicated), unless the business is huge one (not
the one that cannot afford SQL Server for $10000).
So, if your business really need many different database (say, 10 to 20),
and each has not too many user access, MSDE may serve your very well. OTH,
after careful analysis, those hundreds small database can be merged into a
couple of central database and you have lot of users (hsay, undreds, or
thousands) then SQL Server is the choice over Access. Take the time needed
to develop and migrate into account, the cost on SQL Server itself really a
very small portion of the cost. Even you do not go with SQL Server, you
probably still need to change the "hundreds Access databases" situation with
a few shared Access databases (again, not knowing your business's size, not
sure Access is still viable option, but possibility is there), the cost of
developing/transferring is far more than SQL Server cost.
"EE_Developer" <hfcd@.newsgroup.nospam> wrote in message
news:708DBFC7-36CC-4000-B4AF-58C85E4085EB@.microsoft.com...
> Hi All,
> This might not be the right discussion group but I'm having diffuclty
> finding documentation, so here is the question. My company uses Access
2000
> extensively to create local databases to support some data manipulation
and
> conversion. Sorry I can't go into detail. Recently we decided to migrate
> all of the applications to .NET and therefore it seems logical to migrate
to
> SQL Server, but other than MSDE the costs would be prohibitive, since we
> currently have hundreds of Access databases barring a process change,
which
> is not likely in the near-term. Needless to say the challenge is
defending a
> recommendation to move to SQL Server.
> Is there a documented comparison between SQL Server and Access other than
> the obvious concurrent user, maximum physical memory and database size
> advantages you gain with SQL Server?
> Any help or guidance is greatly appreciated.
> --
> Thanks,
> EE_Developer
|||Hi
The route through here maybe to use the new sql express 2005 (still in
beta) this is free and has quite a large db size limitation, as yet no
user count limit, this information could change in the future, but I
think the move here is to get almost everyone over to a SQL based
engine rather than access type storage. You will struggle to find any
documentation that is as Graham has said not biased toward SQL. I spend
a lot of my time moving access databases into SQL server, and my two
main selling points are performance and reliability. I use lines like
'After the upgrade you won't need me comming in to fix this anymore'
and I get the 'WOW factor' (if I deliver a new app I expect a WOW
that's so much faster than the old version). I know that this does not
answer your question but I can say that the move has always had a very
positive effect on the users who use the systems that I upgrade to SQL.
Its like driving to work in a Mini when you have a Rolls Royce in the
drive.
Regards
Alex
|||Hello EE_Developer:
You wrote in conference
microsoft.public.access.adp.sqlserver,microsoft.pu blic.sqlserver.server on
Fri, 15 Apr 2005 07:09:13 -0700:
ED> Hi All,
ED> This might not be the right discussion group but I'm having
ED> diffuclty finding documentation, so here is the question. My company
ED> uses Access 2000 extensively to create local databases to support some
ED> data manipulation and conversion. Sorry I can't go into detail.
ED> Recently we decided to migrate all of the applications to .NET and
ED> therefore it seems logical to migrate to SQL Server, but other than
ED> MSDE the costs would be prohibitive, since we currently have hundreds
ED> of Access databases barring a process change, which is not likely in
ED> the near-term. Needless to say the challenge is defending a
ED> recommendation to move to SQL Server.
ED> Is there a documented comparison between SQL Server and Access other
ED> than the obvious concurrent user, maximum physical memory and database
ED> size advantages you gain with SQL Server?
I would start with calculation of the company expenses on supporting those
hundreds of Access databases. Hundreds of them most likely have thousands of
duplicate data instances and hundreds of applications that synchronize the
data between them, which you need to support. Must be quite a nightmare,
thus possible to defend not only moving to sql server, but major rethinking
and redesign of the core processes.
Vadim Rapp
|||tr65
"Vadim Rapp" <vr@.myrealbox.nospam.com> wrote in message
news:eix4gc7QFHA.3716@.TK2MSFTNGP14.phx.gbl...
> Hello EE_Developer:
> You wrote in conference
> microsoft.public.access.adp.sqlserver,microsoft.pu blic.sqlserver.server
on
> Fri, 15 Apr 2005 07:09:13 -0700:
> ED> Hi All,
> ED> This might not be the right discussion group but I'm having
> ED> diffuclty finding documentation, so here is the question. My
company
> ED> uses Access 2000 extensively to create local databases to support
some
> ED> data manipulation and conversion. Sorry I can't go into detail.
> ED> Recently we decided to migrate all of the applications to .NET and
> ED> therefore it seems logical to migrate to SQL Server, but other than
> ED> MSDE the costs would be prohibitive, since we currently have hundreds
> ED> of Access databases barring a process change, which is not likely in
> ED> the near-term. Needless to say the challenge is defending a
> ED> recommendation to move to SQL Server.
> ED> Is there a documented comparison between SQL Server and Access other
> ED> than the obvious concurrent user, maximum physical memory and
database
> ED> size advantages you gain with SQL Server?
> I would start with calculation of the company expenses on supporting those
> hundreds of Access databases. Hundreds of them most likely have thousands
of
> duplicate data instances and hundreds of applications that synchronize the
> data between them, which you need to support. Must be quite a nightmare,
> thus possible to defend not only moving to sql server, but major
rethinking
> and redesign of the core processes.
> Vadim Rapp
>
Showing posts with label company. Show all posts
Showing posts with label company. Show all posts
Tuesday, March 20, 2012
Access 200x SQL Server 2000 Comparison
Hi All,
This might not be the right discussion group but I'm having diffuclty
finding documentation, so here is the question. My company uses Access 200
0
extensively to create local databases to support some data manipulation and
conversion. Sorry I can't go into detail. Recently we decided to migrate
all of the applications to .NET and therefore it seems logical to migrate to
SQL Server, but other than MSDE the costs would be prohibitive, since we
currently have hundreds of Access databases barring a process change, which
is not likely in the near-term. Needless to say the challenge is defending
a
recommendation to move to SQL Server.
Is there a documented comparison between SQL Server and Access other than
the obvious concurrent user, maximum physical memory and database size
advantages you gain with SQL Server?
Any help or guidance is greatly appreciated.
--
Thanks,
EE_DeveloperNone that aren't *heavily* biased towards SQL Server. We're working on it
though.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
--
"EE_Developer" <hfcd@.newsgroup.nospam> wrote in message
news:708DBFC7-36CC-4000-B4AF-58C85E4085EB@.microsoft.com...
> Hi All,
> This might not be the right discussion group but I'm having diffuclty
> finding documentation, so here is the question. My company uses Access
> 2000
> extensively to create local databases to support some data manipulation
> and
> conversion. Sorry I can't go into detail. Recently we decided to migrate
> all of the applications to .NET and therefore it seems logical to migrate
> to
> SQL Server, but other than MSDE the costs would be prohibitive, since we
> currently have hundreds of Access databases barring a process change,
> which
> is not likely in the near-term. Needless to say the challenge is
> defending a
> recommendation to move to SQL Server.
> Is there a documented comparison between SQL Server and Access other than
> the obvious concurrent user, maximum physical memory and database size
> advantages you gain with SQL Server?
> Any help or guidance is greatly appreciated.
> --
> Thanks,
> EE_Developer|||Hundreds of Access database? It is most likely that many of those hundreds
Access databases have the same or similar table structure and can ans should
be merged. I cannot imagine a business need that many different databases
(if they are not designed duplicated), unless the business is huge one (not
the one that cannot afford SQL Server for $10000).
So, if your business really need many different database (say, 10 to 20),
and each has not too many user access, MSDE may serve your very well. OTH,
after careful analysis, those hundreds small database can be merged into a
couple of central database and you have lot of users (hsay, undreds, or
thousands) then SQL Server is the choice over Access. Take the time needed
to develop and migrate into account, the cost on SQL Server itself really a
very small portion of the cost. Even you do not go with SQL Server, you
probably still need to change the "hundreds Access databases" situation with
a few shared Access databases (again, not knowing your business's size, not
sure Access is still viable option, but possibility is there), the cost of
developing/transferring is far more than SQL Server cost.
"EE_Developer" <hfcd@.newsgroup.nospam> wrote in message
news:708DBFC7-36CC-4000-B4AF-58C85E4085EB@.microsoft.com...
> Hi All,
> This might not be the right discussion group but I'm having diffuclty
> finding documentation, so here is the question. My company uses Access
2000
> extensively to create local databases to support some data manipulation
and
> conversion. Sorry I can't go into detail. Recently we decided to migrate
> all of the applications to .NET and therefore it seems logical to migrate
to
> SQL Server, but other than MSDE the costs would be prohibitive, since we
> currently have hundreds of Access databases barring a process change,
which
> is not likely in the near-term. Needless to say the challenge is
defending a
> recommendation to move to SQL Server.
> Is there a documented comparison between SQL Server and Access other than
> the obvious concurrent user, maximum physical memory and database size
> advantages you gain with SQL Server?
> Any help or guidance is greatly appreciated.
> --
> Thanks,
> EE_Developer|||Hi
The route through here maybe to use the new sql express 2005 (still in
beta) this is free and has quite a large db size limitation, as yet no
user count limit, this information could change in the future, but I
think the move here is to get almost everyone over to a SQL based
engine rather than access type storage. You will struggle to find any
documentation that is as Graham has said not biased toward SQL. I spend
a lot of my time moving access databases into SQL server, and my two
main selling points are performance and reliability. I use lines like
'After the upgrade you won't need me comming in to fix this anymore'
and I get the 'WOW factor' (if I deliver a new app I expect a WOW
that's so much faster than the old version). I know that this does not
answer your question but I can say that the move has always had a very
positive effect on the users who use the systems that I upgrade to SQL.
Its like driving to work in a Mini when you have a Rolls Royce in the
drive.
Regards
Alex|||Hello EE_Developer:
You wrote in conference
microsoft.public.access.adp.sqlserver,microsoft.public.sqlserver.server on
Fri, 15 Apr 2005 07:09:13 -0700:
ED> Hi All,
ED> This might not be the right discussion group but I'm having
ED> diffuclty finding documentation, so here is the question. My company
ED> uses Access 2000 extensively to create local databases to support some
ED> data manipulation and conversion. Sorry I can't go into detail.
ED> Recently we decided to migrate all of the applications to .NET and
ED> therefore it seems logical to migrate to SQL Server, but other than
ED> MSDE the costs would be prohibitive, since we currently have hundreds
ED> of Access databases barring a process change, which is not likely in
ED> the near-term. Needless to say the challenge is defending a
ED> recommendation to move to SQL Server.
ED> Is there a documented comparison between SQL Server and Access other
ED> than the obvious concurrent user, maximum physical memory and database
ED> size advantages you gain with SQL Server?
I would start with calculation of the company expenses on supporting those
hundreds of Access databases. Hundreds of them most likely have thousands of
duplicate data instances and hundreds of applications that synchronize the
data between them, which you need to support. Must be quite a nightmare,
thus possible to defend not only moving to sql server, but major rethinking
and redesign of the core processes.
Vadim Rapp
This might not be the right discussion group but I'm having diffuclty
finding documentation, so here is the question. My company uses Access 200
0
extensively to create local databases to support some data manipulation and
conversion. Sorry I can't go into detail. Recently we decided to migrate
all of the applications to .NET and therefore it seems logical to migrate to
SQL Server, but other than MSDE the costs would be prohibitive, since we
currently have hundreds of Access databases barring a process change, which
is not likely in the near-term. Needless to say the challenge is defending
a
recommendation to move to SQL Server.
Is there a documented comparison between SQL Server and Access other than
the obvious concurrent user, maximum physical memory and database size
advantages you gain with SQL Server?
Any help or guidance is greatly appreciated.
--
Thanks,
EE_DeveloperNone that aren't *heavily* biased towards SQL Server. We're working on it
though.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
--
"EE_Developer" <hfcd@.newsgroup.nospam> wrote in message
news:708DBFC7-36CC-4000-B4AF-58C85E4085EB@.microsoft.com...
> Hi All,
> This might not be the right discussion group but I'm having diffuclty
> finding documentation, so here is the question. My company uses Access
> 2000
> extensively to create local databases to support some data manipulation
> and
> conversion. Sorry I can't go into detail. Recently we decided to migrate
> all of the applications to .NET and therefore it seems logical to migrate
> to
> SQL Server, but other than MSDE the costs would be prohibitive, since we
> currently have hundreds of Access databases barring a process change,
> which
> is not likely in the near-term. Needless to say the challenge is
> defending a
> recommendation to move to SQL Server.
> Is there a documented comparison between SQL Server and Access other than
> the obvious concurrent user, maximum physical memory and database size
> advantages you gain with SQL Server?
> Any help or guidance is greatly appreciated.
> --
> Thanks,
> EE_Developer|||Hundreds of Access database? It is most likely that many of those hundreds
Access databases have the same or similar table structure and can ans should
be merged. I cannot imagine a business need that many different databases
(if they are not designed duplicated), unless the business is huge one (not
the one that cannot afford SQL Server for $10000).
So, if your business really need many different database (say, 10 to 20),
and each has not too many user access, MSDE may serve your very well. OTH,
after careful analysis, those hundreds small database can be merged into a
couple of central database and you have lot of users (hsay, undreds, or
thousands) then SQL Server is the choice over Access. Take the time needed
to develop and migrate into account, the cost on SQL Server itself really a
very small portion of the cost. Even you do not go with SQL Server, you
probably still need to change the "hundreds Access databases" situation with
a few shared Access databases (again, not knowing your business's size, not
sure Access is still viable option, but possibility is there), the cost of
developing/transferring is far more than SQL Server cost.
"EE_Developer" <hfcd@.newsgroup.nospam> wrote in message
news:708DBFC7-36CC-4000-B4AF-58C85E4085EB@.microsoft.com...
> Hi All,
> This might not be the right discussion group but I'm having diffuclty
> finding documentation, so here is the question. My company uses Access
2000
> extensively to create local databases to support some data manipulation
and
> conversion. Sorry I can't go into detail. Recently we decided to migrate
> all of the applications to .NET and therefore it seems logical to migrate
to
> SQL Server, but other than MSDE the costs would be prohibitive, since we
> currently have hundreds of Access databases barring a process change,
which
> is not likely in the near-term. Needless to say the challenge is
defending a
> recommendation to move to SQL Server.
> Is there a documented comparison between SQL Server and Access other than
> the obvious concurrent user, maximum physical memory and database size
> advantages you gain with SQL Server?
> Any help or guidance is greatly appreciated.
> --
> Thanks,
> EE_Developer|||Hi
The route through here maybe to use the new sql express 2005 (still in
beta) this is free and has quite a large db size limitation, as yet no
user count limit, this information could change in the future, but I
think the move here is to get almost everyone over to a SQL based
engine rather than access type storage. You will struggle to find any
documentation that is as Graham has said not biased toward SQL. I spend
a lot of my time moving access databases into SQL server, and my two
main selling points are performance and reliability. I use lines like
'After the upgrade you won't need me comming in to fix this anymore'
and I get the 'WOW factor' (if I deliver a new app I expect a WOW
that's so much faster than the old version). I know that this does not
answer your question but I can say that the move has always had a very
positive effect on the users who use the systems that I upgrade to SQL.
Its like driving to work in a Mini when you have a Rolls Royce in the
drive.
Regards
Alex|||Hello EE_Developer:
You wrote in conference
microsoft.public.access.adp.sqlserver,microsoft.public.sqlserver.server on
Fri, 15 Apr 2005 07:09:13 -0700:
ED> Hi All,
ED> This might not be the right discussion group but I'm having
ED> diffuclty finding documentation, so here is the question. My company
ED> uses Access 2000 extensively to create local databases to support some
ED> data manipulation and conversion. Sorry I can't go into detail.
ED> Recently we decided to migrate all of the applications to .NET and
ED> therefore it seems logical to migrate to SQL Server, but other than
ED> MSDE the costs would be prohibitive, since we currently have hundreds
ED> of Access databases barring a process change, which is not likely in
ED> the near-term. Needless to say the challenge is defending a
ED> recommendation to move to SQL Server.
ED> Is there a documented comparison between SQL Server and Access other
ED> than the obvious concurrent user, maximum physical memory and database
ED> size advantages you gain with SQL Server?
I would start with calculation of the company expenses on supporting those
hundreds of Access databases. Hundreds of them most likely have thousands of
duplicate data instances and hundreds of applications that synchronize the
data between them, which you need to support. Must be quite a nightmare,
thus possible to defend not only moving to sql server, but major rethinking
and redesign of the core processes.
Vadim Rapp
Access 200x SQL Server 2000 Comparison
Hi All,
This might not be the right discussion group but I'm having diffuclty
finding documentation, so here is the question. My company uses Access 2000
extensively to create local databases to support some data manipulation and
conversion. Sorry I can't go into detail. Recently we decided to migrate
all of the applications to .NET and therefore it seems logical to migrate to
SQL Server, but other than MSDE the costs would be prohibitive, since we
currently have hundreds of Access databases barring a process change, which
is not likely in the near-term. Needless to say the challenge is defending a
recommendation to move to SQL Server.
Is there a documented comparison between SQL Server and Access other than
the obvious concurrent user, maximum physical memory and database size
advantages you gain with SQL Server?
Any help or guidance is greatly appreciated.
--
Thanks,
EE_DeveloperNone that aren't *heavily* biased towards SQL Server. We're working on it
though.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
--
"EE_Developer" <hfcd@.newsgroup.nospam> wrote in message
news:708DBFC7-36CC-4000-B4AF-58C85E4085EB@.microsoft.com...
> Hi All,
> This might not be the right discussion group but I'm having diffuclty
> finding documentation, so here is the question. My company uses Access
> 2000
> extensively to create local databases to support some data manipulation
> and
> conversion. Sorry I can't go into detail. Recently we decided to migrate
> all of the applications to .NET and therefore it seems logical to migrate
> to
> SQL Server, but other than MSDE the costs would be prohibitive, since we
> currently have hundreds of Access databases barring a process change,
> which
> is not likely in the near-term. Needless to say the challenge is
> defending a
> recommendation to move to SQL Server.
> Is there a documented comparison between SQL Server and Access other than
> the obvious concurrent user, maximum physical memory and database size
> advantages you gain with SQL Server?
> Any help or guidance is greatly appreciated.
> --
> Thanks,
> EE_Developer|||Hundreds of Access database? It is most likely that many of those hundreds
Access databases have the same or similar table structure and can ans should
be merged. I cannot imagine a business need that many different databases
(if they are not designed duplicated), unless the business is huge one (not
the one that cannot afford SQL Server for $10000).
So, if your business really need many different database (say, 10 to 20),
and each has not too many user access, MSDE may serve your very well. OTH,
after careful analysis, those hundreds small database can be merged into a
couple of central database and you have lot of users (hsay, undreds, or
thousands) then SQL Server is the choice over Access. Take the time needed
to develop and migrate into account, the cost on SQL Server itself really a
very small portion of the cost. Even you do not go with SQL Server, you
probably still need to change the "hundreds Access databases" situation with
a few shared Access databases (again, not knowing your business's size, not
sure Access is still viable option, but possibility is there), the cost of
developing/transferring is far more than SQL Server cost.
"EE_Developer" <hfcd@.newsgroup.nospam> wrote in message
news:708DBFC7-36CC-4000-B4AF-58C85E4085EB@.microsoft.com...
> Hi All,
> This might not be the right discussion group but I'm having diffuclty
> finding documentation, so here is the question. My company uses Access
2000
> extensively to create local databases to support some data manipulation
and
> conversion. Sorry I can't go into detail. Recently we decided to migrate
> all of the applications to .NET and therefore it seems logical to migrate
to
> SQL Server, but other than MSDE the costs would be prohibitive, since we
> currently have hundreds of Access databases barring a process change,
which
> is not likely in the near-term. Needless to say the challenge is
defending a
> recommendation to move to SQL Server.
> Is there a documented comparison between SQL Server and Access other than
> the obvious concurrent user, maximum physical memory and database size
> advantages you gain with SQL Server?
> Any help or guidance is greatly appreciated.
> --
> Thanks,
> EE_Developer|||Hi
The route through here maybe to use the new sql express 2005 (still in
beta) this is free and has quite a large db size limitation, as yet no
user count limit, this information could change in the future, but I
think the move here is to get almost everyone over to a SQL based
engine rather than access type storage. You will struggle to find any
documentation that is as Graham has said not biased toward SQL. I spend
a lot of my time moving access databases into SQL server, and my two
main selling points are performance and reliability. I use lines like
'After the upgrade you won't need me comming in to fix this anymore'
and I get the 'WOW factor' (if I deliver a new app I expect a WOW
that's so much faster than the old version). I know that this does not
answer your question but I can say that the move has always had a very
positive effect on the users who use the systems that I upgrade to SQL.
Its like driving to work in a Mini when you have a Rolls Royce in the
drive.
Regards
Alex|||Hello EE_Developer:
You wrote in conference
microsoft.public.access.adp.sqlserver,microsoft.public.sqlserver.server on
Fri, 15 Apr 2005 07:09:13 -0700:
ED> Hi All,
ED> This might not be the right discussion group but I'm having
ED> diffuclty finding documentation, so here is the question. My company
ED> uses Access 2000 extensively to create local databases to support some
ED> data manipulation and conversion. Sorry I can't go into detail.
ED> Recently we decided to migrate all of the applications to .NET and
ED> therefore it seems logical to migrate to SQL Server, but other than
ED> MSDE the costs would be prohibitive, since we currently have hundreds
ED> of Access databases barring a process change, which is not likely in
ED> the near-term. Needless to say the challenge is defending a
ED> recommendation to move to SQL Server.
ED> Is there a documented comparison between SQL Server and Access other
ED> than the obvious concurrent user, maximum physical memory and database
ED> size advantages you gain with SQL Server?
I would start with calculation of the company expenses on supporting those
hundreds of Access databases. Hundreds of them most likely have thousands of
duplicate data instances and hundreds of applications that synchronize the
data between them, which you need to support. Must be quite a nightmare,
thus possible to defend not only moving to sql server, but major rethinking
and redesign of the core processes.
Vadim Rapp|||tr65
"Vadim Rapp" <vr@.myrealbox.nospam.com> wrote in message
news:eix4gc7QFHA.3716@.TK2MSFTNGP14.phx.gbl...
> Hello EE_Developer:
> You wrote in conference
> microsoft.public.access.adp.sqlserver,microsoft.public.sqlserver.server
on
> Fri, 15 Apr 2005 07:09:13 -0700:
> ED> Hi All,
> ED> This might not be the right discussion group but I'm having
> ED> diffuclty finding documentation, so here is the question. My
company
> ED> uses Access 2000 extensively to create local databases to support
some
> ED> data manipulation and conversion. Sorry I can't go into detail.
> ED> Recently we decided to migrate all of the applications to .NET and
> ED> therefore it seems logical to migrate to SQL Server, but other than
> ED> MSDE the costs would be prohibitive, since we currently have hundreds
> ED> of Access databases barring a process change, which is not likely in
> ED> the near-term. Needless to say the challenge is defending a
> ED> recommendation to move to SQL Server.
> ED> Is there a documented comparison between SQL Server and Access other
> ED> than the obvious concurrent user, maximum physical memory and
database
> ED> size advantages you gain with SQL Server?
> I would start with calculation of the company expenses on supporting those
> hundreds of Access databases. Hundreds of them most likely have thousands
of
> duplicate data instances and hundreds of applications that synchronize the
> data between them, which you need to support. Must be quite a nightmare,
> thus possible to defend not only moving to sql server, but major
rethinking
> and redesign of the core processes.
> Vadim Rapp
>
This might not be the right discussion group but I'm having diffuclty
finding documentation, so here is the question. My company uses Access 2000
extensively to create local databases to support some data manipulation and
conversion. Sorry I can't go into detail. Recently we decided to migrate
all of the applications to .NET and therefore it seems logical to migrate to
SQL Server, but other than MSDE the costs would be prohibitive, since we
currently have hundreds of Access databases barring a process change, which
is not likely in the near-term. Needless to say the challenge is defending a
recommendation to move to SQL Server.
Is there a documented comparison between SQL Server and Access other than
the obvious concurrent user, maximum physical memory and database size
advantages you gain with SQL Server?
Any help or guidance is greatly appreciated.
--
Thanks,
EE_DeveloperNone that aren't *heavily* biased towards SQL Server. We're working on it
though.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
--
"EE_Developer" <hfcd@.newsgroup.nospam> wrote in message
news:708DBFC7-36CC-4000-B4AF-58C85E4085EB@.microsoft.com...
> Hi All,
> This might not be the right discussion group but I'm having diffuclty
> finding documentation, so here is the question. My company uses Access
> 2000
> extensively to create local databases to support some data manipulation
> and
> conversion. Sorry I can't go into detail. Recently we decided to migrate
> all of the applications to .NET and therefore it seems logical to migrate
> to
> SQL Server, but other than MSDE the costs would be prohibitive, since we
> currently have hundreds of Access databases barring a process change,
> which
> is not likely in the near-term. Needless to say the challenge is
> defending a
> recommendation to move to SQL Server.
> Is there a documented comparison between SQL Server and Access other than
> the obvious concurrent user, maximum physical memory and database size
> advantages you gain with SQL Server?
> Any help or guidance is greatly appreciated.
> --
> Thanks,
> EE_Developer|||Hundreds of Access database? It is most likely that many of those hundreds
Access databases have the same or similar table structure and can ans should
be merged. I cannot imagine a business need that many different databases
(if they are not designed duplicated), unless the business is huge one (not
the one that cannot afford SQL Server for $10000).
So, if your business really need many different database (say, 10 to 20),
and each has not too many user access, MSDE may serve your very well. OTH,
after careful analysis, those hundreds small database can be merged into a
couple of central database and you have lot of users (hsay, undreds, or
thousands) then SQL Server is the choice over Access. Take the time needed
to develop and migrate into account, the cost on SQL Server itself really a
very small portion of the cost. Even you do not go with SQL Server, you
probably still need to change the "hundreds Access databases" situation with
a few shared Access databases (again, not knowing your business's size, not
sure Access is still viable option, but possibility is there), the cost of
developing/transferring is far more than SQL Server cost.
"EE_Developer" <hfcd@.newsgroup.nospam> wrote in message
news:708DBFC7-36CC-4000-B4AF-58C85E4085EB@.microsoft.com...
> Hi All,
> This might not be the right discussion group but I'm having diffuclty
> finding documentation, so here is the question. My company uses Access
2000
> extensively to create local databases to support some data manipulation
and
> conversion. Sorry I can't go into detail. Recently we decided to migrate
> all of the applications to .NET and therefore it seems logical to migrate
to
> SQL Server, but other than MSDE the costs would be prohibitive, since we
> currently have hundreds of Access databases barring a process change,
which
> is not likely in the near-term. Needless to say the challenge is
defending a
> recommendation to move to SQL Server.
> Is there a documented comparison between SQL Server and Access other than
> the obvious concurrent user, maximum physical memory and database size
> advantages you gain with SQL Server?
> Any help or guidance is greatly appreciated.
> --
> Thanks,
> EE_Developer|||Hi
The route through here maybe to use the new sql express 2005 (still in
beta) this is free and has quite a large db size limitation, as yet no
user count limit, this information could change in the future, but I
think the move here is to get almost everyone over to a SQL based
engine rather than access type storage. You will struggle to find any
documentation that is as Graham has said not biased toward SQL. I spend
a lot of my time moving access databases into SQL server, and my two
main selling points are performance and reliability. I use lines like
'After the upgrade you won't need me comming in to fix this anymore'
and I get the 'WOW factor' (if I deliver a new app I expect a WOW
that's so much faster than the old version). I know that this does not
answer your question but I can say that the move has always had a very
positive effect on the users who use the systems that I upgrade to SQL.
Its like driving to work in a Mini when you have a Rolls Royce in the
drive.
Regards
Alex|||Hello EE_Developer:
You wrote in conference
microsoft.public.access.adp.sqlserver,microsoft.public.sqlserver.server on
Fri, 15 Apr 2005 07:09:13 -0700:
ED> Hi All,
ED> This might not be the right discussion group but I'm having
ED> diffuclty finding documentation, so here is the question. My company
ED> uses Access 2000 extensively to create local databases to support some
ED> data manipulation and conversion. Sorry I can't go into detail.
ED> Recently we decided to migrate all of the applications to .NET and
ED> therefore it seems logical to migrate to SQL Server, but other than
ED> MSDE the costs would be prohibitive, since we currently have hundreds
ED> of Access databases barring a process change, which is not likely in
ED> the near-term. Needless to say the challenge is defending a
ED> recommendation to move to SQL Server.
ED> Is there a documented comparison between SQL Server and Access other
ED> than the obvious concurrent user, maximum physical memory and database
ED> size advantages you gain with SQL Server?
I would start with calculation of the company expenses on supporting those
hundreds of Access databases. Hundreds of them most likely have thousands of
duplicate data instances and hundreds of applications that synchronize the
data between them, which you need to support. Must be quite a nightmare,
thus possible to defend not only moving to sql server, but major rethinking
and redesign of the core processes.
Vadim Rapp|||tr65
"Vadim Rapp" <vr@.myrealbox.nospam.com> wrote in message
news:eix4gc7QFHA.3716@.TK2MSFTNGP14.phx.gbl...
> Hello EE_Developer:
> You wrote in conference
> microsoft.public.access.adp.sqlserver,microsoft.public.sqlserver.server
on
> Fri, 15 Apr 2005 07:09:13 -0700:
> ED> Hi All,
> ED> This might not be the right discussion group but I'm having
> ED> diffuclty finding documentation, so here is the question. My
company
> ED> uses Access 2000 extensively to create local databases to support
some
> ED> data manipulation and conversion. Sorry I can't go into detail.
> ED> Recently we decided to migrate all of the applications to .NET and
> ED> therefore it seems logical to migrate to SQL Server, but other than
> ED> MSDE the costs would be prohibitive, since we currently have hundreds
> ED> of Access databases barring a process change, which is not likely in
> ED> the near-term. Needless to say the challenge is defending a
> ED> recommendation to move to SQL Server.
> ED> Is there a documented comparison between SQL Server and Access other
> ED> than the obvious concurrent user, maximum physical memory and
database
> ED> size advantages you gain with SQL Server?
> I would start with calculation of the company expenses on supporting those
> hundreds of Access databases. Hundreds of them most likely have thousands
of
> duplicate data instances and hundreds of applications that synchronize the
> data between them, which you need to support. Must be quite a nightmare,
> thus possible to defend not only moving to sql server, but major
rethinking
> and redesign of the core processes.
> Vadim Rapp
>
Monday, March 19, 2012
Access
Is Access the best tool to use with SQL 2000 Server for a medium sized
company. This is the direction they plan to go with & it doesn't seem right
to me.
mareDefine "best." Yes, it is a tool, but there are many. It is easy to
develop and query attached SQL Server files.
Sincerely,
Anthony Thomas
"mare" <mare@.discussions.microsoft.com> wrote in message
news:62DC38BD-53BE-4B31-BF5D-92B8B29AFF66@.microsoft.com...
Is Access the best tool to use with SQL 2000 Server for a medium sized
company. This is the direction they plan to go with & it doesn't seem right
to me.
mare|||mare,
To do what? Reporting, querying, full blown app? I personally would say
no. Depends on the skills you have in-house, budget, requirements, etc.
Many variables...
Define medium-sized company for us too. The UK govenment consider a
small or medium sized enterprise (SME) to be fewer than 250 employees,
and annual turnover not exceeding â?¬40million. Your idea might be different.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
mare wrote:
> Is Access the best tool to use with SQL 2000 Server for a medium sized
> company. This is the direction they plan to go with & it doesn't seem right
> to me.
>
> mare
company. This is the direction they plan to go with & it doesn't seem right
to me.
mareDefine "best." Yes, it is a tool, but there are many. It is easy to
develop and query attached SQL Server files.
Sincerely,
Anthony Thomas
"mare" <mare@.discussions.microsoft.com> wrote in message
news:62DC38BD-53BE-4B31-BF5D-92B8B29AFF66@.microsoft.com...
Is Access the best tool to use with SQL 2000 Server for a medium sized
company. This is the direction they plan to go with & it doesn't seem right
to me.
mare|||mare,
To do what? Reporting, querying, full blown app? I personally would say
no. Depends on the skills you have in-house, budget, requirements, etc.
Many variables...
Define medium-sized company for us too. The UK govenment consider a
small or medium sized enterprise (SME) to be fewer than 250 employees,
and annual turnover not exceeding â?¬40million. Your idea might be different.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
mare wrote:
> Is Access the best tool to use with SQL 2000 Server for a medium sized
> company. This is the direction they plan to go with & it doesn't seem right
> to me.
>
> mare
Sunday, February 19, 2012
About repopulate table
Hi Guys,
I have transaction replication setup in my company, and in subscriber there
are some triggers there but not in publication, which is due to business
logic. Now I want to repopulate table's value from publication to subscrition
completely,but I don't want to rerun the snapshot because it will overrite
the triggers in the subscriber. How can do that? Thanks.
Do a no-sync subscription. I think you will want to change the article
properties so that in the snapshot tab, name conflicts section you select
delete all data in table, disable the trigger on the subscriber, run and
deploy the snapshot and then re-enable the trigger.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:ED7B6F2D-4CF7-477D-983A-1AA3740E5A51@.microsoft.com...
> Hi Guys,
> I have transaction replication setup in my company, and in subscriber
> there
> are some triggers there but not in publication, which is due to business
> logic. Now I want to repopulate table's value from publication to
> subscrition
> completely,but I don't want to rerun the snapshot because it will overrite
> the triggers in the subscriber. How can do that? Thanks.
>
I have transaction replication setup in my company, and in subscriber there
are some triggers there but not in publication, which is due to business
logic. Now I want to repopulate table's value from publication to subscrition
completely,but I don't want to rerun the snapshot because it will overrite
the triggers in the subscriber. How can do that? Thanks.
Do a no-sync subscription. I think you will want to change the article
properties so that in the snapshot tab, name conflicts section you select
delete all data in table, disable the trigger on the subscriber, run and
deploy the snapshot and then re-enable the trigger.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:ED7B6F2D-4CF7-477D-983A-1AA3740E5A51@.microsoft.com...
> Hi Guys,
> I have transaction replication setup in my company, and in subscriber
> there
> are some triggers there but not in publication, which is due to business
> logic. Now I want to repopulate table's value from publication to
> subscrition
> completely,but I don't want to rerun the snapshot because it will overrite
> the triggers in the subscriber. How can do that? Thanks.
>
About question of Sql server 2005 cluster.
I am Sql server administrator in a company and I don't have experience of sql
server 2005 failedover cluster. Recently my company decides to use cluster to
conduct disaster recovery strategy. I want to make a preperation about it,
could somebody recommend some online document to read? In addition, I read
some doc that most of that work are conducted by system administrator, such
as network setup, MSCS, SAN and so on, what kind of work that I need to do?
e.g. sql server software installation, monistor and so on? Are those a lot of
difference? Please give me advice? Thanks in advance.
There is no substitute for training and hands-on experience. Check out
www.clusterhelp.com.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:273054A5-23D4-4200-9C6C-CDF8089DB710@.microsoft.com...
I am Sql server administrator in a company and I don't have experience of
sql
server 2005 failedover cluster. Recently my company decides to use cluster
to
conduct disaster recovery strategy. I want to make a preperation about it,
could somebody recommend some online document to read? In addition, I read
some doc that most of that work are conducted by system administrator, such
as network setup, MSCS, SAN and so on, what kind of work that I need to do?
e.g. sql server software installation, monistor and so on? Are those a lot
of
difference? Please give me advice? Thanks in advance.
|||Hi,
You can start with this document
SQL Server 2005 Failover Clustering White Paper
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
Hope this helps,
Ben Nevarez
Senior Database Administrator
"Iter" wrote:
> I am Sql server administrator in a company and I don't have experience of sql
> server 2005 failedover cluster. Recently my company decides to use cluster to
> conduct disaster recovery strategy. I want to make a preperation about it,
> could somebody recommend some online document to read? In addition, I read
> some doc that most of that work are conducted by system administrator, such
> as network setup, MSCS, SAN and so on, what kind of work that I need to do?
> e.g. sql server software installation, monistor and so on? Are those a lot of
> difference? Please give me advice? Thanks in advance.
>
|||Here is a link to a TechNet webcast on using Virtual Server to build a test
and training cluster.
http://support.microsoft.com/kb/891798/en-us
Make your mistakes on the test platform so you are practiced and ready when
you need to build and support the real thing.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:273054A5-23D4-4200-9C6C-CDF8089DB710@.microsoft.com...
>I am Sql server administrator in a company and I don't have experience of
>sql
> server 2005 failedover cluster. Recently my company decides to use cluster
> to
> conduct disaster recovery strategy. I want to make a preperation about it,
> could somebody recommend some online document to read? In addition, I read
> some doc that most of that work are conducted by system administrator,
> such
> as network setup, MSCS, SAN and so on, what kind of work that I need to
> do?
> e.g. sql server software installation, monistor and so on? Are those a lot
> of
> difference? Please give me advice? Thanks in advance.
>
server 2005 failedover cluster. Recently my company decides to use cluster to
conduct disaster recovery strategy. I want to make a preperation about it,
could somebody recommend some online document to read? In addition, I read
some doc that most of that work are conducted by system administrator, such
as network setup, MSCS, SAN and so on, what kind of work that I need to do?
e.g. sql server software installation, monistor and so on? Are those a lot of
difference? Please give me advice? Thanks in advance.
There is no substitute for training and hands-on experience. Check out
www.clusterhelp.com.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:273054A5-23D4-4200-9C6C-CDF8089DB710@.microsoft.com...
I am Sql server administrator in a company and I don't have experience of
sql
server 2005 failedover cluster. Recently my company decides to use cluster
to
conduct disaster recovery strategy. I want to make a preperation about it,
could somebody recommend some online document to read? In addition, I read
some doc that most of that work are conducted by system administrator, such
as network setup, MSCS, SAN and so on, what kind of work that I need to do?
e.g. sql server software installation, monistor and so on? Are those a lot
of
difference? Please give me advice? Thanks in advance.
|||Hi,
You can start with this document
SQL Server 2005 Failover Clustering White Paper
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
Hope this helps,
Ben Nevarez
Senior Database Administrator
"Iter" wrote:
> I am Sql server administrator in a company and I don't have experience of sql
> server 2005 failedover cluster. Recently my company decides to use cluster to
> conduct disaster recovery strategy. I want to make a preperation about it,
> could somebody recommend some online document to read? In addition, I read
> some doc that most of that work are conducted by system administrator, such
> as network setup, MSCS, SAN and so on, what kind of work that I need to do?
> e.g. sql server software installation, monistor and so on? Are those a lot of
> difference? Please give me advice? Thanks in advance.
>
|||Here is a link to a TechNet webcast on using Virtual Server to build a test
and training cluster.
http://support.microsoft.com/kb/891798/en-us
Make your mistakes on the test platform so you are practiced and ready when
you need to build and support the real thing.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:273054A5-23D4-4200-9C6C-CDF8089DB710@.microsoft.com...
>I am Sql server administrator in a company and I don't have experience of
>sql
> server 2005 failedover cluster. Recently my company decides to use cluster
> to
> conduct disaster recovery strategy. I want to make a preperation about it,
> could somebody recommend some online document to read? In addition, I read
> some doc that most of that work are conducted by system administrator,
> such
> as network setup, MSCS, SAN and so on, what kind of work that I need to
> do?
> e.g. sql server software installation, monistor and so on? Are those a lot
> of
> difference? Please give me advice? Thanks in advance.
>
Thursday, February 16, 2012
about migrating to 2005 from 2000.
Hi, since havenot done migration yet, my company is planning to migrate from sql 2000 to sql 2005 server. and i am in group for capacity planning. can anybody suggest me the steps i should be really taking in order to migrate to 2005, if anyone has done the it in real world with database up to 50g.
thanks
Dereki would start with running the upgrade advisor. this does not catch everything. one thing i found annoying is that old stored procedures with words in them that became new keywords in 2K5 broke all over the place.
thanks
Dereki would start with running the upgrade advisor. this does not catch everything. one thing i found annoying is that old stored procedures with words in them that became new keywords in 2K5 broke all over the place.
Subscribe to:
Posts (Atom)