InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 06:33:43 GMT20http://www.sqlservercentral.com/Forums/Topic1379194-391-1.aspx[center][b][size="4"]:exclamation:Indeed I don't need SSMSToolsPack [/size][/b][/center][center][b][size="6"];-)this was a tremendous help thank you so much and works JUST FINE :-)[/size][/b][/center][quote][b]Sean Lange (10/31/2012)[/b][hr]You don't need SSMSToolsPack to generate a script for the data. You can right click the database Taks -> Generate Scripts to bring up the Script wizard. On the Set Scripting Options section click the Advanced button. The last option in the first section of options (General) is "Types of data to script". By default this is set to Schema only. You can change that to Data only or Schema and data. If you choose the last one it will generate your create object script and inserts for all of the data.--EDIT--Of course SSMS Tools pack is a pretty darn handy extension though.[/quote]Mon, 05 Nov 2012 00:49:51 GMTAhmed_07http://www.sqlservercentral.com/Forums/Topic1379194-391-1.aspxYou don't need SSMSToolsPack to generate a script for the data. You can right click the database Taks -> Generate Scripts to bring up the Script wizard. On the Set Scripting Options section click the Advanced button. The last option in the first section of options (General) is "Types of data to script". By default this is set to Schema only. You can change that to Data only or Schema and data. If you choose the last one it will generate your create object script and inserts for all of the data.--EDIT--Of course SSMS Tools pack is a pretty darn handy extension though.Wed, 31 Oct 2012 07:55:16 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1379194-391-1.aspxI could have done this... but my B server is a remote server, that don't accespt IMPORT db...Create a linked server on 1 of the machines then use a cross server query to pull out the data, something like [code="sql"]select * into destinationdb.dbo.tablename from linkedservername.sourcedb.dbo.tablename[/code]thankx will try the other options tooWed, 31 Oct 2012 04:33:58 GMTAhmed_07http://www.sqlservercentral.com/Forums/Topic1379194-391-1.aspxAnother option is to use SSIS or the Import wizard to pull the data over from the other server. Wed, 31 Oct 2012 03:40:12 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1379194-391-1.aspxIF u don't wish to connect the two databases BCP in/out will be a good solution for you.Perform a BCP out operation on the source and get the data on a file.Then insert the data in the file onto a database using BCP in command.Wed, 31 Oct 2012 03:13:29 GMTmwaghhttp://www.sqlservercentral.com/Forums/Topic1379194-391-1.aspxA number of ways to do this.Create a linked server on 1 of the machines then use a cross server query to pull out the data, something like [code="sql"]select * into destinationdb.dbo.tablename from linkedservername.sourcedb.dbo.tablename[/code]Use the import export data wizard to copy the data from one place to anotherCreate a custom SSIS package which does what you needGet a copy of SSMSTools Pack, and use the generate data scripts functionality to script out the data.BCP Out and then BCP InWed, 31 Oct 2012 02:44:20 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1379194-391-1.aspxI wanted to copy a table and its data to another db in another pc.... I was wondering wether there is a way to generate a query that holds all the data of original table so I could just execute it to the other 2nd table and have exact data.thank youWed, 31 Oct 2012 02:30:12 GMTAhmed_07