Skip to main content
Format.
Source Link
Michał Powaga
  • 23.4k
  • 8
  • 55
  • 62
  1. Script the 'create table'create table in management studio, run that script in bar to create the table. (Right click table in object explorer, script table as, create to...)

  2. INSERT bar.[schema].table SELECT * FROM foo.[schema].tableINSERT bar.[schema].table SELECT * FROM foo.[schema].table

  1. Script the 'create table' in management studio, run that script in bar to create the table. (Right click table in object explorer, script table as, create to...)

  2. INSERT bar.[schema].table SELECT * FROM foo.[schema].table

  1. Script the create table in management studio, run that script in bar to create the table. (Right click table in object explorer, script table as, create to...)

  2. INSERT bar.[schema].table SELECT * FROM foo.[schema].table

added 14 characters in body
Source Link
ScottStonehouse
  • 25.2k
  • 7
  • 34
  • 34
  1. Script the 'create table' in management studio, run that script in bar to create the table. (Right click table in object explorer, script table as, create to...)

    Script the 'create table' in management studio, run that script in bar to create the table. (Right click table in object explorer, script table as, create to...)

  2. INSERT bar.[schema].table SELECT * FROM foo.[schema].table

    INSERT bar.[schema].table SELECT * FROM foo.[schema].table

  1. Script the 'create table' in management studio, run that script in bar to create the table. (Right click table in object explorer, script table as, create to...)
  2. INSERT bar.[schema].table SELECT * FROM foo.[schema].table
  1. Script the 'create table' in management studio, run that script in bar to create the table. (Right click table in object explorer, script table as, create to...)

  2. INSERT bar.[schema].table SELECT * FROM foo.[schema].table

Source Link
ScottStonehouse
  • 25.2k
  • 7
  • 34
  • 34

  1. Script the 'create table' in management studio, run that script in bar to create the table. (Right click table in object explorer, script table as, create to...)
  2. INSERT bar.[schema].table SELECT * FROM foo.[schema].table