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

5 Years
Discussion Span
Last Post by HunainHafeez

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


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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.