Member Avatar for HunainHafeez

i have a table for cities and data which has entries in LACS , now i want to copy that table from one database to another, is it possibe ? i googled but couldn't find reliable solution mean i have fear to loss data .s o anybody , plz suggest me a way to copy . thanks

  • 2 Contributors
  • 2 Replies
  • 143 Views
  • 41 Minutes Discussion Span
  • Latest Post Latest Post by HunainHafeez
Member Avatar for pritaeas

Sure you can. If your user has access to both databases then you can just use a query (after creating the same table on the other database). If you don't, just make a backup with SSMS and restore it on the other database.

Simplest way is probably in SSMS, right click your database, select Tasks, and then Generate scripts.

Edited by pritaeas
Member Avatar for HunainHafeez

ok ok , in tasks i founf IMPORT option and i used that and i worked. thanks mate !!!

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.