| Groups | Blog | Home |
sql server new users : Copy Table
If you are not familiar with DTS, and just want the table definition, right-click the table in Enterprise manager, select all tasks, generate sql script. Look through the options so you can also get the indexes and constraints as well as the table def itself. Once you have the script, Select the Dev server and open a Query Analyzer connection (Tools>>Query Analyzer). Open the .sql file created in the first step and execute it. Make sure you are connected to the correct servers when you do these steps. -- Kevin Hill 3NF Consulting www.3nf-inc.com http://kevin3nf.blogspot.com [quoted text, click to view] "Striker" <striker3070@qwest.net> wrote in message news:eN9kuLP%23GHA.5092@TK2MSFTNGP04.phx.gbl... > This may be a silly question, but I just got SQL 2000 Enterprise Mgr > loaded. I have registered two different servers. Can I copy one table > from one server to the other server? If so how do I do it? I don't care > if the data comes along or not. One of the servers is production, and the > other a development one. So I want to copy a table to development so I > can play with some code that runs against it. > > Thanks in Advance. >
This may be a silly question, but I just got SQL 2000 Enterprise Mgr loaded.
I have registered two different servers. Can I copy one table from one server to the other server? If so how do I do it? I don't care if the data comes along or not. One of the servers is production, and the other a development one. So I want to copy a table to development so I can play with some code that runs against it. Thanks in Advance.
You mentioned MOVE, I only want to copy the table. Sounds like the
"Generate SQL Script" will do that. [quoted text, click to view] "Kevin3NF" <kevin@SPAMTRAP.3nf-inc.com> wrote in message news:%23R2RQkP%23GHA.4388@TK2MSFTNGP02.phx.gbl... > You can use DTS to move the table and its data. > > If you are not familiar with DTS, and just want the table definition, > right-click the table in Enterprise manager, select all tasks, generate > sql script. Look through the options so you can also get the indexes and > constraints as well as the table def itself. > > Once you have the script, Select the Dev server and open a Query Analyzer > connection (Tools>>Query Analyzer). Open the .sql file created in the > first step and execute it. > > Make sure you are connected to the correct servers when you do these > steps. > > > > -- > Kevin Hill > 3NF Consulting > www.3nf-inc.com > http://kevin3nf.blogspot.com > > > "Striker" <striker3070@qwest.net> wrote in message > news:eN9kuLP%23GHA.5092@TK2MSFTNGP04.phx.gbl... >> This may be a silly question, but I just got SQL 2000 Enterprise Mgr >> loaded. I have registered two different servers. Can I copy one table >> from one server to the other server? If so how do I do it? I don't care >> if the data comes along or not. One of the servers is production, and >> the other a development one. So I want to copy a table to development so >> I can play with some code that runs against it. >> >> Thanks in Advance. >> > >
typo...DTS would not delete the table on the source
-- Kevin Hill 3NF Consulting http://www.3nf-inc.com/NewsGroups.htm http://kevin3nf.blogspot.com [quoted text, click to view] "Striker" <striker3070@qwest.net> wrote in message news:ubZFcoP%23GHA.2180@TK2MSFTNGP05.phx.gbl... > You mentioned MOVE, I only want to copy the table. Sounds like the > "Generate SQL Script" will do that. > "Kevin3NF" <kevin@SPAMTRAP.3nf-inc.com> wrote in message > news:%23R2RQkP%23GHA.4388@TK2MSFTNGP02.phx.gbl... >> You can use DTS to move the table and its data. >> >> If you are not familiar with DTS, and just want the table definition, >> right-click the table in Enterprise manager, select all tasks, generate >> sql script. Look through the options so you can also get the indexes and >> constraints as well as the table def itself. >> >> Once you have the script, Select the Dev server and open a Query Analyzer >> connection (Tools>>Query Analyzer). Open the .sql file created in the >> first step and execute it. >> >> Make sure you are connected to the correct servers when you do these >> steps. >> >> >> >> -- >> Kevin Hill >> 3NF Consulting >> www.3nf-inc.com >> http://kevin3nf.blogspot.com >> >> >> "Striker" <striker3070@qwest.net> wrote in message >> news:eN9kuLP%23GHA.5092@TK2MSFTNGP04.phx.gbl... >>> This may be a silly question, but I just got SQL 2000 Enterprise Mgr >>> loaded. I have registered two different servers. Can I copy one table >>> from one server to the other server? If so how do I do it? I don't >>> care if the data comes along or not. One of the servers is production, >>> and the other a development one. So I want to copy a table to >>> development so I can play with some code that runs against it. >>> >>> Thanks in Advance. >>> >> >> > >
In Enterprise manager, Select your Production Database, Click on the Wizards
icon (the magic wand). Select the Import/Export Wizard, then select [DTS Export]. Walk through the wizard, select the prod server as the source and the dev server as the destination. You will later be asked to select tables, there is a checkbox to include the data. At the end, you can save all of your selections so that you can do this again. -- Arnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous You can't help someone get up a hill without getting a little closer to the top yourself. - H. Norman Schwarzkopf [quoted text, click to view] "Striker" <striker3070@qwest.net> wrote in message news:eN9kuLP%23GHA.5092@TK2MSFTNGP04.phx.gbl... > This may be a silly question, but I just got SQL 2000 Enterprise Mgr > loaded. I have registered two different servers. Can I copy one table > from one server to the other server? If so how do I do it? I don't care > if the data comes along or not. One of the servers is production, and the > other a development one. So I want to copy a table to development so I > can play with some code that runs against it. > > Thanks in Advance. >
Don't see what you're looking for? Try a search.
|
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |