Share via

Create Database (SQL Server Import and Export Wizard)

  • Article

Use the Create Database page to define a new database for a destination file.

This page offers a subset of the available options for creating a new database. To view all the options, use Microsoft SQL Server Management Studio.

To learn more about this wizard, see Creating Packages Using the SQL Server Import and Export Wizard. To learn about the options for starting the wizard, and about the permissions required to run the wizard successfully, see How to: Start the SQL Server Import and Export Wizard.

The purpose of the SQL Server Import and Export Wizard is to copy data from a source to a destination. The wizard can also create a destination database and destination tables for you. However, if you have to copy multiple databases or tables, or other kinds of database objects, you should use the Copy Database Wizard instead. For more information, see Using the Copy Database Wizard.

Options

  • Name
    Provide a unique name for the destination SQL Server database. Make sure that you follow SQL Server conventions when you name this database.
  • Data file name
    View the name of the data file. This is derived from the database name you provided earlier.
  • Log file name
    View the name of the log file. This is derived from the database name you provided earlier.
  • Initial size (data file)
    Specify the number of megabytes for the initial size of the data file.
  • No growth allowed (data file)
    Indicate whether the data file can grow beyond the specified initial size.
  • Grow by percentage (data file)
    Specify a percentage by which the data file can grow.
  • Grow by size (data file)
    Specify a number of megabytes by which the data file can grow.
  • Initial size (log file)
    Specify the number of megabytes for the initial size of the log file.
  • No growth allowed (log file)
    Indicate whether the log file can grow beyond the specified initial size.
  • Grow by percentage (log file)
    Specify a percentage by which the log file can grow.
  • Grow by size (log file)
    Specify a number of megabytes by which the log file can grow.