InstallShield数据库

 

-- ------------------------------------------------------------------------------------------------
--                                                                             
--   File Name:   sqlscript.sql                                   
--                                                                             
--   Description: Blank SQL script                                          
--                                                                             
--   Comments:    This blank script is intended for advanced users. 
--                To create a script from an existing database with step-by-step  
--                  instructions, use the Database Import Wizard. 
--                                                                                                                
-- -------------------------------------------------------------------------------------------------
IF   EXISTS  ( SELECT   *   FROM  master.dbo.sysdatabases  WHERE  name  =   ' DBTest ' )
BEGIN
     EXEC  sp_detach_db  ' DBTest ' ,  ' true '
END

CREATE   DATABASE   [ DBTest ]   ON   PRIMARY  
    (FILENAME  =  
        ' C:/DBTest_Data.MDF ' )
     LOG   ON  (FILENAME  =  
        ' C:/DBTest_Log.LDF ' )
     FOR  ATTACH

GO            

 Text Replacement: c:/   --> [INSTALLDIR]

 

-- ------------------------------------------------------------------------------------------------
--                                                                             
--   File Name:   sqlscript.sql                                   
--                                                                             
--   Description: Blank SQL script                                          
--                                                                             
--   Comments:    This blank script is intended for advanced users. 
--                To create a script from an existing database with step-by-step  
--                  instructions, use the Database Import Wizard. 
--                                                                                                                
-- -------------------------------------------------------------------------------------------------

IF   EXISTS  ( SELECT   *   FROM  master.dbo.sysdatabases  WHERE  name  =   ' DBTest ' )
BEGIN
     -- 备份数据库
     DECLARE   @Path   NVARCHAR ( 50 )
     SET   @Path   =   ' C:/DBTest_ '   +   CONVERT ( NVARCHAR ( 50 ),  GETDATE (),  120 )
     
     BACKUP   DATABASE   [ DBTest ]   TO   DISK   =   @Path
                
     EXEC  sp_detach_db  ' DBTest ' ,  ' true '
END

Text Replacement: c:/   --> [INSTALLDIR]