Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mike2008
Starting Member
11 Posts |
 Posted - 2008-10-18 : 05:58:10
|
| What I mean. Let's say I create a database, add a user to it, add a table and some content. Is there now a way to "extract" the T-SQL code for it in order to do the exact same on another server using T-SQL instead ? Same with configs such as Mirroring etc. ? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-18 : 07:31:11
|
| Though not in same order you could get T-sql code for each by scripting from SSMS. you can script all of above from management studioAnd if you really to get all of the above in order then you need to run profiler on background and then save the trace info somewhere. then later use the code from trace to do exact operations in some other server. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-19 : 12:48:42
|
| Can you explain exactly what is your requirement? Does that database exists in other server and you want to synchronize it whenever you make changes to source server? Am I right? |
|
|
|
|
|
|
Can each step taken in SSMS be shown in T-SQL ?