i need to retrive exact data basing on date from users table.I have 10 lakhs records in which i need to pick up only 2 lakh records which inserted on Nov 30 2012 by using this query i got the records select * from patients where convert(date,CreatedDate) = '2012-11-30' order by 1 desc but how can i get the these 2 lakh records and move into another server...with in 10 lakhs i need only 2 lakhs and i need to move to another server
Case1: First of all, you need to connect to Server B. Once connected, you need to link Server A to Server B. In SQL Mngmt Studio , this can be done by right-clicking Linked Servers under the Server Objects field and adding the new linked server. Then you need to run a query similar to the one below.
INSERT INTO ServerB.DatabaseName.dbo.TableName (SELECT * FROM ServerA.DatabaseName.dbo.TableName)
Where ServerA is the server name of Server A, similar for ServerB and DatabaseName is the name of the databases on each server
Case2: By using Import/Export wizard (If you have difficulty with linked server) First insert your required data into another table And then use this table with Import/export wizard