Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    5

    Question Unanswered: Copying Views and Stored Procedures

    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 advance

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Copying Views and Stored Procedures

    DTS or Script it. Your pick.

  3. #3
    Join Date
    Dec 2003
    Posts
    5
    Thank You.

    I was playing around with it and I used a script. Thanks for your reply.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    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?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    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 ....
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •