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
HunainHafeez
9
Posting Whiz
Recommended Answers
Jump to PostSure 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 …
All 2 Replies
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
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.
HunainHafeez
9
Posting Whiz
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.