MS RMS Database Structure

Posted by ben.fiser on October 2, 2006, 7:36 pm

Please log in for more thread options

Can someone give me or guide me on how to obtain the RMS database table
structure and how they are linked? My customer has the RMS software
and would like to run some of his own reports.
Thanks,
Ben

Posted by Allen on October 3, 2006, 4:27 pm

Please log in for more thread options

MS-SQL Server Query Analyzer (Store OP Admin) is difficult to get Table list
as Enterprise Manager (EM).
Thus, Create these procedures; Show and Showtables

CREATE PROCEDURE SHOW
@T_NAME VARCHAR(100)
AS
SELECT CONVERT(CHAR, COLUMN_NAME) AS NAME,
CONVERT(CHAR, DATA_TYPE) AS DATA_TYPE,
ISNULL(CHARACTER_OCTET_LENGTH, NUMERIC_PRECISION) AS SIZE,
IS_NULLABLE AS NULL_
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = @T_NAME
return

CREATE PROCEDURE SHOWTABLES AS
select CONVERT(CHAR,o.name) as TABLE_NAME
from
sysobjects o
where
o.xtype = 'U' and permissions(o.id) != 0 and o.name <> 'dtproperties'
order by o.name
RETURN

Showtables // show tables of db
Show Tablename //show structure of the table

--
ThirdOrbit POS
1167 Chess Dr. Suite B
Foster City, CA 94404
TEL: (650) 212 - 7880
FAX:(650) 212 - 7868
www.ThirdOrbitPOS.com
Email: allen@thirdorbitpos.com

"ben.fiser@gmail.com" wrote:

> Can someone give me or guide me on how to obtain the RMS database table

> structure and how they are linked? My customer has the RMS software

> and would like to run some of his own reports.

> Thanks,

> Ben

Posted by Developain on October 9, 2006, 11:47 pm

Please log in for more thread options

Here's what you can do. Hopefully you have Enterprise Manager. expend the RMS
database right click Diagram and hit new diagram. Add all tables to the
diagram and the tables will automatically link with each other. Showing you
the relationships etc.

Hope this helps

"ben.fiser@gmail.com" wrote:

> Can someone give me or guide me on how to obtain the RMS database table

> structure and how they are linked? My customer has the RMS software

> and would like to run some of his own reports.

> Thanks,

> Ben