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.
| Author |
Topic |
|
afeets
Starting Member
10 Posts |
 Posted - 2007-11-23 : 07:09:02
|
| This is my first real project in SQL, so I could do with some advice in the best way forward for future reference.I have created two SQL database's one live, one development. All the design work has been done on the Development Db, I now want to create the tbl's, views etc in the Live Db. However when I generate the SQL Script, the syntax is ok, but the order of creation is wrong. I.e it tries to create a view based on a table that the script hasn't run yet. Obviously I can go through the whole script and cut and paste it into the correct order, but I am sure it is not meant to be this awkward.Can you help?? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-23 : 08:02:26
|
| Just script each type of object seperately, so put tables in one script, views in another, sps in a third.. |
 |
|
|
afeets
Starting Member
10 Posts |
Posted - 2007-11-23 : 08:18:57
|
| Not as simple as that, what happens when you have views based on other views, Sp's running off other SP's etc. |
|
|
|
|
|
|
Use Sql script from develoment Db for Live Db