5.8.5

The following sample creation script is for SQL server.
CREATE TABLE TestTable
( RID1 int,
RNAME1 nvarchar(1000),
MID1 int,
MNAME1 nvarchar(900),
RKNAME1 nvarchar(50),
MKNAME1 nvarchar(1000),
AKNAME1 nvarchar(50),
timestamp1 datetime,
min_threshold1 nvarchar(50),
value1 nvarchar(50),
max_threshold1 nvarchar(50)
)
The following sample creation script is for Oracle.
CREATE TABLE TestTable (
RID1 INTEGER,
RNAME1 NVARCHAR2(1000),
MID1 INTEGER,
MNAME1 NVARCHAR2(900),
RKNAME1 NVARCHAR2(50),
MKNAME1 NVARCHAR2(1000),
AKNAME1 NVARCHAR2(50),
timestamp1 TIMESTAMP,
min_threshold1 NVARCHAR2(50),
value1 NVARCHAR2(50),
max_threshold1 NVARCHAR2(50)
);
The following sample creation script is for Postgres.
CREATE TABLE TestTable
( RID1 int2 ,
RNAME1 varchar(1000),
MID1 int2,
MNAME1 varchar(900),
RKNAME1 varchar(50),
MKNAME1 varchar(1000),
AKNAME1 varchar(50),
timestamp1 timestamp,
min_threshold1 varchar(20) null,
value1 varchar(20),
max_threshold1 varchar(20) null
)
Limitations
The Repository adapter is designed to extract only a small subset of data for specific purposes. Exporting a
large amount data can result in a significant load on the system.
VMware vCenter Operations Manager Administration Guide
140 VMware, Inc.