compare two SQL database
-
I have one main database (for my user). now when i change the database(SP,View,Tables,....) from my side I wanna make possible the i create some scripts and when i run the scipt all the changes make for the user database without changing the data of user. //if needed to delete SP,Create View , Delete Table,Create Column ,.... every thing that changed. thanks!
-
I have one main database (for my user). now when i change the database(SP,View,Tables,....) from my side I wanna make possible the i create some scripts and when i run the scipt all the changes make for the user database without changing the data of user. //if needed to delete SP,Create View , Delete Table,Create Column ,.... every thing that changed. thanks!
Thsi may help: Database Publishing Wizard in VS 2010 Professional[^]. It's usually best to generate 2 scripts: one for the objects and one for the data, especially if you have large amounts of data (in which case you probably should look at other methods of doing this).
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me
-
I have one main database (for my user). now when i change the database(SP,View,Tables,....) from my side I wanna make possible the i create some scripts and when i run the scipt all the changes make for the user database without changing the data of user. //if needed to delete SP,Create View , Delete Table,Create Column ,.... every thing that changed. thanks!
We use Red-Gate SQL Compare but it is paid fr and not particularly cheap.
Never underestimate the power of human stupidity RAH
-
I have one main database (for my user). now when i change the database(SP,View,Tables,....) from my side I wanna make possible the i create some scripts and when i run the scipt all the changes make for the user database without changing the data of user. //if needed to delete SP,Create View , Delete Table,Create Column ,.... every thing that changed. thanks!
hi thanks for reply. But i wanna do that my self without and additional software. just in C# and SQL.