[dba-SQLServer] Include data in Generate SQL Script

Darren DICK darrend at nimble.com.au
Tue Jan 31 08:18:41 CST 2006


Thanks Jim
 


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: Wednesday, 1 February 2006 1:15 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Include data in Generate SQL Script

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

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list