Jim Lawrence
accessd at shaw.ca
Tue Jan 31 08:15:22 CST 2006
Hi Darren: I have used in Access and it is a standard method but I have never tried in MS SQL as there are so many other ways of building your own import and export scripts. Looks like a good site. Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Darren DICK Sent: January 31, 2006 4:19 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Include data in Generate SQL Script Hi Jim et al I like your Select * INTO business Does it work with SQL? Anyway... I found a brilliant - and free SPROC to do it for us We wanted to create several new 'blank' SQL dbs using scripts from Original dB with about 450 tables The majority of the tables we only wanted the table structure so the standard EntManager script feature was fine BUT We wanted to populate our destination new 'blank' dB with data from a few tables from our Original as we went Not all - just a few - Because they are needed tables in each and every new 'blank' db but they have thousands of rows of data in 'em Didn't want to write Insert Field, field WITH value, value for each ROW of the needed tables This SPROC saved the day and is brilliantly easy to use No affiliation at all - here's the link - heaps of other stuff there as well http://vyaskn.tripod.com/code.htm#inserts Darren ------------------------------ T: 0424 696 433 -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Tuesday, 31 January 2006 5:55 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Include data in Generate SQL Script 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com