What I did for this was:

CREATE DATABASE Test
GO
SELECT * INTO Test..MagazineNETSchedule from MagazineNETSchedule
SELECT * INTO Test..Issue from Issue

GO
BACKUP DATABASE [Test] TO  DISK = N'd:\Test.bak' WITH NOFORMAT, INIT,  NAME = N'my special DB',
 SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO
DROP DATABASE Test
GO

CREATE DATABASE Test
GO
RESTORE DATABASE Test FROM  DISK = N'd:\Test.bak' WITH  FILE = 1,  MOVE N'Test' TO N'd:\Test',
  MOVE N'Test_log' TO N'<d:\Test.ldf>',  

NOUNLOAD,  REPLACE,  STATS = 10
GO
<move tables with DROP + SELECT INTO or DELETE + INSERT INTO>
GO
DROP DATABASE Test
GO

But, the restore didn't work as is. I had to do a manual restore. There was some kind of error which I don't remember. As for the move table, I didn't understand what to do exactly so I went from the insert from one database to another.