starting from scratch - again

Sep 07, 2006 2 Replies

Hi. I've been using RMS for a few months now.



Now that I am comfortable using it, I am ready to stop playing around and officially go live with it.



However, my database is full of useless configurations, bogus transactions, messed up receit formats etc.



So I want to start again from scratch with a new database. I want to create a new database through the Administrator program and just import the stuff I need.



The only problem is that I want to retain my item,category,department,customer and supplier list, which is for the most part correct. i don't want to have to re-enter all those things manually. Everything else, (purchase orders, transactions, configuration data) can go.



How do I this? Are there any negative side effects that may happen?


Export query results from SO Admin then re-import the tables.

From SO Admin: SELECT * from TABLE

Tom

"Jack Smallbridge" wrote:

**********

Now that I am comfortable using it, I am ready to stop playing around and officially go live with it.

However, my database is full of useless configurations, bogus transactions, messed up receit formats etc.

So I want to start again from scratch with a new database. I want to create a new database through the Administrator program and just import the stuff I need.

The only problem is that I want to retain my item,category,department,customer and supplier list, which is for the most part correct. i don't want to have to re-enter all those things manually. Everything else, (purchase orders, transactions, configuration data) can go.

How do I this? Are there any negative side effects that may happen?

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required