473,322 Members | 1,736 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Table export removes primary key

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?

Jul 23 '05 #1
3 7826
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
Jul 23 '05 #2
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.

Jul 23 '05 #3
DaveR (da**@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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Bob C. | last post by:
I want to create a 1-many relationship. Parent table has a primary key, child table has no primary key. The child table does have an index with all four fields of the parent's PK. How can I do...
11
by: suma | last post by:
Hello, I want to delete duplicate rows in a table when no primary key is defined. For eg: If we have table1 with data as below, Suma 23 100 Suma 23 100 I want to delete a row from this...
4
by: serge | last post by:
I ran into a table that is used a lot. Well less than 100,000 records. Maybe not a lot of records but i believe this table is used often. The table has 26 fields, 9 indexes but no Primary Key at...
2
by: jay | last post by:
hi, Question on Load/import command. consider a sample table create table table_name ( col1 timestamp not null default current timestamp, col2 int, col3 int, col4 int, primary key(col1) );...
1
by: tomg | last post by:
I am able to export an MS-Access table to Oracle if that table does not exist there. I would like to append data to the Oracle table, but I get the Oracle message "Error--00955 Name is already...
2
by: Nick03 | last post by:
I am trying to update data in a datagrid that was generated by a view. I keep getting the error: "table has no primary key". Here is the code that I am using: Dim NewQuantity, NewAmount,...
3
by: Pauke | last post by:
I want to add a primary key to a table with some duplicates and I have to get rid of them first, keeping the first row from each duplication case. Say I found a case of duplication where there are...
3
by: =?Utf-8?B?S2F5xLFoYW4=?= | last post by:
In my project,i added datagridview to my form , i transfered my table to datagridview and added multiple rows and when i called dataadapther.update ,,result is ok. But when i tried it for the...
2
by: Marisol2 | last post by:
I have some queries in Access 2003 db that I have setup to display as pivots. I can go into design pivot table view and click on and then click on Export to Office MicroSoft Excel. The problem is I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.