Hello

I am intermediate level database programmer. Now in our organization web programmer complete one web site with sql server as a back end. Now we want to upload that database to our web server (web host). They have same version of sql server. I don’t want to use DTS (Export tool

Can you tell me a procedure by which script file will generate to create database as well as transfer data of each table also

Please help me for the same

In message <BC07CB67-65AE-4641-AF02-2CF0381F996B (AT) microsoft (DOT) com>, Sachin
Gedam <sachingedam (AT) rediffmail (DOT) com> writes

Some hosts may restore a backup file for you, but most won't.

If you do not want to use DTS, then you will need to script the
structures, which can be done through Enterprise Manager, or various
third party tools, or even through SQLDMO code.

Next you will need the data, so DTS would be idea, but if you want to
avoid it try bcp to a file, and then into to the new DB, or use a third
party tool to generate insert statements, but this will be very slow for
a lot of data.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org