export to sql 2005

From: "HandersonVA" <handersonva@xxxxxxxxxxx>
Date: 13 Sep 2006 07:36:43 -0700

when i export data on sql 2000 to sql 2005, i lost all the primary key
setting and relationship.
how can preserve what database structure on the sql 2000 when i move to
sql 2005?

.

Follow-Ups:
- Re: export to sql 2005
  - From: Erland Sommarskog

Prev by Date: Re: Best practice for storing long text fields
Next by Date: stored proc bug with datetime variable
Previous by thread: SQL Between Dates
Next by thread: Re: export to sql 2005
Index(es):
- Date
- Thread

Relevant Pages

Re: yes or no fields
... data that has an entry in your "lost days" qry. ... Maybe someone a bit more into SQL can jump in. ... To fix your query, you would need to share it with us. ... need any criteria under those fields. ...
(microsoft.public.access.queries)
Re: SQL Losing Data
... data that was entered after coming out of the subform was lost about ... Neil ... > users are complaining that unsaved data is being lost when they move to a ... > Is this something with SQL 7 when it's dealing with new tables? ...
(microsoft.public.sqlserver.odbc)
Re: L
... She is a lost cause. ... Come on, Cimode. ... predates and is not tied to SQL or relational theory. ... a legitimate angle on it. ...
(comp.databases.theory)
Re: Transferring Database to SQL Server
... It is in VFP. ... is a hodgepodge language though. ... why is it required to switch from DBFs to SQL? ... would it be if it crashed today and they lost everything since the last ...
(microsoft.public.fox.programmer.exchange)
Re: Top lines from SQLBASE table
... no standard way in SQL to define the "TOP". ... One day I will post a funny story here, about how I lost my job after ...
(comp.databases)