import table to a new database

cha dia

8y887SQL

I work on 3 databases that have some common tables, I created a new database that I want to import all these common tables, I use as tool HeidiSQL, it is possible to realize this mission with command sql, or I must do it manually

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

cha dia8y ago
it's tool that i use to export this table
cha dia8y ago
i come back with the same problem , i want to export some tables to a another database , but i have this error :
Jenith Thakkar8y ago
WelCome. If you Got Success then Accept My Answer
cha dia8y ago
thank you very much for your answer , i will try it
Jenith Thakkar8y ago
If I am not getting Wrong you want to Copy Schema from one Database To Another

There are several ways to do this, below are two options:

Option 1 - Right click on the database you want to copy

Choose 'Tasks' > 'Generate scripts'

'Select specific database objects'

Check 'Tables'

Mark 'Save to new query window'

Click 'Advanced'

Set 'Types of data to script' to 'Schema and data'

if you only want Schema then Select 'Schema Only'

Next, Next

You can now run the generated query on the new database.

Just Change The Above Database Name

Option 2

Right click on the database you want to copy

'Tasks' > 'Export Data'

Next, Next

Choose the database to copy the tables to

Mark 'Copy data from one or more tables or views'

Choose the tables you want to copy

Finish