Mgration of Database Script - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Mgration of Database Script

Author

Topic

pradeep_iete
Yak Posting Veteran

84 Posts

Posted - 2008-09-26 : 01:58:08

Hi All,

I generated script of my database and execute the same on second server.On that server i had the same database but with different name.
After execution maximun object were created except few one .All unsuccessfull object were views reflecting following message:

Msg 208, Level 16, State 1, Procedure VwUseVisaAppProcess, Line 4
Invalid object name 'VisaApplicationProcess'.

Please guide along with specifying the reason why it happend

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-26 : 02:05:58

It seems like you didnt create a table named VisaApplicationProcess in your new db. Can you look into view body to see if it had such a table included in it?

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-09-26 : 02:31:49

Also this forum is to post workable script. Post your question at t-sql forum

Madhivanan

Failing to plan is Planning to fail

pradeep_iete
Yak Posting Veteran

84 Posts

Posted - 2008-09-26 : 02:44:37

Hi Visakh,
Well i just generated and executed the script..I have got ur point and infact it worked well leading to generation of all the pending view but surprizingly why it happend it firstplace .Why all the object dependencies should'nt get executed in last to combat such error.

I hope u got my concern.Correct me if i am wrong

pradeep_iete
Yak Posting Veteran

84 Posts

Posted - 2008-09-26 : 02:45:49

sure Madahivan,
I will be make sure next time

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-26 : 02:57:39

quote:
Originally posted by pradeep_iete

Hi Visakh,
Well i just generated and executed the script..I have got ur point and infact it worked well leading to generation of all the pending view but surprizingly why it happend it firstplace .Why all the object dependencies should'nt get executed in last to combat such error.

I hope u got my concern.Correct me if i am wrong

not sure why it happened. how did you generate script for db initially?

pradeep_iete
Yak Posting Veteran

84 Posts

Posted - 2008-09-26 : 03:24:11

Through generate Script template Procedure in SQL server 2005

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-26 : 03:26:32

quote:
Originally posted by pradeep_iete

Through generate Script template Procedure in SQL server 2005

then it shouldnt have been missed.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-09-26 : 04:36:56

moced from script library.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources