Click here to Skip to main content
11,721,385 members (83,843 online)
Rate this: bad
Please Sign up or sign in to vote.
hi guys ,
i am using installshield 2012 and i want to deploy my database from backup file
but take care of the following
1- Creating database with name (xxx) .
2- creating User (Sa , with pass = YYY).
3- restore my back up file to the created database .

any one can help ?

Posted 3-Jul-12 10:39am
Wes Aday at 3-Jul-12 16:56pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

InstallShield already has SQL Server Script support[^]

Don't simply attach your database, you should use sql scripts to create all of its components
yayaNasr at 4-Jul-12 17:04pm
how can i create these required script from sQL server 2008 to achieve these steps and what is the scripts required and its order ? , thanks
barneyman at 4-Jul-12 18:36pm
in SQL Management Studio, right click on the database, chose Tasks, Create scripts; this will create the scripts in the right order

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 440
1 OriginalGriff 229
2 Mika Wendelius 170
3 F-ES Sitecore 80
4 cyycoish 70
0 Sergey Alexandrovich Kryukov 2,209
1 OriginalGriff 969
2 F-ES Sitecore 660
3 Maciej Los 609
4 Richard MacCutchan 560

Advertise | Privacy | Mobile
Web04 | 2.8.150901.1 | Last Updated 3 Jul 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100