.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Post New Web Links

any compare tool which will cater table rename script

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :Sql Server
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 Shahid Senior Software Engineer/Analyst (MCP,MCAD,MCSD.NET,MCTS,MCPD.net[web])

View Complete Post

More Related Resource Links

generate create script of table using c# and SQL server 7.0, can anyone help me?


I want to generate create table script using c#.net, I want to connect sql server 7.0 and generate table create script. Its urgent kindly help me urgently.

filter n compare between two table in resultset


Hi .. I have two table 

Say Table1 n Table2


Item              ItemName

001                 Laptop

001                  PC

002                  PC

002                  Printer

003                  Pendrive

004                  Keyboard

004                  CPU


Item                  ItemName

001                   laptop

001                   PC

002                   Printer

004                   CPU

Here am comparing table1 with table2

The Itemname which is available in both table1 n table2 should be dropout ... Other Item should be displayed ...

I need the sql result set like this :

Item                 &n

SMO classes to generate alter table script to add columns

How to generate ALTER TABLE script to add columns using SMO and c#.

Right click script alter table disabled

Does anyone know how to enable the "Script Table As" -> "Alter To" option in SQL Server 2008 SSMS? John M. Couch Insight Enterprises Inc. 6820 S. Harl Ave, Tempe, Az 85283 Email: john.couch@insight.com

script in a table



Since Marquee is not supported in xhtml, i had to write a javascript and i need that to be at the bottom of my page.

unsure How to achieve that?

Can i have my script insde a table just above </body> ?

Also how to align it to the center of the page...

Advance thanks,



Compare if every table entry exist at least once in other table



I have 2 tables:

- Salesmen with Pk.SalesmenID
- Appointments with Fk.SalesmenID and busy(bit)

I want to query:

(Every salesmen has at least one appointment)
(Select non busy salesmen)
(select * from salesmen)

Should I compare distinct counts of both tables?

Purpose is to get salesmens even if there's no appointment made yet. I hope it's somehow logic what I'm trying to explain here :-)

Find and compare values from a repating table?


Hi all

I am trying to loop through a repeating table, which is a secondary data source, and compare the Title column from the repeating table to another string which is not from the table. If they equal, I want all other rows to be hidden, except the equal one. I could do it easily in regular c#, but have not done it with InfoPath. I am not quite sure how to acheive that in InfoPath. If somebody could give me some sample code to put me in the right direction, I would be most thankful.


Adding a new field to a table via script in sql server management studio

I know how you can script to and create a new table but how about adding a new field to this table? For example: how would i add a new varchar(50) field named mynewfield?

USE [example]
/****** Object: Table [dbo].[Password]  Script Date: 10/26/2010 10:17:30 ******/
CREATE TABLE [dbo].[Password](
	[user_id] [int] NOT NULL,
	[password] [varchar](30) COLLATE SQL_Latin1_General_CP850_BIN2 NULL,
	[response1] [varchar](40) COLLATE SQL_Latin1_General_CP850_BIN2 NULL,
	[response2] [varchar](40) COLLATE SQL_Latin1_General_CP850_BIN2 NULL,
	[response3] [varchar](40) COLLATE SQL_Latin1_General_CP850_BIN2 NULL,
	[user_id] ASC

ALTER TABLE [dbo].[Password] WITH CHECK ADD CONSTRAINT [User_Password_FK1] FOREIGN KEY([user_id])
REFERENCES [dbo].[User] ([id])
ALTER TABLE [dbo].[Password] CHECK CONSTRAINT [User_Password_FK1]

Create Table Script



I have the following T-SQL script generated from an existing table:

	[ErrorId] [uniqueidentifier] NOT NULL,
	[Application] [nvarchar](60) NOT NULL,
	[Host] [nvarchar](50) NOT NULL,
	[Type] [nvarchar](100) NOT NULL,
	[Source] [nvarchar](60) NOT NULL,
	[Message] [nvarchar](500) NOT NULL,
	[User] [nvarchar](50) NOT NULL,
	[StatusCode] [int] NOT

create table script



I need a create table script (see bottom), where a field-description will be placed beside every field. In addition the field timestamp should contain the defaultvalue of the current time.

Thanks for your hint.




TABLE dbo.Example




SSMS Table designer does not script index filters



In SQL Server Mgt Studio (SSMS 10.50.1600.1, SQL 10.50.1600), under the table designer, when a table has a filtered index on it, if the modification does need to rebuild the table, the filter is missing on the index.

To reproduce the bug:

-          Create a table

Can not create table via SSMS 2005 GUI even with dbowner rights (I can via ddl script)


I have SQL server 2005 client with SP3 (Microsoft SQL Server Management Studio      9.00.4035.00).

Back end database is SQL server 2008 SP2

I can create/alter a table via sql script.
In the SSMS Database Designer (GUI), When I right click on the database >> Tables and select New Table I get the following error - "Unspecified Error. MS Visual Database Tools."

I was able to use SSMS 2008 client to create tables with out any issues. Looks like a compatibility issue between SSMS 2005 and SS 2008 server.  Has anyone seen this issue and if yes is there a fix for it ?




how to rename table name in sql?

how to rename table name in sql?

i trid as like

rename table table_name to new_table_name

but this raises an error

SMO Table script generation performance



currently I'm working on program for database compare. In this program I need to create scripts for databse objects. i found out that script generation is too slow but generating scripts using SSMS it's pretty fast. In one thread I have found, that SSMS uses for script generation SMO, but I couldn't find any suggestions for performance improvement.


Server srv = new Server(new ServerConnection("SERVER", "USERID", "PASSWORD"));
srv.SetDefaultInitFields(typeof(Table), true);
Database db = srv.Databases[database];
ScriptingOptions so = new ScriptingOptions();
so.AllowSystemObjects = false;
foreach(Table tb in db.Tables)
  StringCollection sc = tb.Script();


Interesting is that db.PrefetchObjects(typeof(Table),so) has almost no effect for script g

generate Table script using TSQL Sql Server

This code sample helps you to generate the Table script for the particular table. You can create the function and can generate the script by calling the function by passing the Table name as a parameter.

Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

Visual Case Tool - UML Tutorial

The Class Diagram

The class diagram is core to object-oriented design. It describes the types of objects in the system and the static relationships between them.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend