Hello All,
I have two SQL databases which have the exact same tables - just different data. In database A there are only tables. In database B there are tables, stored procedures and views. I need to transfer the stored procedures and views from database B into database A. Is there a way to do this?
Thanks in advanceDTS or Script it. Your pick.|||Thank You.
I was playing around with it and I used a script. Thanks for your reply.|||What about contraints?
Just make sure you do them in the correct order...ie if a sproc references a view...
I guess if you did you'd just get a warning message...and once it was reference it would be resolved...
Anyone experience this?|||Originally posted by Brett Kaiser
What about contraints?
Just make sure you do them in the correct order...ie if a sproc references a view...
I guess if you did you'd just get a warning message...and once it was reference it would be resolved...
Anyone experience this?
I believe no entries would be inserted into sysdepends for the sproc corresponding to the view... which would lead to the view not showing up when you do a sp_depends on the sproc ...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment