Jim Lawrence
accessd at shaw.ca
Tue Jan 31 00:54:32 CST 2006
Darren: I am not sure what you mean but you can transfer data by simply exporting it from one set of tables and importing it into another set of tables in the current db. ...or have you looked at the 'INTO' like: "SELECT * INTO MyRemoteTableName IN '\\server\databse\LocationOfMyRemoteMDB' from MyLocalTable;" Using this select in conjunction with an 'INSERT' sql can extract data from one MDB and place it into another. Syntax SELECT column_name(s) INTO newtable [IN externaldatabase] FROM source HTH Jim -----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 5: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 ----------------------------- _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com