General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2008
>>>Hello all,
>>>
>>>I am pulling my hair out. I have a SQL database on my local machine and a SQL database on my web host. I am trying to move my database with the data contained to the other SQL Server. Both are SQL 2008 10.0.2531. When I right click my database, choose tasks, then pick backup I get a backup file of my database. Then when I restore that data to the other SQL Server there are three missing tables. Every time! What am I doing wrong or what might cause this? I really need those three tables and they contain too much data for me to re-create them. The other table have data and they come over.
>>>Thanks
>>>Tim
>>
>>Did you try scripting only these 3 missing tables?
>I am not sure how to script them to include the data in them. Is that available on the menu somewhere?
>Tim
In VisualStudio server explorer you can right click on a database and then select publish. That'll script creating the tables and adding in all your data. I've used this to move data to another server where I couldn''t attach files.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only