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 |
|
scottikon
Starting Member
9 Posts |
 Posted - 2006-06-27 : 05:30:08
|
| Please could someone tell me if it is possible to upgrade subcription and publication databases programmatically and if so any tips?Cheers |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-27 : 05:40:32
|
| What do you mean by upgrade?You can do virtually anything with replication via the provided system stored procedures.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
scottikon
Starting Member
9 Posts |
Posted - 2006-06-27 : 11:17:47
|
| I'm sorry, i wasnt very clear. I mean to update so to be able to change the structure of the database i.e. add columns, add new tables, rows etc but in code. We have a VB CRM application which will be moving to .NET platform soon, and we have a few customers who use subscription/publication databases. |
|
|
|
|
|
|
upgrade subscription/publication programmatically