Re: [development-axapta] Copy Item to another company/dataarea

2010-04-29 Thread Leo Vee
Hi Axl,


    For the performance objective, i think you should do it in the level 
back-end SQL database by using DTS or Integration services.

Simply attach another backup DB from Production server and use DTS/Integration 
function to copy the same data. But before you do that, you should modify first 
the recId and dataAreaId in the backup DB.  

But it is still easier to write your own job to copy item into another company 
by using changeCompany function in DAX.


Regards,






From: Ruel Ormita r...@msb.com.my
To: development-axapta@yahoogroups.com
Sent: Thu, 22 April, 2010 3:26:26 PM
Subject: RE: [development-axapta] Copy Item to another company/dataarea

  
Hi,

There are two methods.

1. Export it using Administration  Periodic  Export 

Need to setup the definition group. Then select the corresponding tables
you want to export.

2. Create a job using the changecompany( ) function.

Regards

From: development- axa...@yahoogrou ps.com
[mailto:development- axa...@yahoogrou ps.com] On Behalf Of axaeffect
Sent: Wednesday, April 21, 2010 12:36 PM
To: development- axa...@yahoogrou ps.com
Subject: [development- axapta] Copy Item to another company/dataarea

Hi all,

How to copy item (InventTable, InventTableModule, InventeItemLocation )
to another company/dataarea?

Kindly advise,
Thanks,
Axl

[Non-text portions of this message have been removed]





  

[Non-text portions of this message have been removed]



[development-axapta] Copy Item to another company/dataarea

2010-04-22 Thread axaeffect
Hi all,

How to copy item (InventTable, InventTableModule, InventeItemLocation)
to another company/dataarea?

Kindly advise,
Thanks,
Axl



RE: [development-axapta] Copy Item to another company/dataarea

2010-04-22 Thread Ruel Ormita
Hi,

 

There are two methods.

 

1. Export it using Administration  Periodic  Export 

Need to setup the definition group. Then select the corresponding tables
you want to export.

 

2. Create a job using the changecompany() function.

 

 

Regards

 

 

From: development-axapta@yahoogroups.com
[mailto:development-axa...@yahoogroups.com] On Behalf Of axaeffect
Sent: Wednesday, April 21, 2010 12:36 PM
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Copy Item to another company/dataarea

 

  

Hi all,

How to copy item (InventTable, InventTableModule, InventeItemLocation)
to another company/dataarea?

Kindly advise,
Thanks,
Axl





[Non-text portions of this message have been removed]