Generate Script Wizard in SQL 2005/2008
-
Good Day All maybe i am missing something here. I have Database A and Database B. These two database have a Stored procedure called "sp_OOPS" and in all the databases the Stored Procedure is Difference. Without any any third party software , is there a way to use Generate Script Wizard to Sync Database B with Database A. basically when i use this wizard, it can do the if exists and all other nice sql futures, but if the sp definations are not the same it does not alter. Why i am trying to understand , is does the Wizard do that ? Thanks
Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
Good Day All maybe i am missing something here. I have Database A and Database B. These two database have a Stored procedure called "sp_OOPS" and in all the databases the Stored Procedure is Difference. Without any any third party software , is there a way to use Generate Script Wizard to Sync Database B with Database A. basically when i use this wizard, it can do the if exists and all other nice sql futures, but if the sp definations are not the same it does not alter. Why i am trying to understand , is does the Wizard do that ? Thanks
Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
A couple of things, do not prefix your procedures with sp_ SQL Server uses this prefix for system procedures and your procs are now being included in that set. If you must prefix I suggest usp I'm not going to be able to help with the wizard, I very rarely use them as they tend to be limited (have you ever tried writing a wizard). However you can get at the contents of the procedures using the system views. This is what 3rd party software does. Your expectations are a little unrealistic. The reason 3rd party software exists is because the built in tools are limited. I use SQL Compare to do this.
Never underestimate the power of human stupidity RAH
-
A couple of things, do not prefix your procedures with sp_ SQL Server uses this prefix for system procedures and your procs are now being included in that set. If you must prefix I suggest usp I'm not going to be able to help with the wizard, I very rarely use them as they tend to be limited (have you ever tried writing a wizard). However you can get at the contents of the procedures using the system views. This is what 3rd party software does. Your expectations are a little unrealistic. The reason 3rd party software exists is because the built in tools are limited. I use SQL Compare to do this.
Never underestimate the power of human stupidity RAH
Good Day Holmes Thank you for your kind reply. I don't prefix my procedures with sp, this was only an example. i know red-gate SQL Compare can do that.I was just trying to make sure if the SQL Wizard can generate a Alter when the objects have different code. Thank you once more
Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/