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 |
|
kamii47
Constraint Violating Yak Guru
353 Posts |
 Posted - 2010-10-25 : 09:30:31
|
| any compare tool which will cater table rename script.what i have done in my application new version is rename about 6 table.I am use to run the AdeptSQL Diff tool to get the upgrade script.Now I am stuck with table renaming.I have also called that table names in number of stored procedure.Is there any tool I can generate the upgrade script with table renaming?Kamran ShahidSr. Software Engineer(MCSD.Net,MCPD.net) |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-10-25 : 10:06:36
|
| When we rename a table we create a VIEW with the original table / column names for any "legacy" applications - or just whilst we sort everything out.Probably won't help for any APP that needs to Update the table, but for just Select it should make your life a little easier.Can't help with the comparison tool though - you will probably have to tell it specifically to compare OldTableName with NewTableName.FWIW we use unique names for all our tables AND columns THROUGHOUT the application. So if we need to rename anything then a Find & Replace will enable us to make sure we have fixed everything. We also always use the Column name as the Variable name (or a part of it) so that all such instances are found in the Global Find & Replace exercise. |
 |
|
|
kamii47
Constraint Violating Yak Guru
353 Posts |
Posted - 2010-10-25 : 10:34:15
|
| Agreed kristen.for every new application I use todevelop i also follwo the same rule but we have to face the consequences of maintaining an exisiting applicationKamran ShahidSr. Software Engineer(MCSD.Net,MCPD.net) |
|
|
|
|
|
|
any compare tool which will cater table rename scr