- RESTORE DATABASE cbstest
- FROM DISK = 'C:\JLV_CON_20180131_IMP.DAT'
- WITH RECOVERY,
- MOVE 'cbstest' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\cbstest.mdf',
- MOVE 'cbstest_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\cbstest.ldf'
how to restore .Dat extention to mssql 2008....
this JLV_CON_20180131_IMP.DAT genrate from oracle db
how to restore to mssql2008
Shahriar NikkhahPosted Apr 21, 2018, 2:54 PM
- Surrogate Keys
- Natural Keys
- PK
- FK
- Index
- Relations
- Table Partitions (maybe)
- etc.......
Good luckNitin SontakkePosted Apr 8, 2018, 5:21 AM