How to copy table with design and data from database to another database ?

Question

I have Usere table its contain a lot of data I need same table with data in another
database how can I do that ?

I try to use this way but i get sql query contain just design of table not data in the table 

Answer 1

Export Data in SQL Server 2019

In SQL Server, you can use Export Data wizard to copy a table from database to another database, and to do that you should do the following:

Steps

• Right-click on your database > Select Tasks - click on Export Data
  

• The Export and Import wizard Should be opened- Click Next.
  

• Choose Data source and database and click Next.
  

• choose the destination, Server name, and Database and click Next.
  

• Choose Copy data from one or more tables or views and click Next.
  

• Select the table that you want to copy.
  

• At Save and Run Package choose Run Immediately and click Next.
  

• Wait until the execution was successful and click close.
  

• Go to the destination database and refresh it, you should find a new table is exist.

You also use Generate Scripts if you want to copy a table with schema and data to another database that hosted in a different environment.

---

See Also

• Database was backed up on a server running version 13
• The transaction log for database SharePoint_Config is full due to LOG_BACKUP