Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup & Replicate Databases

Status
Not open for further replies.
RPG42

RPG42

Programmer
Jan 7, 2005
12
0
0
US
Hi,

Not sure if this is the right forum, but I need to know how to basically duplicate and export databases and sort them by year.

So I want to take "PlantData" and create

PlantData2001 = all 2001 records
PlantData2002 = all 2002 records
PlantData2003 = all 2003 records

I figured out how to export databases, but things like the primary keys aren't transferring over.
 
Status
Not open for further replies.

Similar threads

Niki_S
  • Locked
  • Question
Create view using two databases
Replies
4
Views
80
Chris Miller
Chris Miller
Niki_S
  • Locked
  • Question
Add two databases for connection between sql and foxpro
Replies
1
Views
51
Chris Miller
Chris Miller
Olaf Doschke
  • Locked
  • Question
backup strategy
Replies
0
Views
16
Olaf Doschke
Olaf Doschke
davism
  • Locked
  • Question
1 SP on a different DB to used for multiple databases
Replies
3
Views
49
gmmastros
gmmastros
BeeTrees
  • Locked
  • Question
How to list all the databases/Schema/tablenames used in SSRS Reprts' datasets.
Replies
2
Views
21
simian336
simian336

Part and Inventory Search

Sponsor

Back
Top