<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/aad/ttaad4228m000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Convert / Recover Tables (ttaad4228m000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default"> 
                                 Use this session to convert tables to another database type, or to recover tables. This session is a combination of the <GUIRef href="/baanerp/tt/aad/ttaad4226m000" role="session">Create Sequential Dump of Table (ttaad4226m000)</GUIRef> and <GUIRef href="/baanerp/tt/aad/ttaad4227m000" role="session">Create Table from Sequential Dump (ttaad4227m000)</GUIRef> sessions.</Paragraph>
		</AimSection>
		<GeneralSection><Paragraph class="Default">By converting the tables to another database type you can transfer data from one database to another. By recovering tables you can rebuilt tables by converting data of tables to the same table. For additional refer to the <GUIRef href="/baanerp/tt/aad/ttaad4225m000" role="session">Reorganize Tables (ttaad4225m000)</GUIRef> session.</Paragraph>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">If the tables are converted or recovered with the <GUIRef href="/baanerp/tt/aad/ttaad4228m000#igri.yeno" role="manual">Ignore Referential Integrity Constraints</GUIRef> check box selected, you run the <GUIRef href="/baanerp/tt/aad/ttaad4225m000" role="session">Reorganize Tables (ttaad4225m000)</GUIRef> session afterwards, with the <GUIRef href="/baanerp/tt/aad/ttaad4225m000#rcnt.yeno" role="manual">Repair Reference Counter</GUIRef> check box selected.</Paragraph>
			</Note>
		</GeneralSection>
	</HelpTopic>
	<Fields><FieldHelp ID="comp.f"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Company</Title>
			</Header>
			<FuncDesc>Specifies the company in which you want to convert or recover the specified tables.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="comp.t"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Company</Title>
			</Header>
			<FuncDesc>Specifies the company in which you want to convert or recover the specified tables.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="cpac.f"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Package</Title>
			</Header>
			<FuncDesc>Specifies the <Link href="/baanerp/tt/glossary/glossary#000000000000008" role="glossary">package</Link> in which you want to convert or recover the specified tables.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="cpac.t"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Package</Title>
			</Header>
			<FuncDesc>Specifies the <Link href="/baanerp/tt/glossary/glossary#000000000000008" role="glossary">package</Link> in which you want to convert or recover the specified tables.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="table.f"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table</Title>
			</Header>
			<FuncDesc>Specifies the table which you want to convert or recover.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="table.t"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table</Title>
			</Header>
			<FuncDesc>Specifies the table which you want to convert or recover.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="errf"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Name of the Error File</Title>
			</Header>
			<FuncDesc>Specifies the name of the file that stores the error messages and statistics information.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="serr.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Suppress Error Messages</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, no messages or information will be displayed. Any error messages are stored in the log file, log.bdbpre6.2.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="drtb.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Drop Table after Dump</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, the physical tables are deleted after the dump is created.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="conv.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Convert Tables</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, the tables are converted from one database organization to another.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="trdb"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Target Database</Title>
			</Header>
			<FuncDesc>Specifies the database organization to which the tables are to be converted.</FuncDesc>
			<SimpleSection><Paragraph class="Default">Enter the full database name like in tabledef. Specifications are optional.</Paragraph>
			</SimpleSection>
			<SimpleSection><SectionTitle>
                                    Example
                                 </SectionTitle>
				<Paragraph class="Default">Oracle(ORACLE_HOME=/usr/oracle)</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="dfco.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Create Tables for Different Company</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, the tables are recreated for a different company than the one for which they already exist in the sequential dump file.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="dfco"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Create Tables for Different Company</Title>
			</Header>
			<FuncDesc>Specifies the company number for which the tables will be created.</FuncDesc>
			<SimpleSection><Paragraph class="Default">The name of the dump file contains an extension which specifies the company of the tables in the dump.</Paragraph>
			</SimpleSection>
			<SimpleSection><SectionTitle>
                                    Example
                                 </SectionTitle>
				<Paragraph class="Default">Dump.001 means that this dump contains tables of company 001.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="pacc"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Create Tables for Different Company</Title>
			</Header>
			<FuncDesc>Specifies the <Link href="/baanerp/tt/glossary/glossary#000000000000012" role="glossary">package combination</Link> which belongs to the company for which you want to convert or recover tables.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="apnd.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Append if Table Exists</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, the data from the sequential dump file is appended to the table.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ovwr.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Overwrite Duplicate Records from Dump</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, the record of the sequential dump overwrites the existing duplicate record in the table.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="dltb.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Delete Existing Tables</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, the tables which are already present are deleted before the new tables are created.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">This option cannot be used if the <GUIRef href="/baanerp/tt/aad/ttaad4228m000#apnd.yeno" role="manual">Append if Table Exists</GUIRef> check box is selected.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="rbix.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Create Rows before Index</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, the index will be build after all records of a table are created. This option speeds up the process.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="errt.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">File to Store Table Names not Created</Title>
			</Header>
			<FuncDesc>you can specify the file in which unsuccessfully created tables are stored.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="errt"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">File to Store Table Names not Created</Title>
			</Header>
			<FuncDesc>Specifies the name of the database driver as specified in the ${BSE}/lib/ipc_info file, or the driver with full path name, or the host name where the driver is located.</FuncDesc>
			<SimpleSection><SectionTitle>
                                    Example
                                 </SectionTitle>
				<Paragraph class="Default">Oracle(ORACLE_HOME=/usr/oracle)</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ddmc.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Disable Domain Constraints</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, the domain constraints are disabled. There is no check to make sure that the data of a table field meets the requirements of the domain in the table definition.</FuncDesc>
			<SimpleSection><SectionTitle>
                                    Example
                                 </SectionTitle>
				<Paragraph class="Default">It is possible that a string of 30 characters is placed in a field with a string domain of only 15 characters. In that case you loose information.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="igri.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Ignore Referential Integrity Constraints</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, the referential integrity constraints are ignored.</FuncDesc>
			<SimpleSection><Paragraph class="Default">It is possible that the tables created from the dump have a reference to tables that will be created later from the same dump. Because these tables do not exist yet, this can create a problem.</Paragraph>
				<Paragraph class="Default">In that case you can ignore the referential integrity constraints by selecting this check box. If all tables from the dump are created, you must run the <GUIRef href="/baanerp/tt/aad/ttaad4225m000" role="session">Reorganize Tables (ttaad4225m000)</GUIRef> session.</Paragraph>
				<Paragraph class="Default">You can also overwrite data of existing tables, or create tables from the dump which have a reference with existing tables in the environment where the tables are created. In that case, this check box must be cleared, because the reference tables are there.</Paragraph>
			</SimpleSection>
		</FieldHelp>
	</Fields>
</Session>
