November 7, 2003 at 5:16 am
This probably should be in the Administration forum, but since I'm the Developer and we get to do our own administration I'm posting here.
I upgraded an old ASP app that performed all SQL functions using ADO Recordsets and functions (i.e. AddNew, Update), to use SP's for complex operations, Views for complex retrieval, etc. So now I have a DB on my dev SQL server that has a whole pile of new Views, SP's and UDFs. The underlying tables haven't changed.
Is there a way to copy the Views, SP's and UDF's from the dev server DB to the production server DB? EM's Export data only exports tables....
November 7, 2003 at 6:04 am
In the Export option there is after the destionation screen you can choose to copy objects, then on the next screen there are several options you can change to get only the items you are discussing. However for safety I would just script them out and run on the production server.
November 7, 2003 at 6:10 am
Duh!!
Hadn't even thought about scripting them out, and EM has such a nice feature for that.
Thanks.
November 10, 2003 at 7:12 pm
This is a great opensource tool to compare databases.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply