SEO

#1 (**permalink**) 02-29-2008, 05:53 AM

When I export a table from my local SQL Server to my web-host's SQL
Server, the primary key never seems to export. This happens whether I
use the "Copy tables and views..." option or the "Copy objects and
data..." option. Anybody know why this happens?

#2 (**permalink**) 02-29-2008, 05:53 AM

On the next screen after specifying the destination server in DTS
import/export wizard, select the third option "Copy objects and data between
SQL Server databases", on the next screen, uncheck the "Use default options"
check box, click on the options button. A dialog box will provide the
required options to copy the keys, indexes, triggers etc.

--
Anith

#3 (**permalink**) 02-29-2008, 05:53 AM

Thanks Anith, I have tried that, but get the message "Failed to copy
objects from MS SQL to Server to MS SQL Server" and "MS ODBC SQL Server
Drive [SQL Server] The login 'login name for local server' does not
exist." The table structure is imported but without the primary key and
none of the data.

If I choose the first option in DTS "Copy tables and views..." - the
table structure and all data is imported successfully but WITHOUT the
primary key.

#4 (**permalink**) 02-29-2008, 05:53 AM

DaveR (dave@bluehills.co.uk) writes:
> Thanks Anith, I have tried that, but get the message "Failed to copy
> objects from MS SQL to Server to MS SQL Server" and "MS ODBC SQL Server
> Drive [SQL Server] The login 'login name for local server' does not
> exist." The table structure is imported but without the primary key and
> none of the data.

I don't know this screen at all, but it sounds to me that there are
options you fail to fill in correctly. The text "login name for local
server" sounds like something which is filled in as a guidance for you
to fill in.

I would execpt that there is also an option to use Windows authentication
for the other server, but again, I don't know this screen.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Table export removes primary key