Timeline for Copying (hundreds of) tables from one server to another (with SSMS)
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 4, 2015 at 6:22 | comment | added | Vini | @AaronBertrand : OK. I too had the same question. But when I imported datetime was also converted to smalldatetime | |
| Dec 3, 2015 at 15:01 | comment | added | Aaron Bertrand | @Vini you can also use the Generate Scripts wizard, which does allow you to copy indexes (I don't know if it reliably generates a script in proper dependency order, though - I've always used RedGate SQL Compare for that). | |
| Dec 3, 2015 at 10:19 | comment | added | Vini | why doesn't the import/export copy the indices and dependencies? wouldn't it be too difficult to recreate the indices for 466 tables? | |
| Dec 1, 2015 at 17:28 | comment | added | user507 | Can also do the same Export task via PowerShell if interested. Similar script to perform this action is in my answer here: dba.stackexchange.com/a/122149/507 | |
| Dec 1, 2015 at 17:27 | vote | accept | Der Kommissar | ||
| Dec 1, 2015 at 17:22 | history | edited | Alex | CC BY-SA 3.0 | deleted 38 characters in body |
| Dec 1, 2015 at 17:20 | history | answered | Alex | CC BY-SA 3.0 |