tags:

views:

44

answers:

1
Q: 

Data Migration : What way is the best way to Migrate?

hi All,

I am doing data migration two database in MS SQL 2005. The records are more than 200000 nearly 300000. I need to query from source database using joins and insert 2 or 3 tables in destination databse.

Which way is the best way to do so? Please suggest me. I am trying to write a program with VB.NET. If you have sample, please show me the way how to.

Thanks in advance, RedsDevils

+1  A: 

Is the issue with the source data well defined? If so, then you can just use Linked Servers, and query from one database and insert into the target filtering out the bad data using your select query. This would remove the need to write anything in .NET...

davisoa  2010-10-13 03:59:07
Ok I will try this!
RedsDevils  2010-10-13 04:04:43
Linked Servers is for Different Server? How can I access different Databases in Same Server?
RedsDevils  2010-10-13 06:31:18
You can do that by ensuring you have access to both databases on your current connection, and then prefix the table names with the names of the databases you need. i.e. INSERT INTO Database2.dbo.Table1 (fieldnames) SELECT * FROM Database1.dbo.Table1
davisoa  2010-10-13 22:21:21

related questions

What are the most important functional differences between C# and VB.NET?
Setting Group Type for new Active Directory Entry in VB.NET
ASP.Net Datagrid: in Footer calculate Avg or Sum for column
Opening a file in my application from File Explorer
HTML Email Editor in a Windows Forms Application
Datatables, Dataviews and distincts! (ASP.Net/VB)
Naming convention for VB.NET private fields
Visual Studio - new "default" property values for inherited controls
Change the width of a scrollbar
Is String.Format as efficient as StringBuilder
Default Form Button in FireFox
VB.NET - IsNothing versus Is Nothing
'Break' equivalent keyword for VB
What is the best way to wrap time around the work day?
Best SVN Client Ignore Pattern for VB.NET Solutions?
Long-time LAMP Developer moving to VB.NET
What's the best way to find long-running code in a Windows Forms Application
What is the best way to deploy a VB.NET application?
'Best' Diff Algorithm
Setting Objects to Null/Nothing after use in .NET
CSV File Imports in .Net
How do you migrate a large app from VB6 to VB .net ?
Floating Point Number parsing: Is there a Catch All algorithm?
Decoding T-SQL CAST in C#/VB.net
Reliable Timer in a Console Application