Export Database Object To Another. Now the tool provides the preview of database objects such as tables stored procedures views triggers functions indexes etc and click on Export to begin the transferring process. They are invoked with the exp and imp commands respectively.
Well use a sample AdventureWorks database in this case. You can select tables views stored procedures user defined functions etc. On the export window choose the Export to SQL Server Database option.
As a result you should get something like.
USE TestDB GO ALTER TABLE UserLog DROP CONSTRAINT PK__UserLog__7F8B815172CE9EAE WITH MOVE. This topic describes how to move a detached database to another location and re-attach it to the same or a different server instance in SQL Server. When you have two servers and plan to migrate a database from Server A to Server B at the same time youre kind of server experts or administrators then using the inbuilt database migration feature is a good way to start. For more information see Move User Databases.