Hello,
I have a SQL server's Data file (.DAT ) which is very huge 63GB in size and I need to upload this file into a newly created SQL Server database.
Is there any utility or menu option which i can use (like Import data option under data transformation option) or should I write any stored procedure to get this done.
I have restored data from .BAK file but never from .DAT file.
Any suggestions will be very helpful.
Thank You
nath
I have a SQL server's Data file (.DAT ) which is very huge 63GB in size and I need to upload this file into a newly created SQL Server database.
Is there any utility or menu option which i can use (like Import data option under data transformation option) or should I write any stored procedure to get this done.
I have restored data from .BAK file but never from .DAT file.
Any suggestions will be very helpful.
Thank You
nath