Cloning 1 table - data only

[scottangehr]

Does anyone know a way to only bring over records and attachments to a sub-prod instance for 1 table?

We have a sub-prod that has been configured but we don't  need all the tables, platform configuration, etc.

Thanks
Scott  

[Inactive_Us2231]

Hi Chuck,

What if the sub prod data has completely different sys ids than the one in prod? In this case, if we import the xml from prod to sub prod would the sys id be consistent?

Many thanks in advance!

~Sandesh

[scottangehr]

I keep getting this error when importing into the sub-prod

I'm only loading 1500 records

[Chuck Tomasi]

Have you tried exporting in smaller chunks? E.g. test with 100 first.

[scottangehr]

I was able to get 91 loaded.   I have 110,000 more to go

[Chuck Tomasi]

For that amount of data and the number of tables, you're better off with a clone.

When you started this thread you indicated you only needed to copy records in one table. It turns out that it's several tables (and copying the audit history isn't something you really want to get involved with.) Unless there's some compelling reason not to use a clone, I'd stick with that method as it's error proof, gets all the information you want, and only involves one operation.