Skip to main content
Solved

FSM6 Database import and Post Copy data Cleanup

  • September 30, 2024
  • 3 replies
  • 33 views

Dilshan Aththanayake
Sidekick (Employee)
Forum|alt.badge.img+5

Hello Experts;

 

1→  Regarding FSM6[24] existing database , we need to import another database to the existing one [MSSQL]

  • Could you please provide if we have any documents/guides to perform the database Import.

2→  What are the scripts that we must use to cleanup any post copy data after the import ?

 

BR!

/Dilshan

Best answer by roklde

Hi Dilshan,

while there is no official guideline in the documentation, you can follow attached steps performing environment clones. These steps are a slight deviation from the steps executed by our managed cloud teams. Let me know if anything is unclear.

Best regards
Roman

 

View original
Did this topic help you find an answer to your question?

3 replies

roklde
Superhero (Employee)
Forum|alt.badge.img+26
  • Superhero (Employee)
  • 748 replies
  • Answer
  • September 30, 2024

Hi Dilshan,

while there is no official guideline in the documentation, you can follow attached steps performing environment clones. These steps are a slight deviation from the steps executed by our managed cloud teams. Let me know if anything is unclear.

Best regards
Roman

 


Dilshan Aththanayake
Sidekick (Employee)
Forum|alt.badge.img+5

Hello @roklde ;

 

  • Thank you very much for the details.

Additionally ,  are there any script we must use to cleanup any post copy data after the import?

 

BR!

/Dilshan


roklde
Superhero (Employee)
Forum|alt.badge.img+26
  • Superhero (Employee)
  • 748 replies
  • September 30, 2024

Hi Dilshan,

as mentioned in the instructions, you can use SQL Import/Export Wizard to cleans the mentioned tables. In addition, you can use the truncate script provided with the Installation Files ("\mxserv\DatabaseData\<DatabaseType>\FSM6_Truncation.zip") to truncate operational data.

Best regards
Roman


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings