Which SQL Product? Everywhere Or Express

Jul 31, 2006

We are building a system that has mobile clients (laptop with XP and tablet with XP). These clients have data moving back and forth to a centralised n-tier server based system. The communications is proprietory and are very low bandwidth (5 KByte/sec).

We've decided that the best approach to handling both the reference data (ranging from trivial to a complex list of items - about 2 million rows) and the day-to-day operational data is with a database product rather than attempting to handle it ourselves within code.

The question is - what SQL platform to use? SQL Everywhere seems to be a fairly good choice except that it does not seem to support stored procedures. SQL Express is another possibility but there are concerns about the size of the footprint and managing the database engine and the database itself.

The users of the mobile client are considered computer illiterate and would not be able to manage any database administrative tasks. They only come back to base every three to six months. History has shown remote management of the machine has proven difficult (if not impossible) via the low bandwidth connection.

The machines have 512MB of RAM and only 40GB of disk. They have to support XP, Office, our client, and our GIS client. What is the best answer?

Traditionally we would have used MSDE.

Regards
Paul

View 1 Replies


ADVERTISEMENT

SQL Express Won't Install, Seeing Existing Product Key

Nov 13, 2006



hello,

WIN 2003 web edition. Purchased sql 2005 standard because express was dropping transactions due to too many connections. Installation failed, found out we couldn't install it on 2003 web edition.

Am now trying to re-install express to get the store back online and it is failing, says it sees an existing product key and it is incorrect.

I have uninstalled everything (about 100x's) and even there is nothing in the hkey_local machinesoftwaremicrosoftwindowsuninstall list of guids that has anything to do with sql server, but the install still won't work.

PLEASE answer soon, I have definitely lost this client for good but I would like to get their site up asap.

Thanks

View 7 Replies View Related

Which Express Product Can Connect To A Remote SQL 2005 WG Server?

Oct 25, 2007

Hi --- I would like a few users to be query tables, run (create ?) stored procedures, etc. on a SQL 2005 Workgroup database (the sql server is on a dedicated server)...

Will the Toolkit version (or any other version) support this?

Thanks!

View 1 Replies View Related

Product: Microsoft SQL Server 2005 Express Edition -- Error 1937.

Jan 28, 2008



I am trying to get SQL Express 2005 installed, I have tried this on two PC's within the Domain. Both get the same error. I am the Admin, MCSE since 1999, but I DO NOT know much about SQL. Have search Google for two days, renamed DLL's, installed localy, copied off the CD, update .net, windows updates.... The PC will load SQL 2005 (full version) and 2000, but the app doesnt seem to want anything but the Express version... any ideas would help...

btd43@hotmail.com westcoastpc@gmail.com


Product: Microsoft SQL Server 2005 Express Edition -- Error 1937. An error occurred during the installation of assembly 'Microsoft.SqlServer.Rmo,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0"'. The signature or catalog could not be verified or is not valid. HRESULT: 0x80131045. assembly interface: IAssemblyCacheItem, function: Commit, component: {D1B86CEE-1C5E-4960-B99F-7142D1582B1B}

View 1 Replies View Related

Transact SQL :: Get All Children Of A Product With Product ID In Result Set

Aug 30, 2015

I am using the code below to get all the children of a particular product and it is working fine. How to get the particular product's id in the select statement. for example, i need to show 891 in a separate column for all the records returned by the query below.

DECLARE @Hierarchy TABLE (Product_Id INT, Parent_Product_Id INT)
INSERT INTO @Hierarchy VALUES (123, 234)
INSERT INTO @Hierarchy VALUES (234, 456)
INSERT INTO @Hierarchy VALUES (456, 678)
INSERT INTO @Hierarchy VALUES (678, 891)
INSERT INTO @Hierarchy VALUES (891, NULL)

[Code] .....

View 3 Replies View Related

Product Key

May 8, 2007

Hello I installed MS SQl 2005 the eval version and it has expired. I have bought a copy now and i need to put the product keys in without having to reinstall the program. Is there anyway i can do this with having to reinstall SQl again..
Any help would be great

Randy Martin

View 1 Replies View Related

How To Buy SQL Server 7 Product

Aug 18, 1999

I want to upgrade 5 SQL Server 6.5 production boxes to SQL Server 7. I got
SQL Server 7.0 pricing and licensing list from
www.microsoft.com/sql/70/gen/pricing.htm and I think I should buy 5 SQL
Server 7.0 Combined Product/Version/Competitive Upgrade (Since I have been using SQL Server 6.5, I don’t need to buy the full product. Is this right?). I am not sure if
the upgrade offer (the price is much lower than the full product offer $699/$1399) includes the SQL Server 7.0 both software and access license.


Thanks for any help in advance.

Stella Liu

View 1 Replies View Related

Product Sub-Typing

Jul 14, 2004

Hi,

I am interested in opinions on the following,

main(product_id, short_text, price, type)
productTypes(type_id, type)
productTables(type_id, tableName)
productA(product_id, field1, field2)
productB(product_id, field1, field2)

To retrieve all products of type 'A', one must know the table name, in this case 'productA'.

Here is one method.

Create a table that contains the table name that corresponds to each product type, thus the stored procedure only needs to recieve the type_id which can be used to obtain the name of the respective table.

View 1 Replies View Related

Product Function In Sql

Jul 3, 2006

how can i get the product of two fields in sql server?

ie. i want to get like this, - select price, qty, product(price,qty) as amount from xxx - like this

View 2 Replies View Related

Need To Find Product Key

Feb 6, 2008

I am installing SQL Server x64 on a new server, and I was told to use the same license key we have for the other servers... but no one seems to know where it is. Is there any way I could see the license key for one of the working boxes so I could put it on the new one?

Thanks,

View 3 Replies View Related

SQL Server Product

Jul 20, 2005

Does anyone know of a SQL Server product that would let me do the following?Connect to the instanceConfigure thresholds like,1.Show databases not backed up in the last X days2. Show databases that are full that have logs not backed up in the lastx days/hours.3. Show jobs that have failed in the last x days.I would then like to click a process button and have it bring back anythingthat is outside those thresholds?, any thing like that in a windowsapplication?

View 1 Replies View Related

Product Of A Field

Mar 27, 2007

Hi All,

I have a field with numbers (double datatype) as values and I want a aggregate function that gives me the product of all the values in that field. Is there a way to do that in SSRS?



View 2 Replies View Related

Release Of 1.0 Product

Oct 27, 2006

I can't find any timeframe for the 1.0 release of SQL Server Everywhere. Is this information available?

View 6 Replies View Related

SQL Server Product Key

Sep 20, 2007

How can the licensing product key with which SQL Server is installed be replaced/updated?
If this is possible, will the same procedure apply both to SQL Server 2000 and SQL Server 2005?


Thanks.

View 1 Replies View Related

How To Activate Product

Jun 7, 2006

hi,

I am realy sorry that I am putting this question here since I don't know where to post this question.

We have purchased

Windows server CAL 2003 English OLP NL user CAL

with 5 user license

We got the Microsoft open license agreement after a month or so.

Now I want to know how to proceed with this license.

Since I am newbie to this kindly guide me in this regard.

thanks

View 1 Replies View Related

Interpreting Product A-2 &&>=1.978

Aug 14, 2007

Dear Jamie,
Thanks for the reply.
We have another problem to solve.

on the node we are getting product A -2 >=1.978

What does it mean (-2) ?
It is mentioned as two time slices ago. Please help me to undertand this.
From
menik

View 1 Replies View Related

SQL 2005 Product Key

Jul 20, 2007

When I was setting up my new SQL server I entered the CD-KEY off of the wrong license. I don't want to have to uninstall everything to reinstall it with the new CD-KEY.



Is there a way to change the CD-KEY after installation?

View 3 Replies View Related

Product Search Question

Apr 7, 2007

I have a search box on my website which is used to search the products database.
I will be using the search text in an SQL stored procedure that uses LIKE statements. The search string could realistically contain any character.
How do I prevent SQL injection when any search string is reasonably feasible? .
 

View 2 Replies View Related

Selecting Distinct Product

Sep 6, 2007

I know "select  distinct ProductId from Product  " selects  one product only  one time  how can i apply the same logic in a query like give bellow  SELECT     I.QuoteRequestItemId,     I.ProductId     ,P.StorePartNumber    from    QuoteRequestItem I  left join Product P     on I.ProductId = P.ProductId ie  product with  same productId  should be considered only oncethere should not be more than one row  with  same productId  

View 2 Replies View Related

To Find Sum Product And Subtotal

Mar 12, 2014

Here I have attached excel sheet. I want to do row wise sum, product and then sub total.

View 4 Replies View Related

Product As Aggregate Function?

May 22, 2008

Hi guys,

Does anybody know a convenient way to return the product of a column, similar to something like the 'sum' function?

If I have a table of form id-date-value, I'd like to do something like:

select id, date, product(val)

If not, does anyone know of a way one could structure this as a subquery?


If all else fails, I suppose I'll have to resort to a loop or cursor, but I'd rather not.

Any help would be much appreciated.

View 11 Replies View Related

Eliminating A Cartesian Product

Jul 29, 2013

I have a SQL statement with two left outer joins which connects 3 tables. Vendors, Tracking & Activity. For whatever reason, even though each is a one-to-many relationship, I am able to join 2 tables (from Vendors to Tracking) without an issue. when I then join Activity, I get a Cartesian product.I suspected that 'DISTINCT'.

SELECT DISTINCT CASE
WHEN `vendor`.`companyname` IS NULL then 'No Company Assigned'
ELSE `vendor`.`companyname`
END AS companyNameSQL, `tracking`.`pkgTracking`, CASE

[code]....

View 4 Replies View Related

How To Get Average Amount Of A Product

Oct 15, 2013

I have a table with product_name and introduction_date(when the product was first introduced)as columns. now i wana calculate average as below

if item is sold in previous business year(suppose 2011-12) then avg should be avg price in businessyear(2010-11), if it is newly introduced(suppose 2013-14)then avg should be of current year(2013-14).

Note:- business year Apr-march

View 1 Replies View Related

Need To Select No Product Categories

Jan 19, 2014

I want to get a list of any Categories where ALL the products in that Category are not published (Published = 0). (I want to get the Categories where no products are listed for it). Here are the tables, not sure where to begin :

SELECT [Id], Published
FROM Product
WHERE Published = 0

SELECT [Id] ,[Name]
FROM Category

SELECT [Id] ,[ProductId] ,[CategoryId]
FROM Product_Category_Mapping

View 3 Replies View Related

Installation Of MS SQL And Product Keys

Feb 27, 2007

Steve writes "Probably not a tough question if I wasn't a newbie:

I have two copies of MSSQL 2005 standard edition, intended for installation on a dual proc db server. The server is physically placed in a remote hosting service.

Since I need to install remotely, it's non-trivial how to get the bits over there. I could fed-ex the CDs to the hosting service and have them feed the machine.

However they suggested that they simply use their MSDN version, which I accepted.

But it turns out the MSDN version setup has a pre-populated product key, and does not allow me to entire my own product key(s).

So the questions:

1) besides the product key thing, is there any difference between the MSDN version and the retail version?
2) does it matter that I enter my product key(s) during installation, or do I need to simply posess the keys to be legit?
3) On a dual-proc system, must two keys entered to activate operation on each processor?

So in general, I'm confused as to the technical dependence of installation on the product keys. After $12k I kinda want to use them."

View 2 Replies View Related

How To Design Product Kits

Jul 20, 2005

Hi,I've run into a bit of a sticky design issue. We have products inthree categories which I will call 'A', 'B' and 'C'. We have "kits"which contain three products, one from each category.Below is some sample SQL to set things up, but I need to ensure thateach kit gets three products -- one from each category. Obviously,this basic SQL doesn't allow that. Any suggestions? Do I need adifferent schema design, or is there something else I should belooking at?Cheers,CurtisCREATE TABLE category (id int identity primary key,name varchar(30));CREATE TABLE products (id int identity primary key,name varchar(30),category_id int references category(id));CREATE TABLE kits (id int identity primary key,name varchar(30));CREATE TABLE kit_products (kit_id int references kits(id),product_id int references products(id));

View 1 Replies View Related

Predict Product With Sex And Age Of Customer.

Sep 17, 2006

i have table:

customer(customerid, age,sex....)

orderdata(orderid, customerid,day)

orderdetails(orderid, productid, quantity)

products(productid, productname,...)

now, i want to show some product for customer when i now him age and sex.

e.ct: if he is a man and age =20 i show product : ball, pull, sport close....... if man is a woman , i show lips, babara, t_shirt, skirt....

if man is a chirdren, i will show joy, story for chidren....

how i create my mining model. and how i query for result in DTS

View 1 Replies View Related

Clarification On Product Specification

Sep 15, 2007

http://www.microsoft.com/sql/editions/compact/sscecomparison.mspx
The above link says the pros and cons of two SQL Server 2005 editions.
Document says Compact Edition is not good for €˜When you need a multi-user database server
€™.
What is the meaning of multi-user database?
Does this means the database strictly will not support two database connections at a time?
-Thank you,
Gish

View 1 Replies View Related

How To Change Product Key Once They Boot Up

Nov 8, 2015

We are trying to setup a Virtual Machine for our developers and would like to put SQL Server 2014 (Developer Edition)pre-installed. Each of our devs have their own MSDN accounts so they would have access to their own installers / product keys.So, two questions:How do we pre-install it without a product key or install it then remove the product key?How can they change the product key once they boot up?

View 3 Replies View Related

Developer Edition Product Key

Jul 25, 2007

Ive got a server which I want to install the SQL Server Developer Edition on but it previously had the full version on which has been uninstalled but every time I try to install the dev edition it it its prompting me for a Product key which I know for the developer edition isnt needed. Is there a registry key from the previous install which is triggering this ?

View 3 Replies View Related

Which Sql Server Product To Purchase?

Oct 14, 2006

Hi,

The SQL server 2005 is needed to be put for user's access as database backend for VB.net application. We need only one system for development. Which is best suited for our application?

Any suggestions?

View 1 Replies View Related

Product Level Is Insufficient

Feb 26, 2007

I am receiving the following error when I try to execute an SSIS package that is saved to a structured file. I am using DTExec to execute the package.

Description: The task "Initialize Variables" cannot run on this edition of Integration Services. It requires a higher level edition.

After some research, I was able to find a supporting article in SQL Server 2005 BOL at http://msdn2.microsoft.com/en-us/library/aa337371.aspx

The issue was resolved by installing the Enterprise Edition of SQL Server Integration Services (Windows Service) on the local server (server where the package is saved and executed from). However, this goes against my original anticipation that the SSIS Windows Service would only need to be installed on a machine where I needed to store packages and/or monitor package execution. Not if I wanted to execute packages.

Unfortunately, my package is using advanced options (as identified in the BOL article previously referenced).

Am I missing something??

Sincerely,

Sean Fitzgerald

View 3 Replies View Related

Product Version Query

Sep 7, 2006

I've just downloaded SQL Server Express (with advanced services) from both the main SQL Server Express website and from MSDN.  When I right click on the exe I downloaded and go into properties the Product Version says SQLEVALVER.  To me this implies it is an evaluation.

Can I confirm this is just a mistake and if we start to redistribute the product it won't timeout in the future?  I am sure it is not an evaluation but just want to make absolutely sure.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved