How to move custom table from one instance to another

[dhruva]

I have a requirement where i have a custom table having overall 80 columns and 4 custom modules created under it. i need to move this to another instance of snow. what is the best approach ?kindly help t_anurag

[Ashutosh Munot1]

Try exporting in into excel first......then open that excel and see structure is there or not...

but if some fields are refering other that you need to do it manually in other instance where you import it

[Anurag Tripathi]

Hi Dhruva,

I think the posts above by Ashutosh and Mihir answer your question. Is any part left unanswered?

[dhruva]

Hi ANurag

I tried exportin xml and imported in destinatiion instance, it is not capturing all fields and columns , any other appraoch ?

[Anurag Tripathi]

What columns are getting exported?

[Anurag Tripathi]

you can run a background script that will loop over the data you want to capture and inside the while write this

var um = new Packages.com.glide.update.UpdateManager2();

    um.saveRecord(gr);     //gr is the GlodeRecord object of each record you want to capture