July 2, 2008 at 2:53 pm
Hi & yep, I'm a newbie. How do I move selected tables & stored procedures from a development SQL2000 database to a Production server. HUGE thanks ... Chris
July 2, 2008 at 4:25 pm
One option is .... Look at Red Gates' SQL Packager.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 2, 2008 at 4:35 pm
What you're asking for is a bit broad. It sounds like you need to develop a change management process to propogate your schema and static data changes to your production environment. You should be able to find several posts here on SSC that discuss CM tactics.
Or, you could expand your question a bit and give us a specific example of what you want to do.
July 2, 2008 at 5:14 pm
Hi & thx for responding. Just needed 4 stored procedures & 3 tables (schema only) copied to a prod sql database. A friend just showed me the DTS route & it couldn't have been easier. Love this stuff 🙂
July 3, 2008 at 2:16 pm
HI,
If you setup the VSS or any Code control process the it would have been very easier to do it.
Thanks -- Vj
July 4, 2008 at 8:25 am
Before doing anything:: Backup the SP and Table Structures from Production as a roll back procedure.
right click on the procedure name then click modify.. change the connection to point to new server and database.
[this will create alter scripts for the procedures.]
hit execute.
for the tables it will be a little trickier.
you have to script out the changes and aplly them with alter table command ...
Having a change control process in place, always helps..
CORRECTION: The above procedure is for SQL 2005 using SSMS.
If you are using SSMS with SQL 2000, it will be a Easier Approach.
Else with Enterprise Manager, you have to copy the SP Code and Alter the Procedure.
Maninder
www.dbanation.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply