Arthur Fuller
artful at rogers.com
Sun Feb 26 07:35:49 CST 2006
For this sort of thing, I use dbScripter. Google that or "DKS Advanced Solutions, Inc." This product will let you script out any database in a variety of ways, including selective tables. It will write both the DDL and the Insert statements. And you can target the receiving DB, so that certain data types will be converted to the types expected by the receiver. I have been using it for years, and it is rock-solid. Arthur -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Darren DICK Sent: January 30, 2006 8:08 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Include data in Generate SQL Script Hi all When I use "Generate SQL script" to create a 'blank' dB of tables etc, is there an option, a tool (even 3rd party tool) that will allow me to say... Select certain tables in the original dB and to to have the data in those tables included in the "Generate SQL script"? Make sense? Many thanks Darren