Exporting a store database from Central Administrator

This topic describes how to export a store database from Central Administrator.

You can export an existing store's database and use it as a template when creating a new centrally-managed store.

Create a store in Central Manager before starting this procedure.

1. Open Central Administrator.

2. Connect to the Central database.

3. Click Export Store Database.

1. Click Next.

1. Select the store. This is the new store that you created in Central Manager for which you want to create a new database.

1. Click Next.

2. Click Connect.

1. Enter the connection information for the template database. The template database is the database of an existing store that you wan to use as a template for the new store.

   1. Select the SQL Server where the template database is hosted.

   2. Select the Connection method for the SQL Server.

   3. From the Database drop-down, select the template database.

   4. Click Connect.

2. Click Next.

3. Click Create.

1. Connect to the SQL Server where you want to host the new store database.

   1. Select the SQL Server where you want to host the new store database.

   2. Select the Connection method for the SQL Server.

   3. Click Connect.

2. Click Next.

1. Enter the Database name for the new store database.

1. For Initial Size, enter the initial size of the database, e.g., 20MB.

1. (Optional) Select Automatically grow database size if you want the store database size to automatically increase in size as it grows.

   

   1. Select how you want to increase the database size: in megabytes or by percentage.

   2. Select how large the database can get. You can choose unrestricted growth or restricted growth . If you select restricted growth, enter the maximum database size in MB.

2. Click Next.

3. Click Finish.

The new store database is created on the SQL Server. You will see updates as the tables are created in the database. This new store database is empty.

1. Click Next.

The data from the template store database is exported to the new store database.

1. Click Next.

2. (Optional) Click Backup.

If you are moving an existing store database to a new SQL Server, you can select Delete store database after backup is successful to delete the original store database.

1. Click Next.

2. Click Finish.

1. (Optional) The message Do you want to export another store database? displays. Select Yes to repeat the procedure and export another store database or click No to exit.