Register now or log in to join your professional community.
Database engin is mysql
it depend on database engine for example if you use sql server you can user wizard to transpose table from database to another by right click on database --> Task ---> Export data
this provide to you transpose structure of table and it data.
but if you use native sql language you can generate table script and transfer to target database and run this script after change database name.
tell more about type of database engine(SQL Server or orcle or mysql or access or etc) and I will explaine the way to you
