top of page
Sesame Software

NetSuite Backup How To Guide: 3 Options Compared

Writer: Sesame Software
Sesame Software
7 hours ago
5 min read

Hot tip: It Isn't Built In


Quick answer: NetSuite doesn't include a full NetSuite backup you control. You have three options: Full CSV Export and saved searches (free, but incomplete), a do-it-yourself build on SuiteAnalytics Connect (complete, but a long project), or Sesame Software, which copies your whole NetSuite account into a database you own on a schedule you set.


Here's something a lot of NetSuite admins learn the hard way: there's no "back up everything" button. NetSuite keeps the system running, but a complete NetSuite backup that you control is up to you.


People asking about it in admin forums usually hear the same two things. It's "not something NetSuite offers out of the box." And building it yourself across circa 1,700 tables is "a long and difficult task."


So what are your real NetSuite backup options? There are three.


Infographic comparing three NetSuite backup options: CSV export, DIY SuiteAnalytics Connect, and Sesame Software, with labels.

NetSuite backup option 1: CSV export and saved searches


NetSuite has a Full CSV Export, and you can export any saved search. It's free and it's already there.


The catch is coverage. Oracle's own documentation says "the Full CSV Export option in NetSuite does not currently export all data as CSV files." It covers lists like customers, vendors and items, but not individual transactions, custom records or File Cabinet files (ClonePartner export guide).


Saved search exports have limits too. Search exports cap at 10 MB, roughly 20,000 rows of typical transaction data. That means splitting large tables by date range and stitching the files back together yourself.


Good for: a one-off snapshot of a few lists. Not good for: a real NetSuite backup. You'll get flat files with no relationships between them, and nothing that runs on a schedule.


NetSuite backup option 2: Build your own with SuiteAnalytics Connect


SuiteAnalytics Connect gives you read-only ODBC or JDBC access to NetSuite. Point a script or ETL tool at it and you can pull tables into your own database.


It's a paid add-on, priced per connection in your Oracle contract, and not available on Small Business accounts. Then the real work starts:

  • Mapping the schema. Hundreds of record types, custom fields and sublists, each one a table you need to define and keep up to date.

  • Rebuilding relationships. Parent-child links between transactions and their lines, or customers and their orders, have to be put back together by hand.

  • Handling deletes. Deleted records only show up through a separate search type, so a simple pull misses them.

  • Getting the files. Connect gives you File Cabinet metadata, not the files themselves. Downloading them means one API call per file.

  • Keeping it running. Throughput limits, shared concurrency with your other integrations, and schema changes every NetSuite release.


Good for: teams with spare data engineering time and a narrow scope. Not good for: anyone who needs every table, every file and every relationship, kept current, without a long project.


NetSuite backup option 3: Sesame Software


Sesame Software was built to solve exactly this. It copies your entire NetSuite account into a database you own, on a schedule you set. It connects through the same SuiteAnalytics Connect access as a DIY build, then handles the mapping, relationships, deletes, files and upkeep for you.


Infographic titled NetSuite Backup Checklist with six green checkmarked items on transactions, records, files, and counts; Sesame Software logo

  • Every object, record and custom field, with parent-child relationships preserved automatically

  • Child tables created for you. Sublists are split into normalized, queryable tables. No SQL required.

  • File Cabinet included. Files arrive in a zip that mirrors your NetSuite folder structure, in their original formats.

  • Deletion tracking, so removed records stay traceable

  • Record-count reconciliation and audit. Counts are checked object by object against NetSuite. Any gaps are found record by record and logged so you can fix them.

  • Your destination, your control. SQL Server, Oracle, PostgreSQL, Snowflake and more. Sesame Software never stores your data on our servers.

S

etup typically takes under an hour. A full first pull of a large account can take 1–2 weeks because of NetSuite's API limits, so if you're backing up ahead of a shutdown, start 60–90 days before it. A one-time NetSuite export starts at $5,000.


NetSuite backup options side by side



CSV export

DIY with SuiteAnalytics Connect

Sesame Software

Transactions

Saved searches only, in chunks

Yes, if you build it

Yes

Custom records and fields

Not in Full CSV Export

Yes, if you map them

Yes, automatically

Record relationships

Lost (flat files)

Rebuilt by hand

Preserved

Deleted records

No

Separate search, extra work

Tracked

File Cabinet files

No

One API call per file

Zip that mirrors your folders

Runs on a schedule

No

If you build and maintain it

Yes

Proof it's complete

No

If you build it

Record-count reconciliation

Extra NetSuite cost

None

Connect add-on license

SuiteAnalytics Connect (same license, none of the build work)

Your time

Hours every time

Weeks to months, then upkeep

Under an hour to set up


Which NetSuite backup option fits


If you need a quick list of customers for a one-time project, CSV export is fine. If you have a data team with time to spare, a Connect build can work for a narrow set of tables.

If you need a real NetSuite backup, one that captures everything, keeps relationships intact and holds up in an audit, that's what Sesame Software is for.

NetSuite Backup FAQs

Does NetSuite back up my data?

Oracle runs and protects the NetSuite platform, but there's no built-in tool that gives you a complete NetSuite backup you control. Full CSV Export leaves out transactions, custom records and File Cabinet files.

Lists like customers, vendors and items. It doesn't include individual transactions, custom records or File Cabinet files, so it isn't a complete backup.

For a complete copy, yes. Both a DIY build and Sesame Software use SuiteAnalytics Connect access. The difference is who does the mapping, relationships, deletes, files and upkeep.

Sesame Software setup typically takes under an hour. The first full pull of a large account can take 1–2 weeks because of NetSuite's API limits. After that, backups run on the schedule you set.

With Sesame Software, in a database you own, such as SQL Server, Oracle, PostgreSQL or Snowflake. Your data never sits on our servers.


Related Resources

Sources


Found this post helpful? Share it with your network using the links below.

bottom of page