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
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:
Export Data wizard
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.
1k questions
670 answers
451 comments
193k users
Related Activities
Categories
Most popular tags