I am using SQL Server 2000 Data Transfer Service (DTS) wizard for import database from another existing SQL Server 2000 database. I also choose "Copy objects and data between SQL Server databases" option when import.
After import finished, I saw that size of new imported database are smaller than original database. Is this normal? I worried if that any object are not imported to new database, such as stored procedure or view.
How can I make sure if the new database's object are same with old database?