How to clean tables in Ides database of Mobile Sales

[Former Member]

Hello experts,

I'm working with Mobile Sales v 4 SP08, and SQL Server 2000 Standard Edition.

I have created a new extract for a site.

In order to go faster loading the new extract synchronizing MSA client, how could I clean the Ides database into MSA client ?

Best regards

Juan

[Former Member]

Hi Juan,

If you want to clear only IDES database irrespective of CDB, then the only option is to clean the database, update the subscription filter and then download the data again.

e,g, you want to clear all sales related transaction on and before of 1st of Jan 2007, then you need to delete the data manually using the sql script from all the tables related to sales transaction, update your sales document subscription filter criterail to morethan 1st jan 2007 and then extract the subscription data.

Best Regards,

Pratik Patel

<b>Reward with Points!</b>

[Former Member]

Hi,

Refer to below mention links:

<a href="/people/santosh.v/blog/2007/03/20/cdb-data-archiving--part-1 Archiving Part 1</a>

<a href="/people/santosh.v/blog/2007/03/20/cdb-data-archiving--part-2 Archiving Part 2</a>

Best Regards,

Pratik Patel

<b>Reward with Points!</b>

[Former Member]

Hi Pratik,

Thank you, but I'm not interesting in complete archiving process.

I only want clean tables into Ides database into SQL Server of MSA client, with SQL tools. From SQL Interprise manager.

When I create a new extract for existing user and synchronize it, the import operation is very slow because SQL server needs delete the old records in all tables and import new records.

As far as I know, detaching Ides database, saving it, ... some operations...., and restoring it, we can clean all records in tables. After that we will synchronize and will load new extract.

Kind regards

Juan

[Former Member]

Juan

The IDES DB delivered when installing a demo szenario is not designed for connection with an IDES server (or another server at all). Therefore there are no scripts available for the deletion of the DB.

But: Part of the MSA installation DVD is a databases CD containing a SQL DB Backup for an EmptyIdes. This DB should be used whenever a database is filled from the server. So you need to get the backup from the CD, copy it to the to-be-connected client and put it in place of the IDES-DB. You can use the tool SwitchDB delivered with the MSA application and to be found under \sap\mobile\bin.

Once installed you can connect the client to the server and do the filling of the client.

Regards, Kai

[former_member192750]

Hi Juan,

You approach of detaching and backing up the ides and then creating a new one and downloading all the objects is the best option for fast initial loads. Alternately you can also use the approach Kai points out with the SwitchDB tool.

Best Regards,

Ankan