Migrating Dbase data to SQL Server

[ecugrad]

Does anybody have any documentation or knowledge in the best way to migrate a dbase tables to SQL Server. We plan to convert the data over soon and I will be the one who has no knowledge to do it..

Mike

 

[vongrunt]

dbase as .DBF? Just ask.

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[bborissov]

Mike,
There is no easy way to migrate, you could easy transfer data from your files to SQL server tables, but you should rethink whole application so it acts like real Client/Server application. I am in the middle of this and I could tell you that to build new database in SQL Server is much easier that think how to save the present architecture of your appliction.
But as I said transfering the data is the easiest part just build some DTS and your data will be in SQL Server.

Borislav Borissov

 

[ecugrad]

Thanks for the info..

Mike