Welcome to SQLServer MVP Blog

Venkatesan Prabu MCITP,MCAD,MCTS,CCNA. Worked as a ProjectLead(Senior .Net developer,SQL DBA). Now, Managing Director of KAASHIV INFO TECH, Chennai This Blog aims in serving the community in a better way. This blog is read by developers in 159 countries with average of 400 hits per day. Please post your valuable suggestions and hold my hand to serve the community. Lets make a new world with good thoughts and good minds....... This blog serves the SQL server community all over the world.

31.1.16

Clone DB tables and its data - Part2

Right click the DB and generate scripts for the DB and execute the script with a new query window that points to a different DB name. This is the better option to work with especially when the Source and Destination SQL Server versions are different.