Idera SQL Mobile Manager: Reviews/Competitors

Hi,

We're going to be trialing this software in the next few days. I have been looking for reviews and have been unable to find much of anything independent. I would appreciate any input from users. I saw someone using it at PASS last year and they seemed happy with it.

Also, is there anything competitive to this product? I can't find any other SQL Server Management/Administration Tool that can be run from a PDA.

Thanks!

Michelle
Never used it. I have evaluated CompactDBA. http://www.compactsql.com/aboutus.html Would have purchased it at a client I was recently at because the on-call DBAs get driven up a wall with all of the alerts and are pretty much confined to their homes to get a VPN connection for the entire week they are on call. But, one of the managers in the organization (not responsible for our database platform) had a complete hatred of anything mobile for monitoring or management, so it was dead before it ever got started. But, I liked the features and capabilities that it brought.|||

Michelle A. wrote:

Also, is there anything competitive to this product? I can't find any other SQL Server Management/Administration Tool that can be run from a PDA.

I've heard some of our customers are using PocketDBA: http://www.xb.com/products/pocketdba/. I have not personally used it.

Paul A. Mestemaker II

Program Manager

Microsoft SQL Server Manageability

http://blogs.msdn.com/sqlrem/

|||

We have been using this software on Windows Mobile 5 devices for about a year now. Started when it was still owned by CompactDBA.

The product has been great. No more sitting in front of a computer all weekend when we are on call.

The product does everything it says it will and you can add custom scripts as needed. Great for starting jobs and checking quick server issues.

Let me know if you have any specific questions.

Jody

|||Thanks to everyone for the feedback. I evaluated this software. I thought that it made good use of the real estate. But, it lacked some functionality that we required due to the way our IT department is organized. It also seemed kind of expensive but, we didn't actually try to negotiate any bulk discounts or anything. We are using the citrix client for Windows mobile.

Idera SQL Mobile Manager: Reviews/Competitors

Hi,

We're going to be trialing this software in the next few days. I have been looking for reviews and have been unable to find much of anything independent. I would appreciate any input from users. I saw someone using it at PASS last year and they seemed happy with it.

Also, is there anything competitive to this product? I can't find any other SQL Server Management/Administration Tool that can be run from a PDA.

Thanks!

Michelle
Never used it. I have evaluated CompactDBA. http://www.compactsql.com/aboutus.html Would have purchased it at a client I was recently at because the on-call DBAs get driven up a wall with all of the alerts and are pretty much confined to their homes to get a VPN connection for the entire week they are on call. But, one of the managers in the organization (not responsible for our database platform) had a complete hatred of anything mobile for monitoring or management, so it was dead before it ever got started. But, I liked the features and capabilities that it brought.|||

Michelle A. wrote:

Also, is there anything competitive to this product? I can't find any other SQL Server Management/Administration Tool that can be run from a PDA.

I've heard some of our customers are using PocketDBA: http://www.xb.com/products/pocketdba/. I have not personally used it.

Paul A. Mestemaker II

Program Manager

Microsoft SQL Server Manageability

http://blogs.msdn.com/sqlrem/

|||

We have been using this software on Windows Mobile 5 devices for about a year now. Started when it was still owned by CompactDBA.

The product has been great. No more sitting in front of a computer all weekend when we are on call.

The product does everything it says it will and you can add custom scripts as needed. Great for starting jobs and checking quick server issues.

Let me know if you have any specific questions.

Jody

|||Thanks to everyone for the feedback. I evaluated this software. I thought that it made good use of the real estate. But, it lacked some functionality that we required due to the way our IT department is organized. It also seemed kind of expensive but, we didn't actually try to negotiate any bulk discounts or anything. We are using the citrix client for Windows mobile.
sql

Identity crisis: GUID VS. Range

Hi!
I'm developing a project in which I have several Sql Server Express and
Sql Server Mobile 2005 databases and all of them are subscribed to a
central Sql Server 2005 database.
Now, I'm in trouble with the primary keys because if i insert two
registers with the same primary key in two different subscribers, when
the record is merged to the publisher, there is a primary key
collision.
I'm studying two different solutions:
A) Assign ranges of primary keys in each subscriber in order to assign
different IDs in each subscriber
B) User GUID as primary keys, so each primary key will be diferent.
Which are the pros and cons of each solution? Do you think one is best
than the other? Will I have performance problems using GUIDs in a Sql
Server Mobile database?
Thaks in advance!
Jordi
Guid's don't perform as well as int identity. If you use the
newsequentialid() property you will get sequential guids but although
fragmentation is reduced you still don't get the performance of a int data
type.
Your choices are to extend your primary key to include a location identifier
or implement automatic identity range management.
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
<jordics@.gmail.com> wrote in message
news:1166626358.727257.205170@.t46g2000cwa.googlegr oups.com...
> Hi!
> I'm developing a project in which I have several Sql Server Express and
> Sql Server Mobile 2005 databases and all of them are subscribed to a
> central Sql Server 2005 database.
> Now, I'm in trouble with the primary keys because if i insert two
> registers with the same primary key in two different subscribers, when
> the record is merged to the publisher, there is a primary key
> collision.
> I'm studying two different solutions:
> A) Assign ranges of primary keys in each subscriber in order to assign
> different IDs in each subscriber
> B) User GUID as primary keys, so each primary key will be diferent.
> Which are the pros and cons of each solution? Do you think one is best
> than the other? Will I have performance problems using GUIDs in a Sql
> Server Mobile database?
> Thaks in advance!
>
> Jordi
>