Showing posts with label advance. Show all posts
Showing posts with label advance. Show all posts

Friday, March 30, 2012

MS SQLServer or Pervasive SQL 2000i

Hi All,

Thanks in advance for the help.

We are considering a new Project. This project is going to be totally
web based.

Currently my company is using Pervasive SQL 2000i for there ERP needs.
Will the existing Pervasive SQL 2000i itself serve the purpose OR
should I consider moving to MS SQL Server.

Do assist me in terms of development also i.e. Is it easier to code
with Pervasive SQL 2000i or with MS SQL Server.

Regards
SamsonHi All,

Is there anybody who could help me with the below query.

Regards,
Samson
samsonesau@.gmail.com wrote:

Quote:

Originally Posted by

Hi All,
>
Thanks in advance for the help.
>
>
We are considering a new Project. This project is going to be totally
web based.
>
>
Currently my company is using Pervasive SQL 2000i for there ERP needs.
Will the existing Pervasive SQL 2000i itself serve the purpose OR
should I consider moving to MS SQL Server.
>
Do assist me in terms of development also i.e. Is it easier to code
with Pervasive SQL 2000i or with MS SQL Server.
>
>
Regards
Samson

Monday, March 12, 2012

MS SQL Farm

Hi all, thank in advance for your help.
The company I work for have been predominately using Oracle and IBM DB2. We
do use Sql Server on case by case basis, but there is no well implemented
infrastructure that will help us leverage MS Sql server. There has been
initiative between us (developers) to implement a structured proactively
managed Sql farm, so that we could continue developing MS Sql reliant
solutions. Unfortunately, there is not full time DBA and most of the
implementation and design will be done by us developers. More over we would
have to sell the idea to the management.
Would anyone be able to point to any source of documentation or study cases
that we could learn from? Products that will help implement and manage some
aspects of the environment such as monitoring/notification agents, backup
agents.
We were looking at implementation a solution that will be comprised of the
development/test and production servers with stand by servers . All data for
both the production and test environments will placed on the Network
Appliance storage (Filer iSCSI attached storage).
Regards,
Dominic
Ruski
http://www.microsoft.com/sql/evaluat...s/default.mspx
http://www.microsoft.com/technet/pro.../logship1.mspx
http://www.microsoft.com/sql/default.mspx
Hope this helps
Regards
CT
"Ruski" wrote:

> Hi all, thank in advance for your help.
> The company I work for have been predominately using Oracle and IBM DB2. We
> do use Sql Server on case by case basis, but there is no well implemented
> infrastructure that will help us leverage MS Sql server. There has been
> initiative between us (developers) to implement a structured proactively
> managed Sql farm, so that we could continue developing MS Sql reliant
> solutions. Unfortunately, there is not full time DBA and most of the
> implementation and design will be done by us developers. More over we would
> have to sell the idea to the management.
> Would anyone be able to point to any source of documentation or study cases
> that we could learn from? Products that will help implement and manage some
> aspects of the environment such as monitoring/notification agents, backup
> agents.
> We were looking at implementation a solution that will be comprised of the
> development/test and production servers with stand by servers . All data for
> both the production and test environments will placed on the Network
> Appliance storage (Filer iSCSI attached storage).
> Regards,
> Dominic

Saturday, February 25, 2012

MS SQL 2000 Remote Administration

Hello and thank you in advance for your assistance.
I am trying to rid myself of the necessity of running a local server (2000).
I am currently relying on Enterprise manager in SQL 2000 to administer
databases that are hosted by my ISP.
Is there an application like Enterprise Manager that I can run on my XP box?
Thanks,
Julian
Assuming you have the proper license you can load Enterprise Manager on XP
with no problem. Just install the client tools and not the server itself.
Andrew J. Kelly SQL MVP
"Julian Forniss" <Julian Forniss@.discussions.microsoft.com> wrote in message
news:35AEAE46-919A-4AFA-9A44-53A02F7B726D@.microsoft.com...
> Hello and thank you in advance for your assistance.
> I am trying to rid myself of the necessity of running a local server
> (2000).
> I am currently relying on Enterprise manager in SQL 2000 to administer
> databases that are hosted by my ISP.
> Is there an application like Enterprise Manager that I can run on my XP
> box?
> Thanks,
> Julian
|||Thank you very much.
"Andrew J. Kelly" wrote:

> Assuming you have the proper license you can load Enterprise Manager on XP
> with no problem. Just install the client tools and not the server itself.
> --
> Andrew J. Kelly SQL MVP
>
> "Julian Forniss" <Julian Forniss@.discussions.microsoft.com> wrote in message
> news:35AEAE46-919A-4AFA-9A44-53A02F7B726D@.microsoft.com...
>
>