Hi


i have one problem in database to creating SQL script

i want to copy table strucure with table data


Pls help

shailesh kavathiya

shailesh kavathiya
http://www.kavathiya.20m.com

__________________
Shailesh Kavathiya
===============
Good Morning SMS

Are you want to copy table structure and data across different databases or SQL Servers? If yes then use DTS,

Right click on your table in the Enterprise Manager-->All Tasks-->
Export Data

Then follow the DTS import/export wizard, select source datasource and destination data source, use copy tables and views (this will not copy any primary keys or indexes define on that table)..if you want to copy all the information select "Copy objects and data between SQL
Server databases". In the following wizrd uncheck copy all the objects and select only table you wanted to copy.

complete the wizard.


This will only work if you are transfering table between different databases or different sql server. if you want to copy the table into the same database

SELECT * INTO newtable
FROM existingtable

OR

You can generate sql script for the existing table, create a new table from that script and use the following SQL

INSERT INTO newtable
FROM existingtable

Hi

Thanks for reply

I want to upload my existing database to my web site server

in my server i dont have right to export database
only i have script file upload right

so only *.sql file upload in my MS Sql web server

help me how to create Script file with table data

thanks


shailesh kavathiya
http://www.kavathiya.20m.com

shaileshk,
I understand you wanting to upload a .sql file, but when you get it to the server, how are you going to execute it? I think I know what you want to do, but I need more information...
For your database on the website, what do you use to access it, Enterprise Manager or Query Analyzer?

MecurioJ.