Member Avatar for lyxus

Hello Guys,

I was dumped in the middle of a project with not a lot of experience in MS SQL server.

I have 3 little questions

1) If i receive a bak file(restore file) from another server, is it normal that if i restore the file i will no see any FK keys neother Primary keys ?

2)
Is there anyway to have the INSERT query of the data ?
I mean a for a table a full (re)creation, i was able to have the CREATE TABLE but not the insert ? Any ideas?

3) Is there any tool that can transfer from SQL SERVER to Excel, i bought one several minutes ago but it hangs (more than 220 000 records)

Thanks for you help !

It is really appreciated !

Franck

  • 2 Contributors
  • 1 Reply
  • 52 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by dickersonka
Member Avatar for dickersonka

1. no, you should still have your complete db, make sure they did a full backup

2. don't understand, where are you getting this data from? the backup?

3. you can do it right in sql server, depending on your version its either DTS or SSIS

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.