General discussion

Locked

SQL Server Questions

By azelan ·
When transfering a table from SQL 6.5 to SQL 7, how can i preserve the primary key from the table. Seems that every time i do transfer, all the Primary keys will gone and need to manually set it. How to schedule SQL Server an automated shutdown?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL Server Questions

by mattohare In reply to SQL Server Questions

I can answer the first question, I believe. If you use the Data Transformation Wizard that comes with SQL Server 7, then you should be able to choose "Transfer Database Objects" on the third page of the wizard. This is the page just after choosingthe destination of the data. This is the only option that transfers all of the data schema in addition to the data itself.

As far as scheduling an automated shutdown, I think it's in the pulldown menus of a wizard too, but I dont really know.

Collapse -

SQL Server Questions

by azelan In reply to SQL Server Questions

The question was auto-closed by TechRepublic

Collapse -

SQL Server Questions

by maxwell edison In reply to SQL Server Questions

http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechnol/sql/proddocs/diag/75528frt.asp

(REMOVE SPACES from the pasted URL.)

Take a look at the index on the left of the page. I think you may find a chapter to describe a process that may be helpful.

Maxwell

Collapse -

SQL Server Questions

by azelan In reply to SQL Server Questions

The question was auto-closed by TechRepublic

Collapse -

SQL Server Questions

by azelan In reply to SQL Server Questions

This question was auto closed due to inactivity

Back to Networks Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums