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 |
|
cutiebo2t
Constraint Violating Yak Guru
256 Posts |
 Posted - 2008-05-10 : 06:29:01
|
| Hi,Is there a way to copy and save my Design Table? I want to transfer it to another workstation. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-10 : 07:33:04
|
| Design Table? Created where? |
 |
|
|
cutiebo2t
Constraint Violating Yak Guru
256 Posts |
Posted - 2008-05-10 : 07:39:40
|
| Created from my SQL. I want to copy and transfer the Design table to another SQL. |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-05-10 : 08:52:14
|
| If you are talking about MS Sql Server, then you can use enterprise manager (or management studio) to "scripte table as create" then apply that script to the other server instance.Be One with the OptimizerTG |
|
|
|
cutiebo2t
Constraint Violating Yak Guru
256 Posts |
Posted - 2008-05-10 : 09:48:25
|
| Yes I'm using MS SQL Server. I'm not sure how? |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-05-10 : 12:04:21
|
| from Object Explorer (of either query analyzer or management studio) right click the table you want to copy and explore the optionsBe One with the OptimizerTG |
|
|
|
cutiebo2t
Constraint Violating Yak Guru
256 Posts |
Posted - 2008-05-10 : 20:48:01
|
| i'm not sure if that would work. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-11 : 00:28:43
|
| Of course it works. Did you try it?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-11 : 00:59:52
|
quote:
Originally posted by cutiebo2t
i'm not sure if that would work.
Try it first yourself and then jump to conclusion. |
|
|
|
|
|
|
Design Table