:

New Store Database Size

I want to open a new store and copy the database from another store (as in an HQ/Store setting).
The only store I have now has a 1GB database including transactions for two years. When I used a backup to make a new database for the new store, then delete the transactions, the database is still huge. How can I reduce the database size?
Jason
Reply to
Jason
If you are simply trying to copy customers/items from one store to another, you ought to be able to copy the customer and item tables or at least export/import the customer & item data.
I could help the export/import method, but if someone else has a 'copy tables' method to offer, that would certainly be easier.
Tom
Reply to
=?Utf-8?B?VGVycmlibGUgVG9t?=
I would want all of the other configuration data, like tax, register setups, file paths, etc... Not just customers and items. That would leave out all of the other linked tables anyway, like aliases.
I know storage is cheap, but network bandwidth is finite, and MSDE has a ridiculously low size limit...
On that note, who ships a POS software product that is only good for a couple of years in the average small business because the database gets too big. Microsoft conveniently forgot to mention in the sales literature that an expensive SQL Server upgrade will be required if you enjoy even an inkling of success (transactions).
Anyway, it seems like a bit of a hassle to export/import. There must be a way to do this (or shrink and existing database).
Jason
Reply to
Jason
There's quite a few ways to manage database size for either MSDE or SQLEXPRESS. I've found not to be a big problem even though we are a fairly busy store(average 90-100 transactions a day). At our current rate of database growth it will take 4 years before we even need SQLEXPRESS. Get with your partner to discuss the best options for your situation. Craig
Reply to
Craig
Get with my partner for the solution? The standard response is something like buy a full version of SQL for more than RMS costs. That doesn't make much sense...
With 250 transactions per day, I find that 1-2 years is all MSDE can handle, and that's what RMS ships with. Shame on MS for that... you can't dispute it.
Reply to
Jason
Technicaly sir if you want to reduce the DATABASE size you can delete the journal it takes 40% from the DB size the journal table at store DB (delete from journal where [time] < )
OR If you needn't the transaction history you can do delete transaction (from store operation admin-->connect --> database -->delete transaction) this will delete all transaction but will keep at master data (items, customers, quantity, prices, taxes, currency,?..)
Reply to
ENG RAMY
This is a multi-part message in MIME format.
------=_NextPart_000_0948_01C6D10E.950CCFF0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
Jason,
If you are making the stores correctly in HQ, the database will _not_ = include sales info. You will create a store template that will copy = over the pertinent information for that new store.
Do NOT just copy an existing store database.
--=20 * Get Secure! -
formatting link

You must be using Outlook Express or some other type of newsgroup reader = to see and download the file attachment. If you are not using a reader, = follow the link below to setup Outlook Express. Click on "Open with = newsreader" under the MS Retail Management System on the right.
formatting link

**********
I want to open a new store and copy the database from another store = (as in=20 an HQ/Store setting).
The only store I have now has a 1GB database including transactions = for two=20 years. When I used a backup to make a new database for the new store, = then=20 delete the transactions, the database is still huge. How can I reduce = the=20 database size?
Jason=20
------=_NextPart_000_0948_01C6D10E.950CCFF0 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
Jason, &nbsp; If you are making the stores correctly in HQ, = the=20 database will _not_ include sales info.&nbsp; You will create a store = template=20 that will copy over the pertinent information for that new = store. &nbsp; Do NOT just copy an existing store=20 database. -- *Get Secure! -
formatting link

&nbsp; You must be using Outlook Express or some other type of newsgroup = reader=20 tosee and download the file attachment.&nbsp; If you are not using a = reader,=20 followthe link below to setup Outlook Express.&nbsp; Click on "Open = with=20 newsreader"under the MS Retail Management System on the right. &nbsp;
formatting link
&nbsp; **********
"Jason" &lt; snipped-for-privacy@szumlanski.com&gt; = wrote in=20 message news:ezxyMUfzGHA.3512= @TK2MSFTNGP04.phx.gbl...I=20 want to open a new store and copy the database from another store (as = in=20 an HQ/Store setting).The only store I have now has a 1GB = database=20 including transactions for two years. When I used a backup to make = a new=20 database for the new store, then delete the transactions, the = database is=20 still huge. How can I reduce the database size?Jason=20
------=_NextPart_000_0948_01C6D10E.950CCFF0--
Reply to
Jeff
This is a multi-part message in MIME format.
------=_NextPart_000_0953_01C6D10E.FA35B950 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
Jason,
Different stores can have many years of info in the MSDE database, some = have to move to the full blown version of SQL rather quickly.=20
It all depends on the store
If the need to reprint a receipt is required, then the database grows = quickly. If not, turn off the receipt journaling.
--=20 * Get Secure! -
formatting link

You must be using Outlook Express or some other type of newsgroup reader = to see and download the file attachment. If you are not using a reader, = follow the link below to setup Outlook Express. Click on "Open with = newsreader" under the MS Retail Management System on the right.
formatting link

**********
I would want all of the other configuration data, like tax, register = setups,=20 file paths, etc... Not just customers and items. That would leave out = all of=20 the other linked tables anyway, like aliases.
I know storage is cheap, but network bandwidth is finite, and MSDE has = a=20 ridiculously low size limit...
On that note, who ships a POS software product that is only good for a =
couple of years in the average small business because the database = gets too=20 big. Microsoft conveniently forgot to mention in the sales literature = that=20 an expensive SQL Server upgrade will be required if you enjoy even an=20 inkling of success (transactions).
Anyway, it seems like a bit of a hassle to export/import. There must = be a=20 way to do this (or shrink and existing database).
Jason
"Terrible Tom" wrote in message=20 news: snipped-for-privacy@microsoft.com...
least
'copy
(as=20
for=20
store,=20
reduce the
------=_NextPart_000_0953_01C6D10E.FA35B950 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
Jason, &nbsp; Different stores can have many years of info = in the=20 MSDE database, some have to move to the full blown version of SQL rather =
quickly. &nbsp; It all depends on the store &nbsp; If the need to reprint a receipt is required, = then the=20 database grows quickly.&nbsp; If not, turn off the receipt=20 journaling. -- *Get Secure! -
formatting link

&nbsp; You must be using Outlook Express or some other type of newsgroup = reader=20 tosee and download the file attachment.&nbsp; If you are not using a = reader,=20 followthe link below to setup Outlook Express.&nbsp; Click on "Open = with=20 newsreader"under the MS Retail Management System on the right. &nbsp;
formatting link
&nbsp; **********
"Jason" &lt; snipped-for-privacy@szumlanski.com&gt; = wrote in=20 message news:eHwlfagzGHA.720@T= K2MSFTNGP02.phx.gbl...I=20 would want all of the other configuration data, like tax, register = setups,=20 file paths, etc... Not just customers and items. That would leave = out all=20 of the other linked tables anyway, like aliases.I know = storage is=20 cheap, but network bandwidth is finite, and MSDE has a = ridiculously low=20 size limit...On that note, who ships a POS software product = that is=20 only good for a couple of years in the average small business = because the=20 database gets too big. Microsoft conveniently forgot to mention in = the=20 sales literature that an expensive SQL Server upgrade will be = required if=20 you enjoy even an inkling of success = (transactions).Anyway, it=20 seems like a bit of a hassle to export/import. There must be a way = to do=20 this (or shrink and existing = database).Jason"Terrible=20 Tom" &lt; snipped-for-privacy@GOFISHrobysfurniture.c= om&gt;=20
snipped-for-privacy@microsoft.com...&gt;=20 If you are simply trying to copy customers/items from one store to = &gt;=20 another,&gt; you ought to be able to copy the customer and item = tables or=20 at least&gt; export/import the customer &amp; item = data.&gt;&gt; I=20 could help the export/import method, but if someone else has a = 'copy&gt;=20 tables' method to offer, that would certainly be = easier.&gt;&gt;=20 &gt;&gt;&gt; I want to open = a new=20 store and copy the database from another store (as &gt;&gt; = in&gt;&gt;=20 an HQ/Store setting).&gt;&gt;&gt;&gt; The only store I have = now has a=20 1GB database including transactions for &gt;&gt; two&gt;&gt; = years.=20 When I used a backup to make a new database for the new store, = &gt;&gt;=20 then&gt;&gt; delete the transactions, the database is still huge. = How can=20 I reduce the&gt;&gt; database size?&gt;&gt;&gt;&gt;=20 Jason&gt;&gt;&gt;&gt;&gt;&gt; =
------=_NextPart_000_0953_01C6D10E.FA35B950--
Reply to
Jeff
This is a multi-part message in MIME format.
------=_NextPart_000_0960_01C6D10F.B9C61940 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
Jason,
If you prefer, update to SQL 2005 Express for free (must use RMS 1.3R). = It allows for double the database size. 4 gig.
Its not the 250 transactions per day, its a combination of all of the = other stuff too. Customers, items, POs, etc.
Not sure what your reseller is quoting you, but SQL 2005 Workgroup = Edition with 5 user CALs has a _retail_ price of $739. Its size is = unlimited. A link to its features and requirements; =
formatting link

--=20 * Get Secure! -
formatting link

You must be using Outlook Express or some other type of newsgroup reader = to see and download the file attachment. If you are not using a reader, = follow the link below to setup Outlook Express. Click on "Open with = newsreader" under the MS Retail Management System on the right.
formatting link

**********
Get with my partner for the solution? The standard response is = something=20 like buy a full version of SQL for more than RMS costs. That doesn't = make=20 much sense...
With 250 transactions per day, I find that 1-2 years is all MSDE can = handle,=20 and that's what RMS ships with. Shame on MS for that... you can't = dispute=20 it.
"Craig" wrote in message=20 news: snipped-for-privacy@TK2MSFTNGP05.phx.gbl...
fairly=20
of=20
Get=20
leave=20
has a=20
for a=20
gets=20
literature=20
even=20
must be a=20
least
'copy
store (as=20
transactions for=20
store,=20
reduce=20
------=_NextPart_000_0960_01C6D10F.B9C61940 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
Jason, &nbsp; If you prefer, update to SQL 2005 Express for = free=20 (must use RMS 1.3R).&nbsp; It allows for double the database size. 4=20 gig. &nbsp; Its not the 250 transactions per day, its a = combination=20 of all of the other stuff too.&nbsp; Customers, items, POs, = etc. &nbsp; Not sure what your reseller is quoting you, = but SQL=20 2005 Workgroup Edition with 5 user CALs&nbsp;has a _retail_ price = of&nbsp;=20 $739.&nbsp; Its size is unlimited.&nbsp; A link to its features and=20 requirements;
formatting link
-- *Get Secure! -
formatting link

&nbsp; You must be using Outlook Express or some other type of newsgroup = reader=20 tosee and download the file attachment.&nbsp; If you are not using a = reader,=20 followthe link below to setup Outlook Express.&nbsp; Click on "Open = with=20 newsreader"under the MS Retail Management System on the right. &nbsp;
formatting link
&nbsp; **********
"Jason" &lt; snipped-for-privacy@szumlanski.com&gt; = wrote in=20 message news:On2ZnthzGHA.3656= @TK2MSFTNGP04.phx.gbl...Get=20 with my partner for the solution? The standard response is something = like=20 buy a full version of SQL for more than RMS costs. That doesn't make = much=20 sense...With 250 transactions per day, I find that 1-2 years = is all=20 MSDE can handle, and that's what RMS ships with. Shame on MS for = that...=20 you can't dispute it."Craig" &lt;craig@cctropicalparadise= pets.com&gt;=20
K2MSFTNGP05.phx.gbl...&gt;=20 There's quite a few ways to manage database size for either MSDE or = &gt;=20 SQLEXPRESS. I've found not to be a big problem even though we are a = fairly=20 &gt; busy store(average 90-100 transactions a day). At our current = rate of=20 &gt; database growth it will take 4 years before we even need = SQLEXPRESS.=20 Get &gt; with your partner to discuss the best options for your=20 situation.&gt; Craig&gt; "Jason" &lt; snipped-for-privacy@szumlanski.com&gt; = wrote in=20 message &gt; news:eHwlfagzGHA.720@T= K2MSFTNGP02.phx.gbl...&gt;&gt;I=20 would want all of the other configuration data, like tax, register=20 &gt;&gt;setups, file paths, etc... Not just customers and items. = That=20 would leave &gt;&gt;out all of the other linked tables anyway, = like=20 aliases.&gt;&gt;&gt;&gt; I know storage is cheap, but network=20 bandwidth is finite, and MSDE has a &gt;&gt; ridiculously low size =
limit...&gt;&gt;&gt;&gt; On that note, who ships a POS = software=20 product that is only good for a &gt;&gt; couple of years in the = average=20 small business because the database gets &gt;&gt; too big. = Microsoft=20 conveniently forgot to mention in the sales literature &gt;&gt; = that an=20 expensive SQL Server upgrade will be required if you enjoy even = &gt;&gt;=20 an inkling of success (transactions).&gt;&gt;&gt;&gt; Anyway, = it seems=20 like a bit of a hassle to export/import. There must be a &gt;&gt; = way to=20 do this (or shrink and existing database).&gt;&gt;&gt;&gt;=20 Jason&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt; "Terrible Tom" = &lt; snipped-for-privacy@GOFISHrobysfurniture.c= om&gt;=20 wrote in message &gt;&gt; news:2F8= snipped-for-privacy@microsoft.com...&gt;&gt;&gt;=20 If you are simply trying to copy customers/items from one store to=20 &gt;&gt;&gt; another,&gt;&gt;&gt; you ought to be able to copy = the=20 customer and item tables or at least&gt;&gt;&gt; export/import the =
customer &amp; item data.&gt;&gt;&gt;&gt;&gt;&gt; I could help = the=20 export/import method, but if someone else has a 'copy&gt;&gt;&gt; = tables'=20 method to offer, that would certainly be=20 easier.&gt;&gt;&gt;&gt;&gt;&gt; = Tom&gt;&gt;&gt;&gt;&gt;&gt;=20 &gt;&gt;&gt;&gt;&gt;&gt;&gt; I want to open a = new store=20 and copy the database from another store (as &gt;&gt;&gt;&gt;=20 in&gt;&gt;&gt;&gt; an HQ/Store=20 setting).&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt; The only store I = have now=20 has a 1GB database including transactions for &gt;&gt;&gt;&gt;=20 two&gt;&gt;&gt;&gt; years. When I used a backup to make a new = database for=20 the new store, &gt;&gt;&gt;&gt; then&gt;&gt;&gt;&gt; delete = the=20 transactions, the database is still huge. How can I reduce=20 &gt;&gt;&gt;&gt; the&gt;&gt;&gt;&gt; database=20 size?&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;=20 = Jason&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;= &gt;&gt;&gt;&gt;&gt;=20
------=_NextPart_000_0960_01C6D10F.B9C61940--
Reply to
Jeff

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.