[dba-SQLServer] Include data in Generate SQL Script

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




More information about the dba-SQLServer mailing list