Creating new Database - Forcing Order of Scripts

[DonS100]

Hello, I have a products database that I need to recreate somewhere else but with no data in the tables. Is the best way to do this, simply using the 'Generate SQL Script' option though Enterprise Manager against the existing database. Are there any objects that will not get created?

One thing I have come across with scripting so far is that I have views based on views. So I'm having to manually change the order of views in my script to have the ones not based on views at the top. Is there a easier way to do this?

Thanks

Don

 

[SQLDenis]

Easiest is backup DB restore on the server you want it then run this

EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
GO

EXEC sp_MSForEachTable '
 IF OBJECTPROPERTY(object_id(''?''), ''TableHasForeignRef'') = 1
  DELETE FROM ?
 else 
  TRUNCATE TABLE ?
'
GO


EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
GO

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/