Copy tables to another SQL Server keeping the identity property
It might be easiest for a one-off exercise to use the Generate Scripts SSMS feature to script out the tables. Right-click the database, choose Tasks, then Generate Scripts.
Be sure to check the advanced options so you script exactly what you need. That will create the tables (and, optionally, things like indexes) including the IDENTITY property.
You can then load the tables using any convenient method, including the Import and Export Data Wizard you already have experience with. You will need to select the &quot;enable identity insert&quot; option because the destination tables will have that property now.
Yes, it would be nice if the import and export wizard handled identity, but it is a general tool designed for multiple types of data source, and identity is proprietary.